My Oracle Support Banner

AP:8SP1:1099_RPT_POST is abending at 1099_RPT_PST.DIRECTS.Step01 (SQL) -- RC = (Doc ID 612346.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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

Information in this document applies to any platform.



This document was previously published as Customer Connection Solution 715399

Symptoms


1099_RPT_POST is abending at 1099_RPT_PST.DIRECTS.Step01 (SQL) -- RC = 30021 (108,524)
in SYBASE

PeopleTools 8.16 - Application Engine
Copyright (c) 1988-2002 PeopleSoft, Inc.
All Rights Reserved


SQL error. Stmt #: 1316  Error Position: 0  Return: 257 - Implicit conversion from datatype 'CHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.


INSERT INTO PS_1099_RPT_TMP(PROCESS_INSTANCE , WTHD_ENTITY , VENDOR_SETID , VENDOR_ID , VNDR_LOC , ADDRESS_SEQ_NUM , BUSINESS_UNIT , LINE_NO , 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 , CALENDAR_SETID , CALENDAR_ID , FISCAL_YEAR , PERIOD , FROM_DT , THRU_DATE , RPT_DT , NAME1 , NAME2 , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , COUNTY , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , MINIMUM_AMT) SELECT 10 , TMP.WTHD_ENTITY , TMP.VENDOR_SETID , TMP.VENDOR_ID , TMP.VNDR_LOC , TMP.ADDRESS_SEQ_NUM , TMP.BUSINESS_UNIT , 9 , 'DIRECT SALES ONLY' , MAX(TMP.CURRENCY_CD) , SUM(TMP.WTHD_BASIS_AMT) , SUM(TMP.WTHD_LIABILITY_AMT) , SUM(TMP.PAID_AMT) , MAX(VWTHD.SEX) , MAX(VWTHD.BIRTHDATE) , MAX(VWTHD.BIRTHPLACE) , MAX(VWTHD.NUM_CHILDREN) , MAX(VWTHD.COMPANY_FLG) , MAX(VWTHD.TAX_DIST_REF) , MAX(VWTHD.CERTIFICATE_TYPE) , MAX(VWTHD.CERTIFICATE_NUM) , MAX(VWTHD.CERTIFICATE_EXP_DT) , MAX(VWTHD.DIRECT_SALES) , MAX(VWTHD.SECOND_TIN) , MAX(VWTHD.STATE_TAX_WH) , MAX(VWTHD.TIN_TYPE) , MAX(VWTHD.TIN) , MAX(VWTHD.WTHD_CONTROL_NAME) , MAX(VWTHD.PROFESSION) , 'SHARE' , 'A1' , 2001 , 1 , '2001-01-01' , '2001-12-31' , '2002-01-10' , VNDR.NAME1 , VNDR.NAME2 , MAX(VNDR.COUNTRY) , MAX(VNDR.ADDRESS1) , MAX(VNDR.ADDRESS2) , MAX(VNDR.ADDRESS3) , MAX(VNDR.ADDRESS4) , MAX(VNDR.CITY) , MAX(VNDR.NUM1) , MAX(VNDR.NUM2) , MAX(VNDR.HOUSE_TYPE) , MAX(VNDR.COUNTY) , MAX(VNDR.ADDR_FIELD1) , MAX(VNDR.ADDR_FIELD2) , MAX(VNDR.ADDR_FIELD3) , MAX(VNDR.STATE) , MAX(VNDR.POSTAL) , MAX(VNDR.GEO_CODE) , MAX(VNDR.IN_CITY_LIMIT) , MAX(MINIMUM_AMT) FROM PS_WTHD_1099_TMP2 TMP , PS_VENDOR_ADDR VNDR , PS_VENDOR_WTHD VWTHD , PS_WTHD_RPT_DTL DTL WHERE TMP.PROCESS_INSTANCE = 10 AND DTL.WTHD_RPT_ID = 'US_REPORT' AND TMP.WTHD_CLASS= 9 AND TMP.VENDOR_SETID = VWTHD.SETID AND TMP.VENDOR_ID = VWTHD.VENDOR_ID AND TMP.VNDR_LOC = VWTHD.VNDR_LOC AND TMP.WTHD_ENTITY = VWTHD.WTHD_ENTITY AND VWTHD.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VENDOR_WTHD VW WHERE VW.SETID = VWTHD.SETID AND VW.VENDOR_ID = VWTHD.VENDOR_ID AND VW.VNDR_LOC = VWTHD.VNDR_LOC AND VW.WTHD_ENTITY = VWTHD.WTHD_ENTITY AND VW.EFFDT <= '2002-01-10') AND VWTHD.SETID = VNDR.SETID AND VWTHD.VENDOR_ID = VNDR.VENDOR_ID AND VWTHD.ADDRESS_SEQ_NUM = VNDR.ADDRESS_SEQ_NUM AND VNDR.EFF_STATUS = 'A' AND VNDR.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VENDOR_ADDR ADDR WHERE VNDR.SETID = ADDR.SETID AND VNDR.VENDOR_ID = ADDR.VENDOR_ID AND VNDR.ADDRESS_SEQ_NUM = ADDR.ADDRESS_SEQ_NUM AND ADDR.EFF_STATUS = 'A' AND ADDR.EFFDT <= '2002-01-10') AND VNDR.NAME1 <> ' ' GROUP BY TMP.WTHD_ENTITY, TMP.VENDOR_SETID, TMP.VENDOR_ID, TMP.VNDR_LOC, TMP.ADDRESS_SEQ_NUM, TMP.BUSINESS_UNIT, VNDR.NAME1, VNDR.NAME2

Process 10 ABENDED at Step 1099_RPT_PST.DIRECTS.Step01 (SQL) -- RC = 30021 (108,524)

Changes

 

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
Changes
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.