My Oracle Support Banner

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.

Symptoms

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.

 

Steps:

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

Error:

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

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


 

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
References


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