My Oracle Support Banner

EAR 9.2: AR Update Defaults On Items From Billing The Direct Debit Profile ID From Customer ID And Not Entry Type (Doc ID 2483508.1)

Last updated on JULY 08, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

A system inconsistency has been detected when AR Update posts Pending Item Groups coming from Billing Invoices that need to handle Direct Debits. While the transaction gets properly posted into the Customer's Account, the Direct Debit Profile ID being defaulted at the PS_ITEM table is not the expected one.

Usually it would be coming from the Customer Bill To Options settings, but if the Entry Type used at the Pending Item Group is having a Direct Debit Profile ID value defined, and the Direct Debit Profile ID configuration is defined to be used in Entry Type, this would be the one to prevail. While PeopleBooks clarifies this is how the system should behave, AR Update is not delivering the expected results.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as User ID VP1
    2.- Have two different External Bank Accounts configured for Direct Debit collection method
    3.- Define two different Direct Debit Profile IDs, each one for a respective Bank Account: Direct Debit Profile IDs DD-01 and DD-02
    4.- Create a new Entry Type IN-01, and link it to Direct Debit Profile ID DD-02
    5.- Continue to define the Item Entry Type configuration for the new Entry type IN-01
    6.- At the Bill Type SVC level, define the Entry Type IN-01
    7.- Configure the MICR Information for Customer ID EBILL101
    8.- At the Bill To Options for Customer ID EBILL101, define Bill Type SVC, and the Direct Debit Profile ID DD-01
    9.- At the PeopleTools Profile level, for User ID VP1, define Customer Contact EBILL101
    10.- In Billing module, create a new Standard Invoice on Business Unit US001, Customer ID EBILL101, and Bill Type SVC
    11.- Enter the Header information, Line transaction data, Accounting ChartField values, and set the Invoice into Ready status
    12.- Launch the Single Action Invoice program (PS Job BIJOB03) for the transaction just created
    13.- In Accounts Receivable, place the new External Pending Item Group into Batch Standard
    14.- Launch AR Update process with the Pending Items flag selected for Business Unit US001
    15.- Check the Item posted into the Customer's Account, and confirm that the Direct Debit Profile ID defaulted is that of the Customer, instead of the Entry Type (DD-02 should be defaulted, not DD-01)

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

ACTUAL RESULTS:

Pending Items generated from Billing Invoices are being posted into the Customers' Accounts through AR Update AE Program (AR_UPDATE) with an incorrect Direct Debit Profile ID, and this causes problems at the time of generating Direct Debits, as it will be using the incorrect information to create the Worksheets and remit to the Banks.

EXPECTED BEHAVIOR:

PeopleSoft Enterprise FSCM 9.2 Accounts Receivable PeopleBooks is very clear on how the functionality should be defaulting the hierarchy from the different configuration levels: If Entry Type has a Direct Debit Profile ID value defined, and the Direct Debit Profile ID configuration page has the Use Entry Type flag selected, this value will override the one coming from the Customer's Bill To Options settings. This should be working consistently regardless of the origin of the Item (directly created in Accounts Receivable, or through a Billing Invoice).

Cause

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
Symptoms
Cause
Solution
References


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