ORG_IDs on Sales Order

ship_to_org_id            SITE_ID of SHIP_TO location for the customer on order


sold_to_org_id            cust_account_id means customer id

invoice_to_org_id        SITE_ID of BILL_TO location for the customer on order

ship_from_org_id         Organization_ID of wearhous from which the material is going to be shipped

How to apply Credit Hold on SO even before Booking the order

We can put all the Sales orders on Credit Check hold for a customer before booking the order.
Open customer details, go to 'Profile: Transaction' tab and enable a check box 'Credit Hold'.

 

This option is available at Customer level as well as Customer site level, you can use whatever applicable.


Please refer Metalink Doc ID 339665.1 for more details.
 

Order Management APIs and open interface

 Order Management APIs and open interface document
CLICK HERE

Get System Administrator Responsibility in Oracle Apps

Please use the following script to get system administrator responsibility

declare
BEGIN
   fnd_user_pkg.addresp (username            => 'DEVENDRA_GULVE',    ---- Give your user name of front end
                         resp_app            => 'SYSADMIN',
                         resp_key            => 'SYSTEM_ADMINISTRATOR',
                         security_group      => 'STANDARD',
                         description         => 'System Administrator',
                         start_date          => SYSDATE,
                         end_date            => NULL
                        );

COMMIT;

END;

Important Profile options for Responsibility

HR:Business Group
HR:User Type
GL Ledger Name
MO: Operating Unit

** Details will be published later...

How to assing item category to function - e.g. Purchasing

Goto: Inventory responsibility > Setup > Item > Categories > Default Category Sets

Here you can assign different Item categories to different functions of Oracle Application.

Requisition Import Problem for OSP / WIP

Issue: After the WIP move to the Outside processing operation, the requisition import is not picking up the record to create the requisition. Even after running work-flow background engine and running Requisition Import program for WIP, Oracle is not picking up records eligible.

Cause: The issue for requisition import not picking up the record was due to the setup 'Requisition Creation Time' on Outside processing tab on WIP Parameters. It was set to 'Manual'.

Solution: Change it to 'At Operation' and it will start working.

ORA-20002: 3207: User 'XXX_does not have access to notification 1234567. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 225 ORA-06512: at line 1

Error :
ORA-20002: 3207: User 'XXX_does not have access to notification 1234567. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 225 ORA-06512: at line 1

Cause:
-The reason for the errors is :-The entry tied to the FND User in question is associated with an Expired Employee.
-To verify this, run this query and enter username when prompted, and if r.EXPIRATION_DATE is less then SYSDATE the issue has been confirmed that the FND User in question is associated with an Expired Employee.

select f.USER_NAME "FND USER NAME", wfr.DISPLAY_NAME, f.END_DATE, r.EXPIRATION_DATE,
wfr.STATUS, wfr.EXPIRATION_DATE, wfr.ORIG_SYSTEM, wfr.PARENT_ORIG_SYSTEM
from apps.fnd_user f, apps.wf_roles wfr, apps.wf_local_user_roles r
where f.USER_NAME=wfr.NAME and wfr.NAME=r.ROLE_NAME and r.user_name = 'XXX_XXXX';

-What has most likely happened is that the Employee / FND User in question had a change to the Employee record that expired an original record while keeping a current record for that employee.
Solution
1. Open the FND Users form and query user in question, and remove the Person field and save.
2. Add back the person field and save again
3. Save the form.
4. Then run the Synchronize WF Local Tables program for ALL
5. If certain documents are stuck in In Process or Pre-Approved status then review datafix below.

Accounting period status check

To check accounting period status:
select * from apps.GL_PERIOD_STATUSES ;

To get APPLICATION_ID , use SQL below:
select * from apps.fnd_application_tl where upper(APPLICATION_NAME) like :APPLICATION_NAME;

To check Inventory accounting period status:
select * from apps.ORG_ACCT_PERIODS
where organization_id= :ORGANIZATION_ID;

To know SET_OF_BOOKS_ID or OPERATING_UNIT or LEGAL_ENTITY or CHART_OF_ACCOUNTS_ID of an organization, use:
SELECT b.* FROM apps.ORG_ORGANIZATION_DEFINITIONS b /*, APPS.HR_OPERATING_UNITS a , */
WHERE b.ORGANIZATION_ID = :ORG_ID

How to check LOCK on any object in Oracle

All locks information is store in table sys.v_$locked_object

select * from sys.v_$locked_object

Object details are in table ALL_TABLES