Skip to main content

Posts

Showing posts with the label AP Table Relation Oracle Apps

Columns in XLA_AE_HEADERS and Transfer Status

What columns in XLA_AE_HEADERS indicate the Transfer Status of accounting data in subledger? The XLA_AE_HEADERS table shows the transfer status of the accounting data, after successful transfer to the GL and Journal Import: XLA_AE_HEADERS.gl_transfer_status_code = Y XLA_AE_HEADERS.gl_transfer_date is not null XLA_AE_HEADERS.group_id is not null For 11i data upgraded to R12, the transfer status can be determined using the following XLA_AE_HEADERS.gl_transfer_status_code = Y XLA_AE_HEADERS.gl_transfer_date is null XLA_AE_HEADERS.group_id is null XLA_AE_HEADERS.upg_batch_id is not null  –> indicates 11i data

AP Open Prepayment Invoice Migration

AP Open Prepayment Invoice Migration Migration Condition: Available prepayment Balance only. One Invoice line for invoice header as balance will be captured in Trail balance of GL. Load in the month of cut over (Go Live minus 1) Payment of prepayment invoice using dummy bank account to make it available for application. Create Accounting for Invoice and Payment and  Post to GL & Reverse the same. Accounting Impact of Migration: Actual Transaction from Legacy system: Type Debit Credit Prepayment * Liability * Paying the prepayment in Legacy: Type Debit Credit Cash * Liability * Prepayment Partially Applied to an Invoice in Legacy system: Type Debit Credit Prepayment * Liability * Item expense * Liability * Open prepayment Migration Type Debit Credit Prepayment 500 Liability 500 Paying the open prepayment: Type Debi...

How to join GL tables with XLA (SubLedger Accounting) tables

How to join GL tables with XLA (SubLedger Accounting) tables GL_JE_BATCHES (je_batch_id)                            => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id)                           => GL_JE_LINES (je_header_id) GL_JE_LINES (je_header_id,  je_line_num)               => GL_IMPORT_REFERENCES (je_header_id, je_line_num) GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) XLA_AE_HEADERS (application_id, event_id)              => XLA_EVENTS (application_id, event_id)    XLA_AE_L...

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...