Receivable Activities screen when opened throws error ORA-01422: exact fetch returns more than requested number of rows.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Receivable Activities screen when opened throws error ORA-01422: exact fetch returns more than requested number of rows. Symptoms: When opening the Receivable Activities screen it triggers. ORA-01422: exact fetch returns more than requested number of rows Solution: The cause of the issue is invalid / incorrect data in . Found that there were duplicate records for the ORG_ID with set_of_books_id = -1. Execute the below scripts in the TEST INSTANCE and retest the issue before migrating the changes to PRODUCTION. create table AR_SYSTEM_PARAMETERS_ALL_bckup_82 as select * from AR_SYSTEM_PARAMETERS_ALL where SET_OF_BOOKS_ID = -1 and ORG_ID = <&enter_org_id for operating_unit>; delete from AR_SYSTEM_PARAMETERS_ALL where SET_OF_BOOKS_ID = -1 and ORG_ID = <&enter_org_id for operating_unit>; COMMIT; After executing the scripts, log out of ORACLE Applications and log in again so that the parameters get affected. Click on Receivables Responsibility and Navigate to Set up -> Receipts -> Receivables Activities and retest the issue. If the issue is resolved, migrate the changes to PROD. References: Note 862952.1

Get Oracle Certifications for all Exams
Free Online Exams.com