My Oracle Support Banner

AR9.2: Payment Predictor DTL_TLR ABENDED At Step AR_PREDICT2.DTLRBODY.GENITMOE When Running For Multiple Items With Different Address Locations (Doc ID 2852231.1)

Last updated on MARCH 18, 2022

Applies to:

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

Symptoms

When running Payment Predictor process for two items, same CustID and different locations are processed against a single Payment Seq Number, below error occurs:

Process 244918 ABENDED at Step AR_PREDICT2.DTLRBODY.GENITMOE (SQL) -- RC = 805

 

Stmt #: 1811 Erro r Position: 0 Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_PP_ITEM2_TAO4) violated Failed SQL stmt: INSERT INTO
PS_PP_ITEM2_TAO4 ( PROCESS_INSTANCE, DEPOSIT_BU, DEPOSIT_ID, PAYMENT_SE
Q_NUM, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, ID_SEQ_NUM,ENTRY_TYPE,
ENTRY_REASON, ENTRY_EVENT,USE R_AMT1, USER_AMT2, BAL_AMT, ACCOUNTING_DT,
ASOF_DT, DUE_DT, DISPUTE_STATUS, DISPUTE_DT, DISPUTE_AMOU NT, PO_REF,
PO_LINE, DOCUMENT, DOCUMENT_LINE, PYMNT_TERMS_CD, DISC_AMT, DISC_AMT1,
DISC_LEVEL, DISC_ DAYS, DUE_DAYS, ALLOW_DISC, DISC_EARNED, PAYMENT_DT,
ITEM_SELECTED, ENTRY_USE_ID, DISC_STATUS, DISC_ ACTION, PP_CREDIT_IND,
BAL_CURRENCY, RT_TYPE, RATE_MULT, RATE_DIV, RATE_MULT_NEW, RATE_DIV_NEW, RATE
_MULT_2, RATE_DIV_2, BAL_AMT_BASE, BAL_AMT_LAST, CURRENCY_CD, SUBCUST_QUAL1,
SUBCUST_QUAL2, ID_ITEM_

Replication Steps:

1. Set Up Financials Supply Chain - Business Unit Related - Setup Business Unit Options- Payment predictor Setups #DTL_TLR.
    Make sure the Exception Type- ‘Invoice Overage >Tolerance’ is added.
    Use a customer that has at least two address locations.
2. Accounts Receivable - Pending Items - Create an Online Billing Group and add two items.
3. Post the Group.
    Both the items should have different locations.
    For this example, we have the items as follows:
    ITEM1- Address Location 1- Amt $1000.
    ITEM2- Address Location 2- Amt $600.
4. Accounts Receivable - Payments - Online Payments - Regular Deposit - Create a Deposit with one payment for an amount of $2000.
    (The deposit total should be more than the Items that are being applied to it,so that an OA item is generated.)
5. Assign both the Items at the Detail Reference for the same payment seq num.
6. Add the customer ID twice under the Customer Information details.
    (This is how the details are populated by the lockbox file load process when multiple items are processed under one payment.)
7. Check the Payment Predictor check box.
8. Accounts Receivable - Payments - Apply Payments - Run the Payment Predictor Job.

Attached OSS.pdf replication file.

 

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.