Organization Security - After Complete Collection Orgs Are Not Available To Assign (Doc ID 451975.1)

Last updated on NOVEMBER 15, 2018

Applies to:

Symptoms

1. Cannot assign Organizations in the Organization Security setup
   
   
2. Trace shows that key SQL below returns no rows
   select organization_code, ORG_INSTANCE, responsibility_id
   from msc_available_orgs_v
   
   
   
3. Find that Data collections ODS Load finished with Warning and log shows message
   
   Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_PARTNER_CONTACTS
   COLUMN=PARTNER_ID, VALUE=
   COLUMN=PARTNER_SITE_ID, VALUE=
   COLUMN=PARTNER_TYPE, VALUE=2
   ORA-01400 : cannot insert NULL into ("MSC"."MSC_PARTNER_CONTACTS"."PARTNER_ID")
   
   
4. SQL to check setups shows that no rows are returned for
   select * from msc_companies where company_id = 1

STEPS
Run data collections for the first time in the new instance

Try to assign orgs in NAV: Advanced Planning Administrator / Admin / Organization Security.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.