My Oracle Support Banner

R12: AP: Split Schedule Payment ORA-01400:cannot insert NULL into ("AP","AP_PAYMENT_SCHEDULES_ALL"."PAYMENT_CROSS_RATE") (Doc ID 1313468.1)

Last updated on NOVEMBER 04, 2024

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.
FORM:APXINWKB.fmx
TAB:Scheduled Payments


Symptoms

When attempting to Split Scheduled Payments,the following error occurs.

ERROR
-----------------------
ORA-01400:cannot insert NULL into ("AP","AP_PAYMENT_SCHEDULES_ALL"."PAYMENT_CROSS_RATE")
--------------------------
FRM-40508:ORACLE error:unable to INSERT record.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in responsibility AP
2. Navigate to Invoices->Entry->Invoices->Query invoices and click tab "Scheduled Payments"
3. There is one line with Gross amount 10000
4. User added another line with Gross amount 5000
5. Then go back to the original line to update Gross amount to 5000.
6. Click Save->Error occurred.

Changes

 

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!

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