EBS Functional

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

AR Receipt Distribution Query: AR XLA GL

Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL   SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…

Read More

Period End Processing of Oracle Inventory and Cost management in oracle apps

1. Description Oracle Inventory provides the features you need to summarize costs related to inventory and manufacturing activities for a given accounting period and distribute those costs to the general ledger…

Read More