Custom Index Becoming Unusable After Each ASCP Run and Plan Run Fails MSCSLD : Error in main 103 APP-FND-01630 (Doc ID 1586871.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.8 and later
Information in this document applies to any platform.

Goal

Users created a custom indexes on table MSC_DEMANDS::New indexes creation on MSC_DEMANDS. Only one index, MSC_DEMANDS_N10 was created as MSC_DEMANDS (PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID).  They also created another custom index MSC_DEMANDS_N11 as well

However the index is getting unusable after every plan run. While debugging, the DBA suggested us to make it as a local index as opposed to Global.

While doing that, the Launch Supply Chain program goes into erro with Error message as

MSCSLD : Error in main 103 : table_name_str MSC_DEMANDS 22
APP-FND-01630: Cannot open file <directory structure> for reading

Cause: USDINS encountered an error when attempting to open file <directory structure> for reading.

Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.

Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.

Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.

How was this resolved?
 

Solution

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