Implementation Steps for Chart of Accounts in Oracle Apps R12

  Part of this Post contains the below, 1.         Definition of Chart of Accounts 2.         Overview 3.         Graphical Represen...

Read More

what is the Difference between Draft, Final and Final Post in Create Accounting (R12)

Create Accounting in Single Entity DRAFT STAGE :  It will create Journal Entries, which are NOT final, which means they are NOT ready to ...

Read More

Order Management Setup Steps in oracle apps

These are the  following steps for Order Management stepup Step 1: Multiple Organizations  Define multiple organizations in Oracle Inven...

Read More

Assign the Profile option for a specific Level -- script

 For setting a Profile Option Value from back end we need the Following three parameters;     1. Name of Profile Option     2. Value for...

Read More

Sales Order Holds Query (Holds Applied and Released)

SELECT   ooha.header_id,          order_number,          hold_lines.line_id,          oe_order_misc_pub.get_concat_line_number (hold_li...

Read More

Query to find the Purchase Requisition and Purchase Order Details

SELECT DISTINCT prha.creation_date req_creation_date               , prha.segment1 req_no               , prha.authorization_status     ...

Read More

how to find the parameters and their value set given in a concurrent program

SELECT    fcpl.user_concurrent_program_name "Concurrent Program Name",                    fcp.concurrent_program_name "Shor...

Read More