EAR 9.2: Customer ID Value Getting Truncated to the First 13 Characters From an Original Field Length of 15 at the Payment Detail Report (AR20002) (Doc ID 2991653.1)

Last updated on DECEMBER 07, 2023

Applies to:

Symptoms

A problem has been detected with the Payment Detail report (AR20002 SQR Report), where the Customer Column is truncating the Customer ID value of a Deposit/Payment/Item transaction to only display its first 13 characters.

The Field CUST_ID is delivered with a length of 15 characters, while the Report only displays 13, as such, the Customer values present in the report are not complete.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Receivables User
    2.- Navigate to: Customers > Customer Information > Create Customer Information
    3.- Create, under Set ID SHARE, a brand new Customer ID named CUSTOMER0000123 (using the full 15 character length of Field CUST_ID)
    4.- Navigate to: Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
    5.- Proceed to create a new Pending Item Group under Business Unit US001, with an Item for 5000 USD on Customer ID CUSTOMER0000123, and place the Post Action to Batch Standard
    6.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
    7.- Launch the AR_UPDATE AE Program for Business Unit US001, and the option Pending Items selected
    8.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
    9.- Create a new Regular Deposit under Deposit Business Unit US001, for 5000 USD amount, with a Payment transaction linked to Customer ID CUSTOMER0000123, and the Item recently posted
    10.- Navigate to: Accounts Receivable > Payments > Apply Payments > Apply Payments Worksheet
    11.- Build a new Payment Worksheet for the new Regular Deposit, and Payment created
    12.- Balance the 5000 USD of the Payment with the outstanding Item from Customer ID CUSTOMER0000123, and then place the Payment Group into Post Action Batch Standard
    13.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
    14.- Launch the AR_UPDATE AE Program once again, for Business Unit US001, and the option Payments selected
    15.- Navigate to: Accounts Receivable > Payments > Reports > Payment Detail
    16.- Create a new Run Control ID with the needed criteria to pick up the Regular Deposit ID under Business Unit US001
    17.- Launch the Payment detail process (AR20002 SQR Report)
    18.- PROBLEM: Review the resulting Payment Detail Report (AR20002), and confirm that in the row of the Deposit/Payment transaction, the Customer column is displaying the truncated value of CUSTOMER00001, instead of CUSTOMER0000123

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the problem.

Functional Users reviewing the resulting Payment Detail report (AR20002), are confused, as the truncated value of the Customer ID misleads to think it may be a different Customer's Payment. The report results cannot be trusted.

As the CUST_ID Field is delivered a complete full length of 15 characters, the Customer column within the Payment Detail report (AR20002) should accommodate all of them, and not truncate the value to only the first 13 characters.

Changes

Cause

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