Monday, June 23, 2014

R12 Purchase Order Preference Form Errors With "APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows"


Hi All ...

I Have got the following error in my R12 upgraded instance:
APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows

SELECT count(*) FROM po_document_types;
Right now the select show : 378 rows

Action Plan:
1. Connect /as sysdba
2. Revoke EXEMPT ACCESS POLICY from APPS;
3. Re-connect with APPS user and rerun SELECT count(*) FROM po_document_types;
4. Your issue would be resolved if this returns zero records.
5. Re-check the issue.

Good luck ...

1 comment: