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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms