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 ...