POXDOFDO - Forward Documents for Requisition Gets FRM-40735: ON-COMMIT

(Doc ID 2382971.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Purchasing - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Approvals - Req, PO


Requisition Forwarding(POXDOFDO - Forward Documents)

When a Requsition is being forwarded for approval by the PO Super user, the user is getting an error

Error: FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002.

ERROR
-----------------------
FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002

FRM-40654: Record has been updated. Requery block to see change

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Logon to PO SuperUser
2) Navigate ->Management->Forward Documents
3) Enter Approver, select line that is wanting to be forwarded
4) Click on Save error occurs: FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002
5) Then the next dialog pops up: Please acknowledge
6) Click OK
7) Then another dialog pops up:FRM-40654: Record has been updated. Requery block to see change
8) The document is not forwarded

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