Checking ATP Details gives error - ORA-01422: exact fetch returns more than requested number of rows / FRM-40735: PRE-FORM trigger raised unhandled exception ORA-01422 (Doc ID 1470726.1)

Symptoms

Any release

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 cloned 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 user tried to check the 'Availability' for an already scheduled SO, get error:
"ORA-01422: exact fetch returns more than requested number of rows"

EBS > Order Organizer > Query SO  > On SO Line, > Availability Button > 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"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.