Unable To Use ATP Functionality In A Newly Cloned Environment - Getting ORA-01422
(Doc ID 1470726.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Global Order Promising - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Any release
PROBLEM
-------------
Newly cloned instance and cannot use ATP inquiry from the EBS Source side.
We are unable to use ATP Functionality in a newly cloned Sandbox VCP environment.
We recently closed Sandbox VCP environment from Rehearsal VCP environment.
Issues:
1) When accessing ATP Inquiry I get the error "dblink setup is wrong"
EBS > Order Management Super User > Scheduling > ATP Inquiry
Error: "dblink setup is wrong"
2) When I try to check the 'Availability' for an already scheduled SO, I get error:
"ORA-01422: exact fetch returns more than requested number of rows"
EBS > Order Organizer > Query SO 8200000802 > On SO Line, > Availability Button > Availability > ATP Details > get below error:
ORA-01422: exact fetch returns more than requested number of rows
--------------------------------------------------------------
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-01422.
3) Enter a new SO, and try to schedule the SO Line, following error occurs:
"Scheduling Failed: ATP Processing error. Available Date: 01-NOV-12"
Note:
====
EBS Profile 'MRP:ATP Database Link' in EBS is set to EBSSB_TO_VCPSB
There are no rows in MRP_AP_APPS_INSTANCES_ALL
This is not a RAC environment.
DB Link Setup in Instances Form in ASCP:
EBS to VCP: EBSSB_TO_VCPSB
VCP to EBS: VCPSB_TO_EBSSB
EXPECTED BEHAVIOR
----------------------------
No error and able to use the functionality
BUSINESS IMPACT
----------------------
cannot continue any testing
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 |