AP: SII Create Vat Register File Abends At Step Sii_Vat_Rgs.21Fthsrc.Fetchhdr (Sql) -- Rc

(Doc ID 2328012.1)

Last updated on NOVEMBER 14, 2017

Applies to:

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

Symptoms

When running SII_VAT_RGS (Create VAT Register File), the process abends at Step SII_VAT_RGS.21FthSrc.FetchHDR (SQL) -- RC = 1841.

STEPS:

1. Review Spain VAT entity setup for SPN01V (You must set up the Local VAT IDon the VAT Entity Identification page, in addition to the VAT Registration Number).

2. Review Supplier definition for SPN0000001. (You must also set up Spanish Fiscal Identifiers in the Customer Master and Supplier Master General Information pages, in the ID Number grid).

3. Review VAT Transaction Type - to create or update VAT transaction types (transaction type: SAGP).

4. Add Voucher (TOTAL: 114, vATENTERED: 14).

5. Voucher Post.

6. Create VAT Register File - the following error is thrown:

"
File: e:\pt85603c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1725 Error Position: 1228 Return: 1841 - ORA-01841: (full) year must be
between -4713 and +9999, and not be 0
Failed SQL stmt: INSERT INTO PS_SII_H_AP_TAO4 (PROCESS_INSTANCE, VAT_ENTITY,
BUSINESS_UNIT, SII_INVOICE_ID, VOUCHER_ID, INVOICE_ID, INVOICE_DT, RPT_YEAR,
RPT_PERIOD, VOUCHER_STYLE, INVOICE_TYPE, SII_INVOICE_ID_ORG,
SII_INVOICE_DT_ORG, VAT_TREATMENT_GRP, VAT_DCLRTN_POINT, SII_TRANS_REGIME,
INVOICE_AMOUNT, INVOICE_AMT_BSE, INVOICE_AMT_XEU, SII_PURPOSE_SETID,
SII_PURPOSE_CD, VENDOR_SETID, VENDOR_ID, SII_TYPE_NON_EXP, SII_INTRA_COMM_CD,
COUNTRY_SHIP_FROM, COUNTRY_SHIP_TO, COUNTRY_2CHAR, TOT_VAT, TOT_VAT_BSE,
TOT_VAT_XEU, ACCOUNTING_DT, VAT_RCVRY_AMT, VAT_RCVRY_AMT_BSE,
SII_VAT_RC_AMT_XEU, RT_TYPE, BASE_CURRENCY, TXN_CURRENCY_CD,
SII_RATE_DIV_XEU, SII_RATE_MULT_XEU, SII_INVOICE_STATUS, ERROR_CODE,
SII_ACTION_TYPE, DESCR, VAT_TXN_SOURCE, GROUP_ID, ITEM, ITEM_LINE,
GROUP_SEQ_NUM, CUST_SETID, BILL_TO_CUST_ID, SII_EXEMPT_AMT,
SII_EXEMPT_AMT_BSE, SII_EXEMPT_AMT_XEU, SII_AMT_NALOC, SII_AMT_NALOC_BSE,
SII_AMT_NALOC_XEU, SII_AMT_NAART, SII_AMT_NAART_BSE, SII_AMT_NAART_XEU,
CUR_RT_SOURCE, LAST_UPDATE_DT, BUSINESS_UNIT_GL, ADDRESS1, CITY, STATE)
SELECT DISTINCT 135283, A.VAT_ENTITY, A.BUSINESS_UNIT, A.INVOICE_ID ||
A.VOUCHER_ID, A.VOUCHER_ID, A.INVOICE_ID, A.INVOICE_DT, A.RPT_YEAR,
A.RPT_PERIOD, A.VOUCHER_STYLE, 'F1', A.SII_INVOICE_ID_ORG,
A.SII_INVOICE_DT_ORG, A.VAT_TREATMENT_GRP, A.VAT_DCLRTN_POINT, '01',
A.INVOICE_AMOUNT, A.INVOICE_AMT_BSE, 0, ' ', A.VOUCHER_STYLE, A.VENDOR_SETID,
A.VENDOR_ID, ' ', ' ', A.COUNTRY_SHIP_FROM, A.COUNTRY_SHIP_TO, ' ',
A.TOT_VAT, A.TOT_VAT_BSE, 0, A.ACCOUNTING_DT, A.VAT_RCVRY_AMT,
A.VAT_RCVRY_AMT_BSE, 0, A.RT_TYPE, A.BASE_CURRENCY, A.TXN_CURRENCY_CD, 0, 0,
'R', ' ', 'A0', ' ', 'AP' , ' ', ' ', 0, 0, ' ', ' ', 0, 0, 0, 0, 0, 0, 0, 0,
0, ' ', NULL, B.BUSINESS_UNIT_GL, ' ', ' ', ' ' FROM PS_SII_HDR_AP_VW A,
PS_SII_REQBU_TAO4 B WHERE A.VAT_ENTITY = 'SPN01V' AND A.INVOICE_DT >=
TO_DATE('2017-09-26','YYYY-MM-DD') AND A.INVOICE_DT <=
TO_DATE('2017-09-26','YYYY-MM-DD') AND B.PROCESS_INSTANCE = 135283 AND
B.REQUEST_NBR = 1 AND B.VAT_SOURCE_DEFN = 'AP' AND A.BUSINESS_UNIT =
B.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_SII_HDR_AP_VW A ,
PS_SII_REQBU_TAO4 B WHERE A.VAT_ENTITY = 'SPN01V' AND A.INVOICE_DT >=
TO_DATE('2017-09-26','YYYY-MM-DD') AND A.INVOICE_DT <=
TO_DATE('2017-09-26','YYYY-MM-DD') AND B.PROCESS_INSTANCE = 135283 AND
B.REQUEST_NBR = 1 AND B.VAT_SOURCE_DEFN = 'AP' AND A.BUSINESS_UNIT =
B.BUSINESS_UNIT)

Process 135283 ABENDED at Step SII_VAT_RGS.21FthSrc.FetchHDR (SQL) -- RC =
1841 (108,524)

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

PSAESRV completed service request at 05.16.53 2017-09-26

"

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