Data Flow From AR To XLA To GL In Oracle APPS

Home » Ar_cash_receipts_all And Xla_ae_headers » Data Flow From AR To XLA To GL In Oracle APPS

Maybe your like

Friday, August 24, 2018

Data Flow from AR to XLA to GL in Oracle APPS

GL tables are linked to Subledger Accounting (XLA tables). Regarding gl_import_references, there is a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES. GL_SL_LINK_ID and GL_SL_LINK_TABLE forms the link between these 2 tables. Drilldown from GL to AR retrieves information from following tables mainly: XLA_EVENTS XLA_AE_HEADERS The main Receivables Headers tables: RA_CUSTOMER_TRX_ALL (Transactions) AR_CASH_RECEIPTS_ALL (Receipts) AR_ADJUSTMENTS_ALL The linking between GL and AR is done between following tables mainly: XLA_TRANSACTION_ENTITIES XLA_SUBLEDGERS GL_JE_SOURCES GL_JE_CATEGORIES GL_IMPORT_REFERENCES GL_JE_HEADERS 11i GL_IMPORT_REFERENCES.reference_10 RA_CUST_TRX_LINE_GL_DIST, AR_RECEIVABLE_APPLICATIONS, AR_MISC_CASH_DISTRIBUTIONS in R12:- SELECT DISTINCT xdl.source_distribution_type FROM gl_import_references gir ,xla_ae_lines xal ,xla_ae_headers xah ,xla_events xe ,xla_distribution_links xdl WHERE gir.je_header_id = :p_je_header_id AND gir.je_line_num = :p_je_line_num AND gir.gl_sl_link_id = xal.gl_sl_link_id AND gir.gl_sl_link_table = xal.gl_sl_link_table AND xal.ae_header_id = xah.ae_header_id AND xah.event_id = xe.event_id AND xah.application_id = xe.application_id AND xah.entity_id = xe.entity_id AND xe.event_id = xdl.event_id AND xdl.ae_line_num = xal.ae_line_num AND xah.ae_header_id = xdl.ae_header_id AND xal.ae_header_id = xdl.ref_ae_header_id RA_CUST_TRX_LINE_GL_DIST_ALL, AR_DISTRIBUTIONS_ALL and AR_MISC_CASH_DISTRIBUTIONS_ALL Below is the Query for AR Invoice (RA_CUST_TRX_LINE_GL_DIST_ALL) SELECT b.* FROM gl_import_references gir ,xla_ae_lines xal ,xla_ae_headers xah ,xla_events xe ,xla_distribution_links xdl ,ra_cust_trx_line_gl_dist_all b WHERE gir.je_header_id = :p_je_header_id AND je_line_num = :p_je_line_num AND gir.gl_sl_link_id = xal.gl_sl_link_id AND gir.gl_sl_link_table = xal.gl_sl_link_table AND xal.ae_header_id = xah.ae_header_id AND xah.event_id = xe.event_id AND xah.application_id = xe.application_id AND xah.entity_id = xe.entity_id AND xe.event_id = xdl.event_id AND xdl.ae_line_num = xal.ae_line_num AND xah.ae_header_id = xdl.ae_header_id AND xal.ae_header_id = xdl.ref_ae_header_id AND xdl.source_distribution_id_num_1 = b.cust_trx_line_gl_dist_id Below is the Query in case of AR_DISTRIBUTIONS_ALL SELECT ada.* FROM gl_import_references gir ,xla_ae_lines xal ,xla_ae_headers xah ,xla_events xe ,xla_distribution_links xdl ,ar_distributions_all ada ,ar_receivable_applications_all araa WHERE gir.je_header_id =:p_je_header_id AND gir.je_line_num = :p_je_line_num AND gir.gl_sl_link_id = xal.gl_sl_link_id AND gir.gl_sl_link_table = xal.gl_sl_link_table AND xal.ae_header_id = xah.ae_header_id AND xah.event_id = xe.event_id AND xah.application_id = xe.application_id AND xah.entity_id = xe.entity_id AND xe.event_id = xdl.event_id AND xdl.ae_line_num = xal.ae_line_num AND xah.ae_header_id = xdl.ae_header_id AND xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND xdl.source_distribution_id_num_1 = ada.line_id AND ada.source_id = araa.receivable_application_id Below is the Query in Case of AR_MISC_CASH_DISTRIBUTIONS_ALL SELECT msd.* FROM gl_import_references gir ,xla_ae_lines xal ,xla_ae_headers xah ,xla_distribution_links xdl ,ar_misc_cash_distributions_all msd ,ar_distributions_all dist ,ar_cash_receipts_all acr ,ar_receivables_trx_all art where gir.je_header_id = :p_je_header_id AND gir.je_line_num = :p_je_line_num AND gir.gl_sl_link_id = xal.gl_sl_link_id AND xah.ae_header_id = xal.ae_header_id AND xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND xdl.event_id = xah.event_id AND xah.ae_header_id = xdl.ae_header_id AND msd.event_id = xah.event_id AND msd.misc_cash_distribution_id = dist.source_id --AND dist.source_type = 'MISCCASH' AND acr.cash_receipt_id = msd.cash_receipt_id AND acr.type = 'MISC' AND art.receivables_trx_id = acr.receivables_trx_id at August 24, 2018

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records

  • FNDLOAD to Download and Upload XML Publisher Data Template (.xml) Report The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
  • Query to get OM Order Types in Oracle Apps SELECT HAOU.NAME "Operating Unit",          OTTT_H.NAME "Transaction Type",          OTTT_H.DESCRIPTION "Descripti...
  • SQL Query To Get Invoice Validation And Accounting Status For The Given Check Number (Doc ID 2975480.1) SELECT aca.check_number       ,aia.invoice_id   ,aia.invoice_num   ,aia.invoice_amount   ,distribution_line_number   ,aida.accrual_p...

Total Pageviews

Search This Blog

  • Home

About Me

ERP(Oracle&Python) View my complete profile

Followers

Report Abuse

Labels

  • 11i Vs R12
  • 12.1.3+ Property Manager
  • 12.2 Property Manager
  • 12.2.4 AP Features
  • 12.2.4 Property Manager
  • 12.2.5 CM
  • 12.2.8 FA
  • 12.2.8 Property Manager
  • 12.2.8+ FA
  • 12.2.9 AP Features
  • 12.2.9 FA
  • 12.2.9 Projects Costing
  • 12.2.9 Property Manager
  • Absence Management
  • Accounting
  • Accouting Hub
  • ADF DI
  • Alerts
  • ANC
  • AOL
  • AP
  • AP-SLA-GL
  • API
  • Application-Object-Library-Lookup
  • AR
  • AR-Lockbox
  • Assets
  • Attachment
  • Auto Lockbox
  • AWT Invoice
  • Bank
  • Business Events
  • Business-Classification
  • CHR(10)
  • CLOB
  • CM
  • Contingent Workers
  • Contracts
  • Customer
  • Data Migration
  • DATE
  • DB-Link
  • DBI
  • dbms_xmlgen
  • DFF
  • e-Text
  • EB-Tax
  • Element
  • Email
  • Employee
  • Expenses
  • FA
  • Fast Formulas
  • FND
  • Form Personalization
  • Freight
  • FSM
  • Fusion
  • Fusion Vs EBS R12
  • Geography
  • GL
  • Grade
  • GRN
  • HRMS
  • Interfaces
  • Interview Questions
  • Inventory Interface
  • Invoice
  • Items
  • jdr_utils
  • Journal
  • KFF
  • Legal Entity
  • Loans
  • Lookups
  • MOAC
  • Multi-Org
  • OAF
  • OLFM
  • OM
  • OPM
  • Oracle
  • Oracle APEX
  • Oracle Forms
  • Oracle Fusion
  • Oracle Fusion HCM
  • Oracle Fusion Inventory
  • Oracle Fusion Payables
  • Oracle Inventory
  • Oracle Payroll
  • Order Management
  • OTBI
  • Patch
  • Payables
  • Payment
  • Performance Rating Calculation
  • PhoneNumber
  • PMS
  • PO
  • PO_TYPE
  • Pricing
  • Profile Options
  • Projects
  • Property Manager
  • QP
  • Queries
  • R12
  • Receipts
  • Receivables
  • REPLACE
  • Reports
  • Retirement
  • RTF
  • Sales Invoice
  • Schema
  • SO
  • SQL
  • SQL/PLSQL
  • Status
  • Supplier
  • SupplierAddressImportTemplate
  • Suppliers - Oracle Fusion
  • Tables
  • TCA
  • Trial Balance
  • Tuning/DBA/Oracle APPS
  • Unix/Linux
  • UTL_FILE
  • VBCS
  • Workflow
  • XML Publisher
  • XML-Oracle

Blog Archive

  • January 2026 (1)
  • November 2025 (2)
  • September 2025 (3)
  • February 2025 (1)
  • January 2025 (29)
  • December 2024 (27)
  • July 2024 (1)
  • January 2024 (4)
  • November 2023 (1)
  • June 2023 (1)
  • March 2023 (1)
  • February 2023 (1)
  • January 2023 (4)
  • December 2022 (3)
  • November 2022 (2)
  • October 2022 (9)
  • September 2022 (2)
  • August 2022 (16)
  • July 2022 (9)
  • June 2022 (65)
  • May 2022 (4)
  • March 2022 (1)
  • February 2022 (3)
  • January 2022 (12)
  • December 2021 (28)
  • November 2021 (37)
  • October 2021 (36)
  • September 2021 (7)
  • August 2021 (8)
  • July 2021 (15)
  • June 2021 (37)
  • May 2021 (38)
  • February 2020 (3)
  • January 2020 (2)
  • April 2019 (5)
  • March 2019 (5)
  • February 2019 (28)
  • January 2019 (8)
  • December 2018 (2)
  • November 2018 (8)
  • October 2018 (8)
  • September 2018 (51)
  • August 2018 (21)
  • July 2018 (26)
  • November 2017 (39)
  • October 2017 (309)

Tag » Ar_cash_receipts_all And Xla_ae_headers