Cannot Pay the Remaining Amount, Cannot Update Payment Schedule, Cannot Split Schedule Payments ,ORA-01400: cannot insert NULL into ("AP","AP_PAYMENT_SCHEDULES_ALL"."PAYMENT_CROSS_RATE")

(Doc ID 1596850.1)

Last updated on OCTOBER 03, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Pmt PayReports PBatch & Prepay

Cannot update payment schedule, Cannot Pay the Remaining Amount,Cannot Split Schedule Payments

ERROR
-----------------------

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps (for example, Gross Amount = 31,550 USD):


1. Click Schedule Payment TAB
First Line (Inactive): 26-OCT-2013 28,000 USD
Second Line (Active): 28-OCT-2013 3,550 USD

or


1. Go to Invoice Workbench
2. Query the specific invoice
3. Press (B) Split schedules


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update the Schedule Payment and cannot pay the remaining amount.

Changes

 N/A

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