Orygina\u0142: http:\/\/www.oracleerp4u.com\/2010\/06\/r12-sla-subledger-accounting.html
\n1) All accounting performed before transfer to the GL. Accounting data generated and stored in \u201cAccounting Events\u201d tables prior to transfer to GL<\/p>\n
2) Run \u201cCreate Accounting\u201d to populate accounting events (SLA) tables. User can \u201cView Accounting\u201d only after \u201cCreate Accounting\u201d is run. Create Accounting process
\n\u2013 Applies accounting rules
\n\u2013 Loads SLA tables, GL tables
\n\u2013 Creates detailed data per accounting rules, stores in SLA \u201cdistribution links\u201d table<\/p>\n
3) Below are the key tables for SLA in R12<\/p>\n
XLA_AE_HEADERS xah
\nXLA_AE_LINES xal
\nXLA_EVENTS xae
\nXLA_TRANSACTION_ENTITIES xte
\nXLA_DISTRIBUTION_LINKS xdl
\nGL_IMPORT_REFERENCES gir<\/p>\n
Below are the possible joins between these XLA Tables<\/p>\n
xah.ae_header_id = xal.ae_header_id
\nxah.entity_id = xte.entity_id
\nxae.entity_id = xte.entity_id
\nxah.event_id = xlae.event_id
\nxah.ae_header_id = xdl.ae_header_id
\nxah.ae_line_num = xdl.ae_line_num
\nxah.event_id = xdl.event_id
\nxal.gl_sl_link_id = gir.gl_sl_link_id
\nxal.gl_sl_link_table = gir.gl_sl_link_table
\nxah.application_id = xal.application_id
\nxal.application_id = xte.application_id
\nxte.application_id = xdl.application_id
\nxae.application_id = xte.application_id
\nxah.application_id = xae.application_id
\nxah.application_id = (Different value based on Module)<\/p>\n
xte.entity_code =
\n'TRANSACTIONS’ or
\n'RECEIPTS’ or
\n'ADJUSTMENTS’ or
\n'PURCHASE_ORDER’ or
\n'AP_INVOICES’ or
\n'AP_PAYMENTS’ or
\n'MTL_ACCOUNTING_EVENTS’ or
\n'WIP_ACCOUNTING_EVENTS’<\/p>\n
xte.source_id_int_1 =
\n'INVOICE_ID’ or
\n'CHECK_ID’ or
\n'CUSTOMER_TRX_ID’ or
\n'TRANSACTION_ID’<\/p>\n
XLA_DISTRIBUTION_LINKS table join based on Source Distribution Types
\nxdl.source_distribution_type = 'AP_PMT_DIST ’
\nand xdl.source_distribution_id_num_1 = AP_PAYMENT_HIST_DISTS.payment_hist_dist_id
\n—————
\nxdl.source_distribution_type = 'AP_INV_DIST’
\nand xdl.source_distribution_id_num_1 = AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id
\n—————
\nxdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL’
\nand xdl.source_distribution_id_num_1 = AR_DISTRIBUTIONS_ALL.line_id
\nand AR_DISTRIBUTIONS_ALL.source_id = AR_RECEIVABLE_APPLICATIONS_ALL.receivable_application_id
\n—————
\nxdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL’
\nand xdl.source_distribution_id_num_1 = RA_CUST_TRX_LINE_GL_DIST_ALL.cust_trx_line_gl_dist_id
\n—————
\nxdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS’
\nand xdl.source_distribution_id_num_1 = MTL_TRANSACTION_ACCOUNTS.inv_sub_ledger_id
\n—————
\nxdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS’
\nand xdl.source_distribution_id_num_1 = WIP_TRANSACTION_ACCOUNTS.wip_sub_ledger_id
\n—————
\nxdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER’
\nand xdl.source_distribution_id_num_1 = RCV_RECEIVING_SUB_LEDGER.rcv_sub_ledger_id<\/p>\n","protected":false},"excerpt":{"rendered":"
Orygina\u0142: http:\/\/www.oracleerp4u.com\/2010\/06\/r12-sla-subledger-accounting.html 1) All accounting performed before transfer to the GL. Accounting data generated and stored in \u201cAccounting Events\u201d tables prior to transfer to GL 2) Run \u201cCreate Accounting\u201d to populate accounting events (SLA) tables. User can \u201cView Accounting\u201d only … Czytaj dalej