SYMPTOMS
Need to assign new Inventory Orgs to a location on the locations form on the "Other Details" tab. However, an error message is received when this is attempted:
LOV contains no values.
CAUSE
There must be a row in the view FINANCIALS_SYSTEM_PARAMETERS for the SET_OF_BOOKS_ID associated with the organization if it is to be selected on the Locations form.
This query returns the set_of_books_id associated with the organization:
select organization_id, business_group_id, organization_name, set_of_books_id
from ORG_ORGANIZATION_DEFINITIONS;
This query determines if there is a row for the set_of_books_id identified in the first query:
select *
from FINANCIALS_SYSTEM_PARAMS_ALL
where set_of_books_id in (<set_of_books_ids from previous query>);
The FINANCIALS_SYSTEM_PARAMS_ALL table populates the FINANCIALS_SYSTEM_PARAMETERS view.
select *
from FINANCIALS_SYSTEM_PARAMETERS
where set_of_books_id in (<set_of_books_ids from previous query>);
Also, the inventory organization field can only be entered in the Location form if either (or both) INV or PO is fully installed.
The following query returns the installation status of these two modules:
select p.application_id, p.status, a.application_short_name
from fnd_product_installations p, fnd_application a
where p.application_id = a.application_id
and a.application_short_name in ('PO','INV')
SOLUTION
Using an Inventory or Purchasing responsibility, navigate Setup > Organizations > Set of Books to ensure a set of books has been selected.
This creates a row in the FINANCIALS_SYSTEM_PARAMS_ALL table, which populates the FINANCIALS_SYSTEM_PARAMETERS view.
Once the set of books has a row in this view, the inventory organization will appear in the LOV on the Locations form.
