Interface Service Cost To Projects Writing Duplicate Entries Into Projects

(Doc ID 2295340.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Teleservice - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Debrief / Field Service Report

Interface Service Cost to Projects is creating duplicate entries into projects interface table. This happens when the PA Transaction Import failed for any reason and marked the record in pa_transaction_interface_all with transaction_status_code = 'E'

Expect that duplicate transactions will not be posted to projects

The issue can be reproduced at will with the following steps:
1. Submit Interface Service Cost to Projects conc program       
2. After that, execute "PAXTRTRX: PRC: Transaction Import".     
3. If for any reason the import fails, the record in pa_transaction_interface_all is marked with transaction_status_code = 'E'
4. When that happens, if the Interface Service Cost to Projects conc program is executed again, the same record will be posted again on the Interface table

The issue has the following business impact:
Due to this issue,duplicate transactions are created in projects


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