R12.2.4: PAXINRVW: Consolidated Invoice Approval, Get Error: "FRM-40735: WHEN-BUTTON-PROCESSED Trigger Raised Unhandled"

(Doc ID 2144588.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Invoices

Under the 'Invoice Review' form, when attempting to approve a consolidated invoice generated based on consolidated bill group for 2 projects, the following error occurs.

"FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502."

-Issue only happens with consolidated invoices.  Regular invoices do not have this issue. 


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

1. Query an existing consolidated invoice in the Invoice Review form.
2. Click the "Approve" button and get the error.

The issue has the following business impact:
Due to this issue, 3 users/Projects transaction Resource basis billing and other project expenses are affected.


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