My Oracle Support Banner

Loader Worker With Direct Load Option, Gets Error MSCSLD : Error In Main 103 : Table_name_str MSC_ITEM_SOURCING (Doc ID 2459559.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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


When attempting to run a plan, the following error occurs in the Loader Worker

Check the revised columns in MSC.MSC_ITEM_SOURCING:
Selecting REVISED COULMNS 0:00
ORA-01405: fetched column value is NULL
  MSCSLD : Error in main 103 : table_name_str MSC_ITEM_SOURCING 2001
Error string=
Statement with the error:
declare lv_return_status VARCHAR2 ( 2048 ) ; lv_msg_data VARCHAR2 ( 20

APP-FND-01630: Cannot open file /u01/122/fs2/inst/apps/EBSQA_mid-ebsqa01/appltmp/OF3Hz1nK.t for reading
Cause: USDINS encountered an error when attempting to open file /u01/122/fs2/inst/apps/EBSQA_mid-ebsqa01/appltmp/OF3Hz1nK.t 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.

The issue can be reproduced at will with the following steps:
1. Run the plan

The issue has the following business impact:
Due to this issue, users cannot continue with planning.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.