EBS Technical

How to Process the Stuck Purchase Orders with an Pending “Respond to Changes” Action

Description: Requisitions are created using either from the Core Purchasing or Internet Procurement responsibilities. Then the requisitions will be converted into Purchase Orders using either Buyers Work Centre form or…

Read More

How to find error messages while doing Oracle workflow activities from backend

Description: The below workflow help to find out the error messages while doing oracle workflow activities from backend. We are finding error messages while doing workflow activities from the backend.…

Read More

How to change a LOV query Using Forms Personalization

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 More

How to Add or Assign the Printer to a desired Reports

Description: 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 More

Excel Template for BI Publisher Report

Description: 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 More

Eliminating block. field issue while upgrading from EBS R11i to R12 versions

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 More

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 More

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 More

GL 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 More

AP 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 More