Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Payables Reconciliation

Mapping between GL and XLA tables

  • by Yogesh Pachpute
  • Posted on February 7, 2018February 7, 2018
  • General Ledger

How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at […]

Read More

AP Intercompany Accounting and XLA

  • by Yogesh Pachpute
  • Posted on December 19, 2017December 19, 2017
  • Payables

AP Intercompany Accounting and XLA_DISTRIBUTION_LINKS table Question: When I enter intercompany invoice or make an Intercompany payment in R12 EBS, i could see the corresponding sub ledger accounting entries in the “View Journal entries” screen. […]

Read More

What are the tables involved in the Transfer to GL and GL posting

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

What are the tables involved in the Transfer to GL and GL posting? Subledger Tables  XLA_AE_HEADERS  XLA_AE_LINES  XLA_DISTRIBUTION_LINKS  a) Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface […]

Read More

EVENT_STATUS_CODE and PROCESS_STATUS_CODE in XLA_EVENTS Table R12

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

EVENT_STATUS_CODE and PROCESS_STATUS_CODE in XLA_EVENTS Table – EVENT_STATUS_CODE – PROCESS_STATUS_CODE Note:  If an event has event_status_code = P and process_status_code = F but is still in xla_ae_headers with GL_Transfer = No, then the event has […]

Read More

ACCOUNTING_ENTRY_STATUS_CODE Column In XLA_AE_HEADERS Table R12

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

What Does “ACCOUNTING_ENTRY_STATUS_CODE” Column Represent In “XLA_AE_HEADERS” Table? The Column represents Accounting Status of a Transaction Event. The following describes the Values and their Descriptions:  1. If ACCOUNTING_ENTRY_STATUS_CODE = ‘F’ then event is accounted successfully. 2. […]

Read More

What are the setup options that determines if transfer to GL is in detail or summarized mode

  • by Yogesh Pachpute
  • Posted on November 2, 2017April 7, 2018
  • AR Reconciliation

What are the setup options that determines if transfer to GL is in detail or summarized mode There are two variables that determine how the data is transferred to GL from the subledger tables XLA_AE_HEADERS […]

Read More

Columns in XLA_AE_HEADERS and Transfer Status

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

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 = […]

Read More

The Link between GL to SLA and reference columns in GL

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

The Link between GL to SLA and reference columns in GL_IMPORT_REFERENCES Since there is always a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the subledgers.  GL_IMPORT_REFERENCES.gl_sl_link_id => XLA_AE_LINES.gl_sl_link_id  GL_JE_BATCHES.group_id => […]

Read More

Rebuild AP Trial Balance in R12

  • by Yogesh Pachpute
  • Posted on October 11, 2017October 26, 2018
  • Payables

Rebuild AP Trial Balance in R12 To rebuild xla_trial_balances table or create a new report definition.  For better performance of Data Manager run, increase the number of workers to 16,32 or 64  Navigate : Subledger […]

Read More

How to reconciled AP Trial Balance with Payable Transactions for a period

  • by Yogesh Pachpute
  • Posted on October 11, 2017October 26, 2018
  • Payables

How to reconcile AP Trial Balance with Payable Transactions for a given period Get the output of the following for account and period where the difference was observed (In Detail); Now run following reports within […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (25)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Calendar

Calendar

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar