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 JUNE 05, 2024

Applies to:

Goal

QUESTION:
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
Customers
Query a customer
Details
Late Charges
Profile Setup

Solution

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