My Oracle Support Banner

Release Sales Order Recommendations Program Is Failing with Error - ORA-20001 and APP-FND-02901 (Doc ID 2860637.1)

Last updated on APRIL 11, 2022

Applies to:

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

Symptoms

ERROR in LOG FILE
==============
MRPRELSO: Release sales order recommendations
....
Oracle error -20001: 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. has been detected in MO_GLOBAL.INIT.

STEPS
------------
ASCP (R) / Supply Chain Plan / Workbench
Pick plan and review Supply/Demand for Sales Orders with Action - Release
Click Release box and save
/Plan/Release and this launches request MRPRELSO: Release sales order recommendations

<Note 981828.1> discusses ORA-20001: APP-FND-02901 - But will not apply for this customer because the validation SQL in the note passes all tests
SQL> select ORGANIZATION_ID, NAME from hr_operating_units;
- this returns 2 rows
AND
select PROFILE_OPTION_ID, LEVEL_ID, PROFILE_OPTION_VALUE
from FND_PROFILE_OPTION_VALUES
where profile_option_id in (select profile_option_id from FND_PROFILE_OPTIONS where profile_option_name = 'ORG_ID');
 >> this returns correct data for the two rows in 1st SQL

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.