Highlight Data in different colors Using CSS
Introduction This Post is about to Highlight Data in different colors Using CSS in Oracle EBS R12. Use the below code in report query to highlight data with different colors…
Read MoreLockbox – Error Handling
intorduction this post is about to Submit postQuickcash for records struck in the interfac Lockbox – Error Handling Submit postQuickcash for records struck in the interface. Query with Transmission Name…
Read MoreGL 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 More