EAR9.2: AR_PGG1 ABENDED at Step IU_PROCESSOR.U400.U400-010 With SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated When Latge Number Of Accounting Entries Exist
(Doc ID 2893846.1)
Last updated on OCTOBER 02, 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 Receivables Update process for large number of accounting entries the following error occurs in the application engine AR_PGG1 trace file:
INSERT INTO PS_PG_PENDST_TAO4 (PROCESS_INSTANCE, GROUP_BU, GROUP_ID,
BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, DST_SEQ_NUM,
LEDGER_GROUP, LEDGER, PRIMARY_LEDGER, BUSINESS_UNIT_GL, BUSINESS_UNIT_TO,
ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD,
PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2,
CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID,
ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT,
ANALYSIS_TYPE, BUDGET_DT, STATISTICS_CODE, MONETARY_AMOUNT, STATISTIC_AMOUNT,
CF_EDIT_STATUS, JRNL_LN_REF, LINE_DESCR, SYSTEM_DEFINED, ACCOUNTING_DT,
FOREIGN_CURRENCY, FOREIGN_AMOUNT, RT_TYPE, RATE_MULT, RATE_DIV, CURRENCY_CD,
GL_DISTRIB_STATUS, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, DOC_SEQ_STATUS,
MOVEMENT_FLAG, USER1, USER2, USER3, USER4, USER5, DST_GL, ALLOW_DST,
VAT_APPLICABILITY, VAT_TXN_TYPE_CD, TAX_CD_VAT, VAT_DST_ACCT_TYPE,
ENTRY_EVENT, IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, OPEN_ITEM_KEY,
SEQ_NUM4) SELECT A.PROCESS_INSTANCE, A.GROUP_BU, A.GROUP_ID, A.BUSINESS_UNIT,
A.CUST_ID, A.ITEM, A.ITEM_LINE, A.GROUP_SEQ_NUM, A.DST_SEQ_NUM,
A.LEDGER_GROUP, A.LEDGER, A.PRIMARY_LEDGER, A.BUSINESS_UNIT_GL,
A.BUSINESS_UNIT_TO, A.ACCOUNT, A.ALTACCT, A.DEPTID, A.OPERATING_UNIT,
A.PRODUCT, A.FUND_CODE, A.CLASS_FLD, A.PROGRAM_CODE, A.BUDGET_REF,
A.AFFILIATE, A.AFFILIATE_INTRA1, A.AFFILIATE_INTRA2, A.CHARTFIELD1,
A.CHARTFIELD2, A.CHARTFIELD3, A.BUSINESS_UNIT_PC, A.PROJECT_ID,
A.ACTIVITY_ID, A.RESOURCE_TYPE, A.RESOURCE_CATEGORY, A.RESOURCE_SUB_CAT,
A.ANALYSIS_TYPE, A.BUDGET_DT, A.STATISTICS_CODE, A.MONETARY_AMOUNT,
A.STATISTIC_AMOUNT, A.CF_EDIT_STATUS, A.JRNL_LN_REF, A.LINE_DESCR,
A.SYSTEM_DEFINED, A.ACCOUNTING_DT, A.FOREIGN_CURRENCY, A.FOREIGN_AMOUNT,
A.RT_TYPE, A.RATE_MULT, A.RATE_DIV, A.CURRENCY_CD, A.GL_DISTRIB_STATUS,
A.DOC_TYPE, A.DOC_SEQ_NBR, A.DOC_SEQ_DATE, A.DOC_SEQ_STATUS, A.MOVEMENT_FLAG,
A.USER1, A.USER2, A.USER3, A.USER4, A.USER5, A.DST_GL, A.ALLOW_DST,
A.VAT_APPLICABILITY, A.VAT_TXN_TYPE_CD, A.TAX_CD_VAT, A.VAT_DST_ACCT_TYPE,
A.ENTRY_EVENT, A.IU_ANCHOR_FLG, A.IU_SYS_TRAN_CD, A.IU_TRAN_CD, ' ',
A.SEQ_NUM4 FROM PS_PG_IIU2_TAO4 A WHERE A.IU_LINE_TYPE='N' AND A.ACCOUNT<>' '
AND PROCESS_INSTANCE=2346485
/
-- Row(s) affected: 0
-- 15:41:04.417 Process 2346485 ABENDED at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805
ROLLBACK
/
-- 15:41:04.529 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated
Replication Steps:
The issue can be reproduced at will with the following steps:
1. Create or Upload Items transaction in Receivables under navigation Accounts Receivable / Pending Items /Online Items / Online Item Group Entry;
2. Create or Upload Deposit with large number of payments and apply them on the items under Payments/ Online Payments / Regular Deposit;
3. Run Receivables Update to post the deposit payments under Receivables Update / Request Receivables Update.
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 |