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