My Oracle Support Banner

EAP: Fatal SQL Error When Trying to Load Voucher Data Using ExcelUploadforVoucher (Doc ID 2690473.1)

Last updated on JULY 13, 2020

Applies to:

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

Symptoms

User is getting error when trying to upload Voucher using Excel Upload for Voucher.

Steps:
1) Open the excel upload template for voucher.
2) Enter required data.

Error:
Fatal SQL error occurred.


Error in Application Server Log:

Return:  8604 - [Microsoft][SQL Server Native Client 11.0]Invalid character value for cast specification (SQLSTATE 22005) 0

 Statement:  INSERT INTO PS_VCHR_LINE_STG (BUSINESS_UNIT,VCHR_BLD_KEY_C1,VCHR_BLD_KEY_C2,VCHR_BLD_KEY_N1,VCHR_BLD_KEY_N2,VOUCHER_ID,VOUCHER_LINE_NUM,BUSINESS_UNIT_PO,PO_ID,LINE_NBR,SCHED_NBR,DESCR,MERCHANDISE_AMT,ITM_SETID,INV_ITEM_ID,QTY_VCHR,STATISTIC_AMOUNT,UNIT_OF_MEASURE,UNIT_PRICE,DSCNT_APPL_FLG,TAX_CD_VAT,BUSINESS_UNIT_RECV,RECEIVER_ID,RECV_LN_NBR,RECV_SHIP_SEQ_NBR,MATCH_LINE_OPT,DISTRIB_MTHD_FLG,SHIPTO_ID,SUT_BASE_ID,TAX_CD_SUT,ULTIMATE_USE_CD,SUT_EXCPTN_TYPE,SUT_EXCPTN_CERTIF,SUT_APPLICABILITY,VAT_APPLICABILITY,VAT_TXN_TYPE_CD,VAT_USE_ID,ADDR_SEQ_NUM_SHIP,BUS_UNIT_RELATED,VOUCHER_ID_RELATED,VENDOR_ID,VNDR_LOC,DESCR254_MIXED,SPEEDCHART_KEY,BUSINESS_UNIT_GL,ACCOUNT,ALTACCT,OPERATING_UNIT,PRODUCT,FUND_CODE,CLASS_FLD,PROGRAM_CODE,BUDGET_REF,AFFILIATE,AFFILIATE_INTRA1,AFFILIATE_INTRA2,CHARTFIELD1,CHARTFIELD2,CHARTFIELD3,DEPTID,PROJECT_ID,BUSINESS_UNIT_PC,ACTIVITY_ID,ANALYSIS_TYPE,RESOURCE_TYPE,RESOURCE_CATEGORY,RESOURCE_SUB_CAT,ECQUEUEINSTANCE,ECTRANSID,TAX_DSCNT_FLG,TAX_FRGHT_FLG,TAX_MISC_FLG,TAX_VAT_FLG,PHYSICAL_NATURE,VAT_RCRD_INPT_FLG,VAT_RCRD_OUTPT_FLG,VAT_TREATMENT,VAT_SVC_SUPPLY_FLG,VAT_SERVICE_TYPE,COUNTRY_LOC_BUYER,STATE_LOC_BUYER,COUNTRY_LOC_SELLER,STATE_LOC_SELLER,COUNTRY_VAT_SUPPLY,STATE_VAT_SUPPLY,COUNTRY_VAT_PERFRM,STATE_VAT_PERFRM,STATE_SHIP_FROM,STATE_VAT_DEFAULT,REQUESTOR_ID,VAT_ENTRD_AMT,VAT_RECEIPT,VAT_RGSTRN_SELLER,IST_TXN_FLG,WTHD_SW,WTHD_CD,MFG_ID,USER_VCHR_CHAR1,USER_VCHR_CHAR2,USER_VCHR_DEC,USER_VCHR_NUM1,USER_LINE_CHAR1,CUSTOM_C100_B1,CUSTOM_C100_B2,CUSTOM_C100_B3,CUSTOM_C100_B4,CUSTOM_C1_B,USER_SCHED_CHAR1,CUSTOM_C100_C1,CUSTOM_C100_C2,CUSTOM_C100_C3,CUSTOM_C1_C,VAT_RVRSE_CHG_GDS,PACKSLIP_NO,BUSINESS_UNIT_BI,BI_INVOICE,LINE_SEQ_NUM,CATEGORY_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,:68,:69,:70,:71,:72,:73,:74,:75,:76,:77,:78,:79,:80,:81,:82,:83,:84,:85,:86,:87,:88,:89,:90,:91,:92,:93,:94,:95,:96,:97,:98,:99,:100,:101,:102,:103,:104,:105,:106,:107,:108,:109,:110,:111,:112,:113,:114,:115,:116,:117,:118)

 Original Statement:  %Insert(:1)

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.