Standard Purchase Order Approval fails with error:ORA-01732: data manipulation operation not legal on this view (Doc ID 2224416.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Standard Purchase Order approval fails with :

ERROR
-----------------------
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE, POAPPRV, 34029-34187, 312774, RUN)

Errored Activities

Activity (Display Name): OPEN_DOCUMENT_STATE (Open Document State)
Result: #EXCEPTION
Error_Name: 1
Error_Message: User-Defined Exception
Error_Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE, POAPPRV, 34050-34305, 322879, RUN)

SYSADMIN_ERROR_MSG :
po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_update_close_status:210:-1732
ORA-01732: data manipulation operation not legal on this view -
po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_close_po:120:unexpected error in updating closed status
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

Changes

 Upgrade to Release 12 environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms