R12 PAAPIMPB: PRC: Interface Supplier Costs Creating Duplicate Supplier Costs in Projects After the P2P Consolidated Code Fix Patch. (Doc ID 2166687.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PRC: Interface Supplier Costs creating duplicate invoice amounts in Projects.  Development finds the following about the duplicates:

1. The duplicates were not created at the same time as there is a time lag which is seen from the creation_date timestamp
2. They were created by different programs, expenditure id 2371654 was created by Transaction Import (program_id = 33051) whereas its duplicate expenditure id 2371660 was created by Interface Supplier Costs (program_id = 39591)
3. Since they were created by different programs, their expenditure ids are also different.

You can find out what concurrent program created the item by running the following query

select * from fnd_concurrent_programs_tl where language = 'US' and concurrent_program_id = <<program_id>>;

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