1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Error while opening PO forms

Discussion in 'Oracle SCM & Manufacturing' started by durgareddygade, Sep 24, 2012.

  1. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi experts,

    While opening forms in purchasing super user responsibility,
    the following error is coming.

    APP-PO-14142: get_po_parameters-10: ORA-01403: exact fetch returns more than requested no.of rows

    Please give any suggestion to overcome this issue..

    Thanks
    Durga
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Can you please share screen shot for the same.
     
  3. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Kiran,
    Thanks for your quick response..plz find the attached image for your reference

    Thanks
    Durga
     

    Attached Files:

  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Durga,

    The solution is Go to Purchasing Resp > Setup > Org > Purchasing Options, enter the necessary info base on organization
    And for more information on this issue please go through the following conversation.
    Issue Conversation1
    Issue Conversation2
     
    durgareddygade likes this.
  5. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Bhart,

    Thanks for your replay.

    I saw your mentioned link "Issue conversation2"

    The functional set-ups are done in instance as mentioned there.

    Actually that is the solution for " APP-PO-14142 get_po_parameters-10: ORA-01403 : no data found "

    But the error coming here was
    APP-PO-14142: get_po_parameters-10: ORA-01403 : exact fetch returns more than requested no.of rows.

    Please guide me to move forward.

    Thanks
    Durga
     
  6. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Friends,

    Now while opening AP forms also it is showing same error.
    Please find the attached document..

    One more thing I need to share with you was

    Actually From the last 6 months we are using application.
    But this error is coming from last 2 days only.
    Previously it is working fine .

    I think there is no issue in setups.

    Please guide me to move forward.

    Thanks
    Durga
     

    Attached Files:

  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Durga,

    Can you please tell me at what time you are getting this error. I mean while opening form or while querying the record or what and which forms you are facing this issue? Mention them clearly. Does any up gradations done on instance or any patches applied on instance recently?
     
  8. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Bhart,

    Thanks for your concern.

    In purchasing while opening in forms I am getting this error. (APP-PO-14142:get_po_parameters-10:ORA-01422:exact fetch returns more than requested number of rows)

    where as in payables while entering line details it shows error(ORA-01422:exact fetch returns more than requested number of rows).

    recently no patches applied..

    Please guide me to move .

    Thanks
    Durga
     
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Have you checked with personalizations for those two forms?
     
  10. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi bharat,

    Now problem is solved.

    One of my colleagues did this..

    Just he delete the rows in po_document_types view..

    Now forms are opening without any error..still I am not able to understand how the data is coming into this view.

    How the error resolved by deleting rows into this view..

    Thanks for your support.
    Durga
     
  11. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Durga,

    What is the data contains in that table? Can please provide here, by that we can say from where they came into that view and to which issue does it belongs to..
     
  12. zzmaher

    zzmaher Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Hi
    i faced this error , and solved by these steps :
    Opening Purchasing Forms Causes APP-PO-14142 : get_doc_type_info-10 : ORA-01422 Error [ID 1314304.1]


    This Issue will be resolved by applying the following steps in test instance (a DBA privileges will be needed to run the

    following from sqlplus):

    /as sysdba

    Revoke EXEMPT ACCESS POLICY from APPS;

    Thereafter run this query (login as apps) -
    apps :

    SELECT count(*) FROM po_document_types;

    Your issue would be resolved if this returns zero records.

    Abuzeid Maher