Thursday, February 23, 2012

ORA-01422: exact fetch returns more than requested number of row

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: ORA-01422: exact fetch returns more than requested number of row
Setup System Options
Try to enter data in the AR System Options form, but receive error:

ORA-01422: exact fetch returns more than requested number of row


Solution:


Issue was probably caused by: Bug:8302210 (AD) - REPLICATE SEED DATA PROGRAM INSERT DUPLICATE ROWS IN AR_SYSTEM_APRAMETERS_ALL

Fix:
Patch 8302210:R12.AD.A: "1OFF: AD RUP6 : REPLICATE SEED DATA PROGRAM INSERT DUPLICATE ROWS IN AR_SYSTEM_APRAMETERS_ALL"

Please perform the following action plan on a test instance first.
Please perform all steps in the given order.
Connect to SQLPLUS as apps-user where needed.

--1
create table oss_31690079495_arsyspa as
select * from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = 101;

--2
select count(*) from oss_31690079495_arsyspa ;

-- this should give back 1 row(s)

--3
delete from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = 101;

-- this should delete 1 row(s)

--4
commit;

--5
Apply Patch 8302210:R12.AD.A: "1OFF: AD RUP6 : REPLICATE SEED DATA PROGRAM INSERT DUPLICATE ROWS IN AR_SYSTEM_APRAMETERS_ALL"
Go into the application and check the forms again.
At least the AR System Options form should work now.

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: