Organization Security - After Complete Collection Orgs Are Not Available To Assign
(Doc ID 451975.1)
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
- Cannot assign Organizations in the Organization Security setup
- Trace shows that key SQL below returns no rows
select organization_code, ORG_INSTANCE, responsibility_id
- Find that Data collections ODS Load finished with Warning and log shows message
Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_PARTNER_CONTACTS
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
Run data collections for the first time in the new instance
Try to assign orgs in NAV: Advanced Planning Administrator / Admin / Organization Security.
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