My Oracle Support Banner

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 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

On 12.2.6.3, 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
Error string=
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.

Cause

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
Symptoms
Cause
Solution
References


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