Inventory Organization Is Not Appearing In The Location Setup LOV for Inventory Organization

 

APPLIES TO:

Oracle Human Resources - Version 12.0.0 and later
Information in this document applies to any platform.
***Relevancy checked - 13-Jan-2013***

SYMPTOMS

On : 11.5.10.2 version, Orgs,Jobs,Locs,Positions etc
Find that an Inventory Organization is not appearing in the Inventory Organization LOV
EXPECTED BEHAVIOR
-----------------------
Expect all Inventory Organizations to appear in the Inventory Organization LOV
STEP
-----------------------
The issue can be reproduced at will with the following steps:
1. Using Inventory Super User Responsibility
2. Inventory > Define Location
3. Query "LocationXXXX" location and under > Other Detail tab
The field called Inventory Organization, the LOV shows only two values
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot select the desired Inventory Organization from the LOV.

CAUSE

The issue is caused by the following setup:
The organization is linked to wrong set of books
NO record in FINANCIALS_SYSTEM_PARAMS_ALL for org_id
The two organizations that are showing in the inventory LOV have the same set of books,
the organization that is new and is NOT showing in the LOV has a DIFFERENT set of book.

SOLUTION

To implement the solution, please execute the following steps:
1. Using System Administrator Responsibility
2. Set Profile options:
MO:Operating Unit = (your choice)
Set of books name = (your choice)
3. Using Purchasing Responsibility and menus,
4. Select setup set of books, choose, and make sure you choose the same set of books.
5. Save.
6. Set the HR: User Type profile option.
7. Retest the issue.
8. Migrate the solution as appropriate to other environments.