GL DRILL Down Query From GL into Fixed Assets Sub ledger Module.
Introduction This Post is about to GL DRILL Down Query From GL into Fixed Assets Sub ledger Module in oracle ebs r12. The below query will provide the complete…
Read MoreGL DRILL Down Query From GL into Cost Management Sub ledger Module.
Introduction The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(receiving,inventory, WIP sources) sub-ledger modules. –SK Receiving Source: SELECT …
Read MoreAP Invoice Interface Errors & Fix
Introduction This Post is about to AP Invoice Interface Errors & Fix in oracle ebs R12. DUPLICATE LINE NUMBERINVALID DISTRIBUTION ACCT ZX_IMP_TAX_RATE_AMT_MISMATCH NO EXCHANGE RATE INVALID ASSIGNMENT INVALID…
Read MoreTDS Register Report
Introduction This Post is About to fetch Vendor Wise RO Account Ledger details in oracle ebs R12. Below Query will fetch Vendor Wise RO Account Ledger details SELECT * FROM…
Read MoreAPI to Create Bank Account Details
Introduction This Post is About to API to Create Bank Account Details in oracle ebs r12. Below procedure will create Supplir Bank account details PROCEDURE create_banks_accounts(p_change_type VARCHAR2) AS ln_count …
Read MoreSupplier Information including GST
Introduction This Post is sabout to fetches all the supplier information including GST Info in oracle ebs R12. The below query fetches all the supplier information including GST Info…
Read MoreJBO-25006: Invalid parameter value – Resolution
Description: Error: JBO-25006: Invalid parameter value PosViewShipmentsVO for destination passed to method ViewLinkImpl.setDestination. Explanation: view def mismatch. Root Cause for the Error : While extending a Seeded VO ( that has a Seeded…
Read MoreQuery to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA
Description: We will discuss about xla tables in r12. We all know that accounting from sub-ledgers transfer to general ledger through the xla /SL module. So to fetch the data…
Read MoreQuery to Link AP Payments, GL and SLA Tables: R12 AP GL XLA
Description: All accounting performed before transfer to the GL. Accounting data generated and stored in “Accounting Events” tables before transfer to GL. Run “Create Accounting” to populate accounting events (SLA)…
Read MoreQuery to Link AP Invoices, Payments, GL and SLA Tables: R12 AP GL XLA
Description: In R12, AP does not store any accounting information. Reconciliation of the posted transactions is done using data in the Sub ledger Accounting (SLA) tables. SELECT /*+ Index(xdl XLA_DISTRIBUTION_LINKS_N3) */…
Read More