Planning ODS Load Failing with ORA-2100 APP-FND-02901 then ORA-20100
(Doc ID 1526301.1)
Last updated on SEPTEMBER 23, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
APPLPTMP
utl_file_dir
AutoConfig
Symptoms
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
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 |