Custom Index Becoming Unusable After Each ASCP Run and Plan Run Fails MSCSLD : Error in main 103 APP-FND-01630
Last updated on MARCH 08, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 184.108.40.206 and later
Information in this document applies to any platform.
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?
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