R12.2 Apps DBA. Powered by Blogger.

ORA-20041 ORA-20002 R12.2

No comments :
ORA-20041: Error while inserting into control table from VCP :
ORA-20002: Too many rows found while retrieving db link for instance id
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start of ins_control_table
Start of get_source_db_link
ORA-06512: at "APPS.BIO_MSC_PUB_NOTES_PKG", line 182
ORA-06512: at "APPS.BIO_MSC_PUB_NOTES_PKG", line 1434
ORA-06512: at "APPS.BIO_MSC_PUB_NOTES_PKG", line 182
ORA-06512: at "APPS.BIO_MSC_PUB_NOTES_PKG", line 1434
Solution:
Atp Inquiry Form Shows 'Dblink Setup Is Wrong' (Doc ID 551819.1).
CAUSE
There are 2 rows in MRP_AP_APPS_INSTANCES_ALL because the instance was cloned from a different instance.
SOLUTION
To implement the solution, please execute the following steps:
1. In SQL Developer, run the following query:
select * from mrp_ap_apps_instances_all;
You should see 2 rows in the table. Only 1 row should exist in the table.
2. Delete the incorrect record from the table.  The problem row is from the cloned instance.
3. Retest the issue.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.