Releasing From Planner Workbench Gives ORA-20001 NO_USER_DEFINED Error
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.
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-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
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