My Oracle Support Banner

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

Last updated on JUNE 26, 2018

Applies to:

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


Standard Purchase Order approval fails with :

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

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


 Upgrade to Release 12 environment.


To view full details, 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 a vibrant support community of peers and Oracle experts.