EAP: Voucher Posting Process Abends At AP_PSTVCHR.BG170.BG170-10 (SQL) (Doc ID 2054493.1)

Last updated on MARCH 18, 2016

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

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