EAP9.1/9.2: Voucher Posting Process Abends At AP_PSTVCHR.BG170.BG170-10 (SQL)
(Doc ID 2054493.1)
Last updated on FEBRUARY 21, 2023
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Voucher Post ABENDED at Step AP_PSTVCHR.BG170.BG170-10 (SQL). This happens for the Voucher which has one VAT applicable line and another line with only Statistic Amount.
Steps:
---------
1) Load Vouchers using Excel Upload for Voucher.
2) Run Voucher Build.
3) Vouchers are created in Recycle status.
4) Correct the voucher.
5) Post the voucher.
Error message:
-------------------
ORA-00001: unique constraint (EMDBO.PS_PST_VVAT_TMP6) violated Failed SQL stmt: INSERT INTO PS_PST_VVAT_TMP6 (PROCESS_INSTANCE, VOUCHER_LINE_NUM, BUSINESS_UNIT, VO UCHER_ID, PYMNT_CNT, DISTRIB_LINE_NUM, BUSINESS_UNIT_GL,
TAX_CD_VAT, VAT_TXN_TYPE_CD, VAT_DST_ACCT_T YPE, POSTING_METHOD_AP, PHYSICAL_NATURE, COUNTRY_VAT_SUPPLY, VAT_SVC_SUPPLY_FLG, VAT_SERVICE_TYPE, COUNTRY_VAT_PERFRM, STATE_VAT_DEFAULT, VAT_TREATMENT, VAT_RCRD_OUTPT_FLG,
VAT_APPLICABILITY, CURRENCY _RPTG, CF_BAL_LINE_NUM, VAT_ACCTG_ENT_GRP, VAT_SETID, TAX_CD_VAT_PCT, VAT_ENTITY, FOREIGN_CURRENCY, CURRENCY_CD, CUR_RT_TYPE, CUR_RATE_MULT, CUR_RATE_DIV, VAT_NRCVR_PRO_FLG,
VAT_NRCVR_ALL_FLG, VAT_INV _AMT, VAT_INV_AMT_BSE, VAT_INV_AMT_GL, VAT_INV_AMT_RPTG, VAT_RCVRY_AMT, VAT_RCVRY_AMT_BSE, VAT_RCVRY
Process 14810 ABENDED at Step AP_PSTVCHR.BG170.BG170-10 (SQL) -- RC = 805
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 |