My Oracle Support Banner

POXDOFDO - Forward Documents for Requisition Gets FRM-40735: ON-COMMIT (Doc ID 2382971.1)

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.