My Oracle Support Banner

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 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?


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.