My Oracle Support Banner

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

Last updated on OCTOBER 28, 2020

Applies to:

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


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.

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
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.

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.


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

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