EAP: Voucher Postubg abends at Step AP_PSTVCHR.BG120.BG120-03 (Action SQL) -- Rc = 805 (Doc ID 1400248.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

Voucher Post abend at Step AP_PSTVCHR.BG120.BG120-03 (Action SQL) -- RC = 805

ERROR
-- 17.31.13 SQL Error: ORA-00001: unique constraint (EMDBO.PS_VCHR_TEMP_LN4)
violated

SCENARIO 1:
When posting a voucher having multiple voucher lines, and both lines are having different tax code.

STEPS
1. Setup Posting method=Summary Control.
Navigation: Set Up Financials/Supply Chain > Install > Installation Options.
Click on the Payables link.

2. Setup Chartfield inheritance:
For Inheritance Groups: Payables Distrib Level entries, Payables Header Level Entries and Payables VAT Non-Recoverable, set all to "Do not inherit".
Navigation: Set Up Financials/Supply Chain > Install > Common Definitions > Design Chartfields > ChartField Inheritance > ChartField Inheritance.

3. Create tax code DE00 to populate PS_TAX_HEADER_TBL.
Navigation: Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > VAT code.

4. Create tax code DE96.

5. Create VAT transaction type HSN to populate PS_VAT_TXN_CD.
Navigation: Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Transaction Type.

7. Create VAT transaction type HS5.

8. Create new VAT account by Business Unit: DE and D96 to populate PS_VAT_BU_ACCT_TBL.
Navigation: Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Accounts by Business Unit.

6. Run Query:
select distinct setid,tax_cd,VAT_TXN_TYPE_CD,distrib_line_num
from PS_VAT_BU_ACCT_TBL where TAX_CD in ('DE96','DE00') and VAT_TXN_TYPE_CD in ('HS5','HSN') and setid='SHARE'
Duplicate distrib_line_num 12131 found

7. Create voucher for BU CAN01 with 2 lines:
a) line 1 with tax code DE00 and VAT transaction type HS5
b) line 2 with tax code DE95 and VAT transaction type HSN

8. Run voucher post.

9. Abend:
-- 17.31.13 Process 14251 ABENDED at Step AP_PSTVCHR.BG120.BG120-03 (Action SQL) -- RC = 805
ROLLBACK
/
-- 17.31.13 SQL Error: ORA-00001: unique constraint (EMDBO.PS_VCHR_TEMP_LN4) violated

SCENARIO 2:
Not able to post a Voucher with two lines, Line 1 is charging the Standard Rate and Line 2 is charging the Rate of zero and the VAT Declaration point set to Payment. Also the VAT Transaction Type are different for each voucher Line.

This only happens when the PS_VAT_ACCT_TBL has the same DISTRIB_LINE_NUM for the
following combination :
VAT Code + VAT Transaction Type and have the same VAT Distribution Accounting
Type (VIIR,VIR etc)

STEPS
1.  Enter new VAT Code TR with VAT Authority with Rate of 19.6 %. Delivered
VAT Authority FR1 is for 19.6 %
Navigation : Main Menu > Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Code
2.   Enter new VAT Code TR with VAT Authority with Rate of 0 %. Delivered VAT Authority FR5 is for 0 %
Navigation : Main Menu > Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Code
3.   Query PS_VAT_ACCT_TBL: TAX_CD ='TR' and TAX_CD ='GR' and
VAT_DST_ACCT_TYPE ='VIIR' ( VAT Intermediate Recoverable)
4.   Depending upon the number of VAT Transaction Use Type in the system, rows will
be created for each VAT Transaction Use Type
5.   Identify two rows which meet this criteria
Two rows with same DISTRIB_LINE_NUM , but one row has TAX_CD ='TR' and
other with TAX_CD='GR' and VAT Transaction Use Type are not same.

6.  Based on the data that was generated, the following two lines were identified. This is critical to replicate the issue.

TAX_CD        VAT_DST_ACCT_TYPE     VAT_TXN_TYPE_CD    DISTRIB_LINE_NUM

TR               VIIR                             FAMD                      11941
GR               VIIR                             FAIU                       11941

7.  Enter a Voucher with two lines with following details. Test Business Unit FRA01 and Vendor SHARE/FRA0000001 was used with setup Country France.

Gross Amount = 219.6 , VAT Amount = 19.6 , on the VAT Header Declaration Point = At Payment Time (this is critical to replicate the issue)

Voucher Line # 1 , Merchandise Amount = 100 , VAT Use Type = COMM (100% taxable) , VAT Code = TR and VAT Transaction Type = FAMD
Voucher Line # 2 , Merchandise Amount = 100 , VAT Use Type = CEXM (100% Exempt) , VAT Code = GR and VAT Transaction Type = FAIU

8.   Run Voucher Post. For test purposes, run Voucher Post by Voucher Id

9.  Voucher Post failed with reported error message

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