4 Replies Latest reply on Oct 13, 2015 1:35 PM by Pravin Takpire

    EBS R12.2.4: PO Form issue: APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch returns more than requested number of rows

    Ramaraju

      Hi,

      While Open Purchase Order form in Purchasing, Vision Operations responsibility (VISMA instance).

      APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch returns more than requested number of rows

      Cause: A SQL error has occurred in get_po_parameters.

      The SQL error is ORA-01422: exact fetch returns more than requested number of rows.

      Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

      For this, We have done following

      Connect apps

      SELECT count(*) FROM po_document_types;

              COUNT(*)

      ----------

            1473

      Connect /as sysdba

      Revoke EXEMPT ACCESS POLICY from APPS;

      Connect apps

      SELECT count(*) FROM po_document_types;

              COUNT(*)

      ----------

            0

      But, this time we are unable to open Applications login page.

      Please help on this.

       

      Thanks,

      RamarajuPO-Issue.png