Releasing From Planner Workbench Gives ORA-20001 NO_USER_DEFINED Error
(Doc ID 1471490.1)
Last updated on NOVEMBER 02, 2021
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation 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
Solution
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
Goal |
Solution |