EAR 9.2: ARPREDCT Process Failing At Step AR_PREDICT1.ITMCOP3.InsSetPr

(Doc ID 2418706.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

On : 9.2 PUM 24 +India GST patch version, Payment Predictor

When attempting to run payment predictor the following error occurs.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 12 Return: 1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP
Failed SQL stmt: INSERT INTO PS_PP_ITEM_TAO1 (PROCESS_INSTANCE, DEPOSIT_BU, DEPOSIT_ID, PAYMENT_SEQ_NUM, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, ENTRY_TYPE, ENTRY_REASON, ENTRY_EVENT,USER_AMT1, USER_AMT2, BAL_AMT, ACCOUNTING_DT, USER_DT1, USER_DT2, ASOF_DT, POST_DT, DUE_DT, DISPUTE_STATUS, DISPUTE_DT, DISPUTE_AMOUNT, PO_REF, PO_LINE, DOCUMENT, DOCUMENT_LINE, PYMNT_TERMS_CD, DISC_AMT, DISC_AMT1, DISC_DT, DISC_DT1, DISC_LEVEL, DISC_DAYS, DUE_DAYS, ALLOW_DISC, DISC_EARNED, PAYMENT_DT, ITEM_SELECTED, ENTRY_USE_ID, DISC_ACTION, DISC_STATUS, 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_AMT, ID_PAY_AMT, ID_DISC_AMT, ID_ADJ_AMT, ID_ADJ_REASON, ADJUSTMENT_AMT, ADJUSTMENT_REASON, RUNNING_TOTAL, PARTIAL_AMT, PAYMENT_CURRENCY, PYMT_RT_TYPE, PYMT_RATE_MULT, PYMT_RATE_DIV, PAY_AMT, DISC_PAY, DISC_BASE, PAY_AMT_NEW, DST_ID_REAL, ENTRY_AMT, ENTRY_AMT_BASE, REAL_GAIN_LOSS, REF_LEVEL, PP_DISPOSITION, REF_GROSS, REF_DISC, REF_NET, SETID, VAT_CALC_GROSS_NET, VAT_ENTITY, VAT_EXCPTN_TYPE, VAT_EXCPTN_CERTIF, VAT_RGSTRN_BUYER, VAT_ROUND_RULE, DISC_REAL_GAINLOSS, DEDUCTION_STATUS, EXCL_DED_ITEMS, EXCL_DISP_ITEMS, VAT_TREATMENT_GRP , PHYSICAL_NATURE , COUNTRY_LOC_BUYER , STATE_LOC_BUYER , COUNTRY_LOC_SELLER , STATE_LOC_SELLER , VAT_SVC_SUPPLY_FLG , VAT_SERVICE_TYPE , COUNTRY_VAT_PERFRM , STATE_VAT_PERFRM , COUNTRY_VAT_SUPPLY , STATE_VAT_SUPPLY , STATE_SHIP_FROM , STATE_SHIP_TO, VAT_RPT_CNTRY_SRC, STATE_VAT_DEFAULT, AR_SPECIALIST , COLLECTOR , CONTRACT_NUM , BILL_OF_LADING , COUNTRY_SHIP_FROM , COUNTRY_SHIP_TO , COUNTRY_VAT_BILLFR , COUNTRY_VAT_BILLTO , CR_ANALYST , DOUBTFUL , LC_ID, PACKSLIP_NO , SBI_NUM , SHIP_FROM_BU , REF_REASON , REGION_CD , VAT_DCLRTN_POINT , VAT_RECALC_FLG, ORIG_BAL_AMT,ORIG_ENTRY_TYPE, ORIG_ENTRY_REASON, DST_ID_AR, ORDER_NO, AG_REF_NBR, ADDRESS_SEQ_NUM, BUSINESS_UNIT_CA, CONTRACT_LINE_NUM, SP_ID) SELECT DISTINCT P.PROCESS_INSTANCE , P.DEPOSIT_BU , P.DEPOSIT_ID , P.PAYMENT_SEQ_NUM , I.BUSINESS_UNIT , I.CUST_ID , I.ITEM , I.ITEM_LINE , I.ENTRY_TYPE , I.ENTRY_REASON , D.ENTRY_EVENT , I.USER_AMT1 , I.USER_AMT2 , I.BAL_AMT , I.ACCOUNTING_DT , I.USER_DT1 , I.USER_DT2 , I.ASOF_DT , I.POST_DT , I.DUE_DT , I.DISPUTE_STATUS , I.DISPUTE_DT , I.DISPUTE_AMOUNT , I.PO_REF , I.PO_LINE , I.DOCUMENT , I.DOCUMENT_LINE , I.PYMNT_TERMS_CD , I.DISC_AMT , I.DISC_AMT1 , I.DISC_DT , I.DISC_DT1 , I.DISC_LEVEL , I.DISC_DAYS , I.DUE_DAYS , I.ALLOW_DISC , 0 , P.PAYMENT_DT , 'N' , 'WS-01' , 'N' , 'N' , ' ' , I.BAL_CURRENCY , I.RT_TYPE , I.RATE_MULT , I.RATE_DIV , 1 , 1 , 1 , 1 , I.BAL_AMT_BASE , I.BAL_AMT_LAST , I.CURRENCY_CD , I.SUBCUST_QUAL1 , I.SUBCUST_QUAL2 , 0, 0, 0, 0, ' ', 0, ' ',0,0 , P.PAYMENT_CURRENCY , P.PYMT_RT_TYPE , P.PYMT_RATE_MULT , P.PYMT_RATE_DIV , I.BAL_AMT , 0 , 0 , 0 , ' ' , 0 , 0 , 0 , P.REF_LEVEL , ' ' , 0 , 0 , 0 , P.PP_MET_SETID , I.VAT_CALC_GROSS_NET , I.VAT_ENTITY , I.VAT_EXCPTN_TYPE , I.VAT_EXCPTN_CERTIF , I.VAT_RGSTRN_BUYER , I.VAT_ROUND_RULE , 0 , I.DEDUCTION_STATUS , 'N' , 'N' , I.VAT_TREATMENT_GRP , I.PHYSICAL_NATURE , I.COUNTRY_LOC_BUYER , I.STATE_LOC_BUYER , I.COUNTRY_LOC_SELLER , I.STATE_LOC_SELLER , I.VAT_SVC_SUPPLY_FLG , I.VAT_SERVICE_TYPE , I.COUNTRY_VAT_PERFRM , I.STATE_VAT_PERFRM , I.COUNTRY_VAT_SUPPLY , I.STATE_VAT_SUPPLY , I.STATE_SHIP_FROM , I.STATE_SHIP_TO,I.VAT_RPT_CNTRY_SRC, I.STATE_VAT_DEFAULT,I.AR_SPECIALIST , I.COLLECTOR , I.CONTRACT_NUM , I.BILL_OF_LADING , I.COUNTRY_SHIP_FROM , I.COUNTRY_SHIP_TO , I.COUNTRY_VAT_BILLFR , I.COUNTRY_VAT_BILLTO , I.CR_ANALYST , I.DOUBTFUL , I.LC_ID, I.PACKSLIP_NO , I.SBI_NUM , I.SHIP_FROM_BU , I.REF_REASON , I.REGION_CD , I.VAT_DCLRTN_POINT , I.VAT_RECALC_FLG, I.BAL_AMT, I.ENTRY_TYPE, I.ENTRY_REASON, I.DST_ID_AR, I.ORDER_NO , 0 , I.ADDRESS_SEQ_NUM , ' ' , 0 , I.SP_ID FROM PS_PP_PYREF_TAO1 R , PS_PP_PYMNT_TAO1 P , PS_PP_CUST_TAO1 C , PS_PAYMENT_ID_ITEM D , PS_ITEM_ALL_PVN_VW I , PS_SP_BUARED_CLSVW Q WHERE R.PROCESS_INSTANCE = 9628226 AND R.REF_QUALIFIER_CODE = 'I' AND R.FIELDNAME = 'ITEM' AND P.PROCESS_INSTANCE = R.PROCESS_INSTANCE AND P.DEPOSIT_BU = R.DEPOSIT_BU AND P.DEPOSIT_ID = R.DEPOSIT_ID AND P.PAYMENT_SEQ_NUM = R.PAYMENT_SEQ_NUM AND Q.BUSINESS_UNIT = I.BUSINESS_UNIT AND P.PP_REF_STATUS = 'Y' AND P.REF_LEVEL = 'S' AND P.PP_DISPOSITION = 'N' AND (P.PP_MICR_STATUS = 'S' OR P.PP_MICR_STATUS = 'M') AND P.PP_MET_SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = P.DEPOSIT_BU AND E.RECNAME = 'PP_MET_TBL') AND C.PROCESS_INSTANCE = P.PROCESS_INSTANCE AND C.DEPOSIT_BU = P.DEPOSIT_BU AND C.DEPOSIT_ID = P.DEPOSIT_ID AND C.PAYMENT_SEQ_NUM = P.PAYMENT_SEQ_NUM AND C.PP_HOLD <> 'Y' AND D.DEPOSIT_BU = P.DEPOSIT_BU AND D.DEPOSIT_ID = P.DEPOSIT_ID AND D.PAYMENT_SEQ_NUM = P.PAYMENT_SEQ_NUM AND D.REF_QUALIFIER_CODE = R.REF_QUALIFIER_CODE AND D.REF_VALUE = I.ITEM AND I.CUST_ID = C.CUST_ID AND I.PAYMENT_METHOD IN ('CHK', 'CC', 'EFT' , 'GE', 'CSH') AND I.DRAFT_STATUS IN (' ', 'N') AND I.PROCESS_INSTANCE = 0 AND I.ITEM_STATUS = 'O' AND NOT EXISTS ( SELECT 'X' FROM PS_PP_ITEM_TAO1 T WHERE T.PROCESS_INSTANCE = P.PROCESS_INSTANCE AND T.DEPOSIT_BU = P.DEPOSIT_BU AND T.DEPOSIT_ID = P.DEPOSIT_ID AND T.PAYMENT_SEQ_NUM = P.PAYMENT_SEQ_NUM AND T.BUSINESS_UNIT = I.BUSINESS_UNIT AND T.CUST_ID = I.CUST_ID AND T.ITEM = I.ITEM AND T.ITEM_LINE = I.ITEM_LINE)

Process 9628226 ABENDED at Step AR_PREDICT1.ITMCOP3.InsSetPr (SQL) -- RC = 1652 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 10.49.09 2018-06-25


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run AR payment predictor for deposits.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply payment using payment predictor.

Changes

 

Cause

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