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

(Doc ID 1313468.1)

Last updated on JANUARY 21, 2017

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

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