EBS Functional

iExpenses – change the lable name in template

From Sysadmin Responsibility: Navigate to the Functional Administrator responsibilityà Personalization. Provide Document path like “/oracle/apps/ap/oie/WebUI/OIEREVIEWSUMMARY” and click on GO tab and from search results Personalize Page icon as shown in the below…

Read More

How to Prepare the OTBI Reports in Oracle Fusion

Description OTBI is a set of pre-seeded yet customizable analysis structures that Oracle Applications users can access to create ad hoc reports, dashboards, and alerts to aid daily decision-making. OBIEE…

Read More

Auto Lock Box – Basic Concepts and Implementation Steps

Description : => Lockbox is a service offered by banks to companies in which the company receives payments from their customers by mail to a post office box, and the bank…

Read More

How to Prepare the BI Reports in Oracle Fusion Applications

Description Oracle Business Intelligence Publisher (BI Publisher, formerly XML Publisher) is an enterprise reporting solution that streamlines report and form generation. With a single template, it can generate reports in…

Read More

How to get the DBC file for a particular instance

Description:  DBC file is simply a database format structured around CAN Messages and Signals. The DBC format is proprietary, but a number of online DBC wikis detail the basic concepts.…

Read More

Problems while creating the New Locations in Oracle R12.2

Description: Use this window to define each work location used by your enterprise. This window contains information and notified the problems, such as Inventory Organization, that is used by other…

Read More

Order Management Under Shipment Tolerance functionality while splitting the order lines in R12.2

Description: Oracle Order Management provides you with the ability to capture shipping tolerance levels for over and under shipments recorded during ship confirmation. The shipping tolerance feature enables you to define various shipping tolerance. levels for ordered…

Read More

Lockbox – 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 More

Oracle Forms – Dynamic Message Tool Tip

Introduction This Post is about to oracle forms-Dynamic Message Tool Tip in oracle EBS-R12   Multiple tooltip message in single text field Step 1:- Create canvas and Using the below…

Read More

Query to fetch Customer Statement of Account Details

Description: Query to fetch Customer Statement of Account Details SELECT   rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operating_unit, DECODE (ps.CLASS, ‘INV’, ‘Invoice’, ‘DM’, ‘Debit Memo’, ‘DEP’, ‘Deposit’, ‘CM’, ‘Credit Memo’, ‘PMT’, ‘Receipts’…

Read More