EAP: ABEND At Step AP_APY1099.BD200.Step50 (SQL) -- RC = 904 (108,524) "WTHD"."FATCA_INDICATOR": invalid identifier (Doc ID 2108645.1)

Last updated on FEBRUARY 22, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

After applying 2015 1099 patch <Bug 21813465>, AP_APY1099 abends with the following error:

Stmt #: 1703 Error Position: 2023 Return: 904 - ORA-00904: "WTHD"."FATCA_INDICATOR": invalid identifier
Failed SQL stmt: INSERT INTO PS_WTHD_TO_SND_DTL (WTHD_RPT_ID, WTHD_SETID, WTHD_CNTL_ID, WTHD_ENTITY, WTHD_TYPE, CALENDAR_SETID, CALENDAR_ID, FISCAL_YEAR, PERIOD, PROCESS_DTTM, VENDOR_SETID, BUSINESS_UNIT, VENDOR_ID, VNDR_LOC, PAYER_TIN, ADDRESS_SEQ_NUM, LINE_NO, SEND_STATUS, ACTIVE_STATUS, DESCR, CURRENCY_CD, WTHD_BASIS_AMT, WTHD_LIABILITY_AMT, PAID_AMT, SEX, BIRTHDATE, BIRTHPLACE, NUM_CHILDREN, COMPANY_FLG, TAX_DIST_REF, CERTIFICATE_TYPE, CERTIFICATE_NUM, CERTIFICATE_EXP_DT, DIRECT_SALES, SECOND_TIN, STATE_TAX_WH, TIN_TYPE, TIN, WTHD_CONTROL_NAME, PROFESSION, WTHD_PAN_NUM, WTHD_PAN_WARD, TRADE_BUS_INC, COUNTRY_PAID, FOREIGN_TAX_PAID, GBR_VENDOR_TYPE, GBR_REG_NO, GBR_VERIFY, GBR_VERIFY_NBR, GBR_VERIFY_DATE, BOND_PREMIUM, MARKET_DISCOUNT, PRIVATE_BOND_INT, TAX_EXMPT_INTEREST, BOND_PREMIUM_TAXEX, FATCA_INDICATOR, NAME1, NAME2, COUNTRY, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, NUM1, NUM2, HOUSE_TYPE, ADDR_FIELD1, ADDR_FIELD2, ADDR_FIELD3, COUNTY, STATE, POSTAL, GEO_CODE, IN_CITY_LIMIT, CUSIP_NBR, STATE_INCOME) SELECT WTHD.WTHD_RPT_ID, WTHD.WTHD_SETID, WTHD.WTHD_CNTL_ID, WTHD.WTHD_ENTITY, WTHD.WTHD_TYPE, WTHD.CALENDAR_SETID, WTHD.CALENDAR_ID, WTHD.FISCAL_YEAR, WTHD.PERIOD, TO_TIMESTAMP('2016-02-17-11.44.07.387506','YYYY-MM-DD-HH24.MI.SS.FF'), WTHD.VENDOR_SETID, WTHD.BUSINESS_UNIT, WTHD.VENDOR_ID, WTHD.VNDR_LOC, WTHD.PAYER_TIN, WTHD.ADDRESS_SEQ_NUM, WTHD.LINE_NO, 'C', 'A', WTHD.DESCR, WTHD.CURRENCY_CD, 0 , 0, 0, WTHD.SEX, WTHD.BIRTHDATE, WTHD.BIRTHPLACE, WTHD.NUM_CHILDREN, WTHD.COMPANY_FLG, WTHD.TAX_DIST_REF, WTHD.CERTIFICATE_TYPE, WTHD.CERTIFICATE_NUM, WTHD.CERTIFICATE_EXP_DT, WTHD.DIRECT_SALES, WTHD.SECOND_TIN, WTHD.STATE_TAX_WH, WTHD.TIN_TYPE, WTHD.TIN, WTHD.WTHD_CONTROL_NAME, WTHD.PROFESSION, WTHD.WTHD_PAN_NUM, WTHD.WTHD_PAN_WARD, WTHD.TRADE_BUS_INC, WTHD.COUNTRY_PAID, WTHD.FOREIGN_TAX_PAID, WTHD.GBR_VENDOR_TYPE, WTHD.GBR_REG_NO, WTHD.GBR_VERIFY, WTHD.GBR_VERIFY_NBR, WTHD.GBR_VERIFY_DATE, WTHD.BOND_PREMIUM, WTHD.MARKET_DISCOUNT, WTHD.PRIVATE_BOND_INT, WTHD.TAX_EXMPT_INTEREST, WTHD.BOND_PREMIUM_TAXEX, WTHD.FATCA_INDICATOR, WTHD.NAME1, WTHD.NAME2, WTHD.COUNTRY, WTHD.ADDRESS1, WTHD.ADDRESS2, WTHD.ADDRESS3, WTHD.ADDRESS4, WTHD.CITY, WTHD.NUM1, WTHD.NUM2, WTHD.HOUSE_TYPE, WTHD.ADDR_FIELD1, WTHD.ADDR_FIELD2, WTHD.ADDR_FIELD3, WTHD.COUNTY, WTHD.STATE, WTHD.POSTAL, WTHD.GEO_CODE, WTHD.IN_CITY_LIMIT, WTHD.CUSIP_NBR, 0 FROM PS_WTHD_1099_VW1 WTHD WHERE WTHD.FISCAL_YEAR = 2015 AND WTHD.WTHD_BASIS_AMT <> 0 AND NOT EXISTS ( SELECT 'X' FROM PS_WTHD_1099_3TMP DTL WHERE WTHD.WTHD_RPT_ID = DTL.WTHD_RPT_ID AND WTHD.WTHD_SETID = DTL.WTHD_SETID AND WTHD.WTHD_CNTL_ID = DTL.WTHD_CNTL_ID AND WTHD.WTHD_CNTL_ID = DTL.WTHD_CNTL_ID AND WTHD.WTHD_ENTITY = DTL.WTHD_ENTITY AND WTHD.WTHD_TYPE = DTL.WTHD_TYPE AND WTHD.CALENDAR_SETID = DTL.CALENDAR_SETID AND WTHD.CALENDAR_ID = DTL.CALENDAR_ID AND WTHD.FISCAL_YEAR = DTL.FISCAL_YEAR AND WTHD.PERIOD = DTL.PERIOD AND WTHD.VENDOR_SETID = DTL.VENDOR_SETID AND WTHD.VENDOR_ID =DTL.VENDOR_ID AND WTHD.VNDR_LOC = DTL.VNDR_LOC AND WTHD.PAYER_TIN = DTL.PAYER_TIN AND WTHD.TIN_TYPE = DTL.TIN_TYPE AND WTHD.TIN = DTL.TIN AND WTHD.NAME1 = DTL.NAME1 AND WTHD.NAME2 = DTL.NAME2 AND WTHD.LINE_NO = DTL.LINE_NO) AND EXISTS ( SELECT 'X' FROM PS_WTHD_1099_3TMP TMP WHERE WTHD.WTHD_RPT_ID = 'US_REPORT' AND WTHD.WTHD_SETID = 'BGSUN' AND WTHD.WTHD_CNTL_ID = 'CONTROL' AND WTHD.WTHD_CNTL_ID = TMP.WTHD_CNTL_ID AND WTHD.WTHD_ENTITY = TMP.WTHD_ENTITY AND WTHD.WTHD_TYPE = TMP.WTHD_TYPE AND WTHD.CALENDAR_SETID = TMP.CALENDAR_SETID AND WTHD.CALENDAR_ID = TMP.CALENDAR_ID AND WTHD.FISCAL_YEAR = TMP.FISCAL_YEAR AND WTHD.PERIOD = TMP.PERIOD AND WTHD.VENDOR_SETID = TMP.VENDOR_SETID AND WTHD.VENDOR_ID = TMP.VENDOR_ID AND WTHD.PAYER_TIN = TMP.PAYER_TIN AND WTHD.TIN_TYPE = TMP.TIN_TYPE AND WTHD.TIN = TMP.TIN AND WTHD.NAME1 = TMP.NAME1 AND WTHD.NAME2 = TMP.NAME2) AND NOT EXISTS ( SELECT 'X' FROM PS_WTHD_TO_SND_DTL TOSEND WHERE TOSEND.WTHD_RPT_ID = 'US_REPORT' AND WTHD.WTHD_SETID = TOSEND.WTHD_SETID AND WTHD.WTHD_CNTL_ID = TOSEND.WTHD_CNTL_ID AND WTHD.WTHD_ENTITY = TOSEND.WTHD_ENTITY AND WTHD.WTHD_TYPE = TOSEND.WTHD_TYPE AND WTHD.CALENDAR_SETID = TOSEND.CALENDAR_SETID AND WTHD.CALENDAR_ID = TOSEND.CALENDAR_ID AND WTHD.FISCAL_YEAR = TOSEND.FISCAL_YEAR AND WTHD.PERIOD = TOSEND.PERIOD AND WTHD.VENDOR_SETID = TOSEND.VENDOR_SETID AND WTHD.VENDOR_ID =TOSEND.VENDOR_ID AND WTHD.BUSINESS_UNIT = TOSEND.BUSINESS_UNIT AND WTHD.VNDR_LOC = TOSEND.VNDR_LOC AND WTHD.PAYER_TIN = TOSEND.PAYER_TIN AND WTHD.ADDRESS_SEQ_NUM = TOSEND.ADDRESS_SEQ_NUM AND WTHD.LINE_NO = TOSEND.LINE_NO )

Process 512822 ABENDED at Step AP_APY1099.BD200.Step50 (SQL) -- RC = 904 (108,524)

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



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