Description: We can change the LOV query using form personalization. Sample provided below (Payment form). Requirement: We have to change the “type” field lov query for populating the custom…
Read MoreDescription: Oracle Applications provides you with predefined printer types, print styles, and printer drivers. Use the Printer Types form to query the combinations of print style and printer driver that…
Read MoreDescription: This blog explains the process and steps to develop BI data templates with excel. Steps in Brief: Create XML data template. Create a concurrent program with executable XDODTEXE.…
Read MoreDescription: 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 Moreintorduction 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 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 More