Planning ODS Load Failing with ORA-2100 APP-FND-02901 then ORA-20100 (Doc ID 1526301.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
APPLPTMP
utl_file_dir
AutoConfig

Symptoms

Note: This ORA-20100 error can happen on any version.


When attempting to run a complete refresh data collections, data collections fail at Planning Data Pull Worker and/or ODS Load Worker with the following error occurs.

ERROR
-----------------------
The log indicates ORA-20100:

Corresponding trace show the below error:
ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.

Then once they resolved the APP-FND-02901 error using Note 981828.1 - CAN'T VIEW REQUEST LOG ON LEGACY COLLECTION -SELF SERVICE FORM In R12

They still received ORA-20100

+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MSCPDCW module: Planning ODS Load Worker
+---------------------------------------------------------------------------+

Current system time is 04-FEB-2013 13:08:50

+---------------------------------------------------------------------------+

**Starts**04-FEB-2013 13:08:50
**Ends**04-FEB-2013 13:10:12
ORA-20100:
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
04-FEB 13:08:50 : Purge Batch Size is set to : .
04-FEB 13:08:50 : Procedure MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY started.


STEPS
-----------------------
1. Login to Application.
2. Run Collections.
  NAV: Advanced Supply Chain Planner (R) / Collections / Oracle Systems / Standard Collection
3. See that the ODS Load fails.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms