My Oracle Support Banner

MSCPLD - Loader Worker With Direct Load Option Errors With usdsop: exec failed during spawnsqlldr: Permission denied APP-FND-01630 (Doc ID 1081447.1)

Last updated on JULY 25, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Oracle Materials Requirement Planning - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Executable:MSCPLD - Loader Worker With Direct Load Option
Executable:MSCMON - Snapshot Monitor


Symptoms

An ASCP Plan is run.  However MSCPLD - Loader Worker With Direct Load Option concurrent request fails with the following:

Parent Program Name: MSCMON
This IS part of a Plan run.
usdsop: exec failed during spawnsqlldr: No such file or directory
usdsop cannot write to pipe

Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.

Action: Check the other process for abrupt termination. Check that you have sufficient resource: Broken pipe
usdsop cannot write to pipe

Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.

Action: Check the other process for abrupt termination. Check that you have sufficient resource
APP-FND-01630: Cannot open file /apd/app/appvtkd/VTKDEV/common/temp/OFCYxzJg.t for reading

Cause: USDINS encountered an error when attempting to open file /apd/app/appvtkd/VTKDEV/common/temp/OFCYxzJg.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.

***** End Of Program - Loader Worker With Direct Load Option *****


STEPS
-------
1. ASCP -> Supply Chain Plan -> Names
2  Name the plan and set the plan options
3. Submit

 

The solution of the note also works for Loader Worker(MRCSLD ).

Error messages in the concurrent log:

usdsop: exec failed during spawnsqlldr: Permission denied Program exited with status 1

 

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.