Tuesday, December 15, 2015

PO approval workflow is failing with the error --Failed Activit: Get PO Attributes -- Error Stack : Wf_Engine_Util.Function_Call(PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES, POAPPRV, 562566-638453, 265219, RUN)

Issue:    PO approval workflow is failing with the error

Failed Activity
http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Get PO Attributes http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Activity Type
http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Function http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Error Name
http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
-6512 http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Error Message
http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
ORA-06512: at line http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Error Stack
http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif
Wf_Engine_Util.Function_Call(PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES, POAPPRV, 562566-638453, 265219, RUN) http://appprod.tic.toshiba.com:8000/OA_HTML/cabo/images/swan/t.gif

Solution: There might be multiple reasons. Below would be one of the issues.
The PO distribution line id is having quantity ordered ‘0’ and it is causing the issue.
I found one Metalink id Purchase Agreement Fails Under GET_PO_ATTRIBUTES Activity (Doc ID 460332.1)

After performing the below data fix. It resolved my issue.

Delete from po_distributions_all
where po_header_id = '562566'
and po_line_id=565160
and req_distribution_id=219153


1 comment:

  1. Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please check https://www.oracleappstechnical.com

    ReplyDelete