Enterprise Resource Planning and Integrations BlogSpot

Skip to content

XLA_DISTRIBUTION_LINKS

XLA_DISTRIBUTION_LINKS

  • by Yogesh Pachpute
  • Posted on February 20, 2018February 22, 2018
  • Payables Period Close

 Why XLA_DISTRIBUTION_LINKS table cannot be used while reconciling to GL This table contains the link between transactions and subledger journal entry lines. Provide more accurate information as how GL lines or XLA_AE_LINES are derived from […]

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

Data flow between AR and SLA

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

Data flow between AR and SLA Queries to retrieve data from XLA tables for a given AR transaction Q1) Get the customer_trx_id for the transaction number SELECT * FROM ra_customer_trx_all WHERE trx_number = &trx_number; Q2) […]

Read More

How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

  • by Yogesh Pachpute
  • Posted on October 17, 2017February 6, 2018
  • Payables

How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger? This table contains the link between transactions and subledger journal entry lines. Module: Payables Column – EVENT_ID: Invoice/Payment In case of invoice it will be […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Fixed Asset (23)
  • General Ledger (19)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • Oracle Installations (3)
  • Oracle Inventory (1)
  • Oracle SQL (4)
  • Order Management (1)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (16)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • SubLedger Accounting (25)
  • 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 17 other followers

Calendar

Calendar

March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr    
Blog at WordPress.com.