LOADER WORKER WITH DIRECT LOAD OPTION: ORA-01405: FETCHED COLUMN VALUE IS NULL
(Doc ID 2461063.1)
Last updated on MARCH 29, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
On 126.96.36.199, after applying patch 28460969, 'Loader Worker With Direct Load Option' which spawns from 'Memory Based Snapshot 64 bit Linux' completes with the following error:
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 2026
Statement with the error:
declare lv_return_status VARCHAR2 ( 2048 ) ; lv_msg_data VARCHAR2 ( 20
APP-FND-01630: Cannot open file /s20/app/oracle/fs1/inst/apps/vcppat_zvm110-v-pat-icm/appltmp/OF1dIRAA.t for reading
Cause: USDINS encountered an error when attempting to open file /s20/app/oracle/fs1/inst/apps/vcppat_zvm110-v-pat-icm/appltmp/OF1dIRAA.t for reading.
Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.
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