Description: Problem: In 11i, Customers are accessed through Oracle forms where: block. Field reference is allowed to bring values in value sets dynamically. But in R12, Customers are accessed through…
Read MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreDescription: 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 More