Overdue Credit Card Data Report EX_CCOVD_RPT Goes To No Success When Employee Has > 1 Job Record
(Doc ID 2594482.1)
Last updated on AUGUST 20, 2020
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Overdue Credit Card Data Report EX_CCOVD_RPT goes to No Success when the employee has more than 1 job record.
Employees that have > 1 job record in PS_EX_EE_ORG_DTL are causing EX_CCOVD_RPT to go to No Success.
1. Pick up an employe having more than 1 employee record EMPL_RCD and with overdue transactions.
2. For this employee run EX_CCOVD_RPT - Overdue Credit Card Transactions. Travel and Expenses > Manage Accounting > Print Reports > Overdue Credit Card Data
-- 00:28:21.575 Process 573855 ABENDED at Step EX_CCOVD_RPT.GetData.InsTA1 (Action SQL) -- RC = 805 ROLLBACK /
-- 00:28:21.627 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_EX_CCOVD_TA16' with unique index 'PS_EX_CCOVD_TA16'. The duplicate key value is (573855, 1000694, VIS, 74064498114920124115599, 204258, Apr 23 2018 12
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