FRM-40735 ORA-01476 When Saving Data On Lease Form PNTLEASE

(Doc ID 2360103.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Property Manager - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When Saving Data On Lease Form (PNTLEASE.fmb) the below error occurs:

FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-01476

 

 

Steps to reproduce error:
1) Query a contract in Main Lease window
2) Change the END DATE of a billing in the billings tab
3) Save your changes, A message asking you to confirm you want to change the
billing shows up, click on Yes to continue.
4) An error is displayed at the bottom of the window:
   FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-01476

**only happens when there are already billings pending of approval and the end date for the billing cycle is changed.

 

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