PC_PRICING Not Using Currency Effective Date (CUR_EFFDT) On Source Rows For The Target Rows (Doc ID 1993284.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

PC_PRICING not using Currency Effective Date (CUR_EFFDT) on Source Rows for the Target Rows

Replication steps:

1. Incoming transactions with a Rate Type specified (it is the Current Rate, Rate Type value = CRRNT) but the Market Rates using that Rate Type are changed on a monthly basis using the delivered Effective Dating.
2. Run PC_INTFEDIT--> PC_PRICIN picks up the source rows coming in to PC with a Rate Type and Effective Date the target rows it creates use the Rate Type from the source transaction. However, the Effective Date for the target rows have the wrong base currency value.

Scenario:
Assume a USD Market Rate configuration as follows:
From To Rate Type Effdt Rate
GBP USD CRRNT 02/01/2015 1.6
GBP USD CRRNT 03/01/2015 1.8

Now post a Receipt Accrual transaction to Project Costing (for example via the INTFC_PROJ_RES Transaction Loader) as follows:

Type Acctg Date Currency Value Rate Type Currency Effdt GBP Value
REC 02/01/2015 USD 100,000 CRRNT 02/01/2015 62,500
ICC 02/01/2015 USD 4,000 CRRNT 02/01/2015 2,500

Now post a new transaction the following day to completely remove the accrual (note the transaction / accounting date is later but the currency effective date is the same):

Type Acctg Date Currency Value Rate Type Currency Effdt GBP Value
REC 03/01/2015 USD (100,000) CRRNT 02/01/2015 (62,500)
ICC 03/01/2015 USD (4,000) CRRNT 03/01/2015 (2,222.22) --> It used incorrect CUR_EFFDT

Actual:
Even though the two Receipt Accrual transactions cancel each other out completely and the net value in USD and GBP is zero, the corresponding target rows generated by the Pricing Engine end up with a net GBP value of £277.78 which is incorrect.

Expected:
The target rows should use the CUR_EFFDT from the Source row.



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