Releasing From Planner Workbench Gives ORA-20001 NO_USER_DEFINED Error (Doc ID 1471490.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

We have made sure that the 'APS Release' responsibility has been assigned to the user in both the planning instance as well as EBS instance.
Still getting this error when we try to release the planned orders for some of the users.

Error in release process. Please check the setup
ORA-20001: NO_USER_DEFINED
ORA-06512: at "APPS.MRP_AP_REL_PLAN_PUB", line 151
ORA-06512: at "APPS.MRP_AP_REL_PLAN_PUB", line 95
ORA-06512: at "APPS.MRP_AP_REL_PLAN_PUB", line 857


What could cause this error??

We have setups as follows:
apscheck shows collection from 4 instances to this APS destination

23.2 MSC_APPS_INSTANCES -
Instance ID INS M2A Dblink - APS to ERP
=========== === ========================
2022 2 xapps_dev12x (Success)
6021 R xapps_rcert12x (Success)
5022 B xapps_projbx (Success)
2023 3 xapps_cert12x (Success)


Each EBS Source is separate source - we are not using cross-instance planning

Note: Cross-instance planning example would be where you have EBS Source for EMEA region and EBS Soruce for US region and plan both in a single ASCP plan.

 

Solution

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