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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: In R12, we have tables that holds link between any sub-ledger data to General ledger data. The below query gives you the important columns available in the XLA tables and GL…
Read MoreDescription: Account payable trial balance is used to verify payable liabilities that are mentioned in the general ledger. This helps the businesses while reconciling their bank statements. Trial balance includes subtotal of unpaid and partially paid invoices…
Read MoreIntroduction This query fetches all the expenses incurred on a project,and also captures the debit and credit account transaction wise that will help in reconcilation of data with GL. …
Read MoreDescription: Every data should be stored in the database because the world can’t run without storing the data’s in the database. Machinery world should save data in a database for future reference and process so that…
Read MoreIntroduction This Post is about to Supplier details with banks query in oracle r12. Query for Supplier details with banks. SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”…
Read MoreDescription: All of these APEX security exposure vulnerabilities can be avoided by careful configuration, but there are many potential security exposures to consider. There are several areas of potential APEX…
Read More