EAP WTHD16: APY8056 Fails in Tools 8.49 Citing Error Position: 1503 Return: 904 - ORA-00904: "A": invalid identifier (Doc ID 2225095.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

1099 To Send Report process, APY8056, fails with Tools 8.49

ERROR:
Message Reason: File: E:\pt84924b-retail\peopletools\SRC\pssys\qpm.cppSQL error. Stmt #: 5741 Error Position: 1503 Return: 904 - ORA-00904: "A": invalid identifier
Failed SQL stmt:SELECT A.WTHD_RPT_ID, A.WTHD_ENTITY, A.CALENDAR_SETID, A.CALENDAR_ID, A.FISCAL_YEAR, A.PERIOD, TO_CHAR(A.PROCESS_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"'), A.VENDOR_SETID, A.VENDOR_ID, A.VNDR_LOC, A.ADDRESS_SEQ_NUM, A.LINE_NO, A.SEND_STATUS, A.DESCR, A.CURRENCY_CD, A.WTHD_BASIS_AMT, A.WTHD_LIABILITY_AMT, A.PAID_AMT, A.SEX, TO_CHAR(A. (200,0)

Texto de error de Motor de Impresión de Crystal Reports: Error in File \\cmsfsp01\psft-lei-8.49\psft\sp\fs900\crw\eng\apy8056-.rpt:
F p\fs900\crw\eng\apy8056-.rpt:
F %6 %7 %8 %9 (65,30)
 Message Set Number: 65
 Message Number: 30
 Message Reason: Texto de error de Motor de Impresión de Crystal Reports: Error in File \\cmsfsp01\psft-lei-8.49\psft\sp\fs900\crw\eng\apy8056-.rpt:
F p\fs900\crw\eng\apy8056-.rpt:
F %6 %7 %8 %9 (65,30)

STEPS:
1.  Apply 1099 Update for 2016 in Tools 8.49 environment
2.  Vendors > 1099/Global Withholding > 1099 Reports > 1099 to Send Detail

 

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