How to Change the Term Days for an Existing Payment Term and Make the Change Affect To all Customers Having this Payment Term Assigned?
Last updated on AUGUST 01, 2017
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:
Query a customer
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