EPC8.9+: PC_EXPRSS_AM not summarizing, but creating multiple cost rows in PS_INTFC_FIN when currency effective dates are different (Doc ID 1278710.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

Create a project and activity. The asset integration rule on the project is set to "Many Assets From Each Activity" and Distribution as "Activity Quantity Distribution". Create 3 cost rows in PS_PROJ_RESOURCE with different transaction dates and currency effective dates. Create an express asset.

The number of assets to create is set to '1' and quantity on each asset '1'. Run the PC_EXPRSS_AM. As the cost rows have different currency effective dates, the process will create 3 cost rows with different resource quantities, which are adding up to 1.

This is not correct, it should summarize the entries from PS_PROJ_RESOURCE and insert 1 entry into the interface tables, regardless if the currency effective dates are different.

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