My Oracle Support Banner

How to Change the Term Days for an Existing Payment Term and Make the Change Affect To all Customers Having this Payment Term Assigned? (Doc ID 2155969.1)

Last updated on FEBRUARY 22, 2022

Applies to:

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


You want to change the IMMEDIATE term days from zero to 4 days. How could you accomplish it? Currently it is zero.

You have an issue where Late Charges Payment Terms under Profile Setup is showing blank instead of "IMMEDIATE".

Here is what happened. In customer standard, you have profile setup for Late Charges payment terms and it was set to "IMMEDIATE" for all the customer accounts.
However, recently, our Financial Services group went in and renamed the existing term from "IMMEDIATE" to "IMMEDIATEV2" and then created a new payment term
with the same name 'IMMEDIATE'. Later they end dated 'IMMEDIATEV2" payment term.

Now, the issue is all the existing accounts are showing spaces for the payment terms under Late Charge Profile Setup as the terms ID they belong to is no longer good and end dated.
You need an update statement to apply the new term ID of the Payment Terms IMMEDIATE.

Navigation to view the Payment Terms of the Late Charges Profile Setup:

Customer Administrator
Customer Standard
Query a customer
Late Charges
Profile Setup


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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