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 AUGUST 01, 2017

Applies to:

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

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

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