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 SEPTEMBER 25, 2023
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:
(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 |