My Oracle Support Banner

Duplicate Vendor Report Abend At DUP_VNDR_AE.TIN_0000.Step01 (Doc ID 2514212.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

When running Duplicate Supplier Report job on Microsoft SQL Server, the app engine AP_VNDR_AE will error with the following:

-- 13:22:54.003 Process 173674 ABENDED at Step DUP_VNDR_AE.TIN_0000.Step01
(Action SQL) -- RC = 8601
ROLLBACK
/
-- 13:22:54.089 SQL Error: [Microsoft][ODBC Driver 13 for SQL Server][SQL
Server]'TO_CHAR' is not a recognized built-in function name.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) could not
be prepared. (SQLSTATE 42000) 8180

REPLICATION STEPS
=================
Suppliers > Supplier Information > Maintain > Duplicate Supplier Report
Options:
Specific Set ID
Withholding 'TIN'
Voucher Payment 'All Suppliers Have vchrs paid'

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
References


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