Creating Payment Schedules Lines Manually Fails With FRM-40735: POST-QUERY Error (Doc ID 1342066.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3 in Production:
When attempting to create Payment Schedules Lines manually , the following error occurs.

ERROR
-----------------------
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Invoices (using a customized folder ' Payables - invoices'):
Invoice num = EU/01
Validated
Accounted
No Paid

Payment Method = Electronic (in Header)

- Scheduled Payments tab:
Gross Amount = 100.000,00
Changed it to 30.000,00

and adding a new second line for the rest of gross amount (70.000,00)

delete this second line

saved

- Getting error:
Forms:
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.


They can see the Total gross amount as 100.000,00 instead of 30.000,00


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Payment Schedules Lines manually.

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