Organization Security - After Complete Collection Orgs Are Not Available To Assign
(Doc ID 451975.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10 and laterInformation in this document applies to any platform.
Symptoms
- Cannot assign Organizations in the Organization Security setup
- Trace shows that key SQL below returns no rows
select organization_code, ORG_INSTANCE, responsibility_id
from msc_available_orgs_v - 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") - 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |