PC_EX_TO_PC/PC_PRICING not creating the FOREIGN_CURRENCY and FOREIGN_AMOUNT correctly (Doc ID 1349192.1)

Last updated on JUNE 02, 2015

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 18-Dec-2013***

Symptoms

On : 9.1 version, Expense Integration, Prod

For timesheet for an employee is processed, The foreign amount and foreign currency fields are not getting created as per the rate set definition in situations where the employee currency is different from project BU currency.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Rate by Employee ('KU0043')- Define the rate in 'USD' for an employee.
2. Create a Rate set - TLX as source - ACT as target row generated with Rate Option - 'ECO' and To Currency -'CAD'.
3. Create a Contract link the Rate set in Contract Terms page. The PC BU in Contracts Terms page is CAN01.
4. Create a Project (K1) in Contract Terms page. By default uses 'CAN01' PC BU. Use the integration template 'CANADA'.
5. Create an activity (K1).
6. Activate the contract.
7. Create a time sheet for enter the PC BU - CAN01, Project -K1 and Activity K1 and other time sheet related information and Submit. Continue the approval process.
8. Run the Expense Processing.
9. Run the PC_EX_TO_PC.
10. In PROJ_RESOURCE table, The FOREIGN_CURRENCY field on the target rows is 'USD' for the target 'ACT' rows generated and the FOREIGN_AMOUNT is also in USD.

The expectation is to have the target rows generated with the FOREIGN_CURRENCY - CAD and FOREIGN_AMOUNT in Canadian Dollars as per the rate set definition.

ACTUAL BEHAVIOR
---------------
The FOREIGN_CURRENCY and FOREIGN_AMOUNT of target rows generated when
running PC_EX_TO_PC on PS_PROJ_RESOURCE are not inline with the rate set
definition.

EXPECTED BEHAVIOR
-----------------------
The FOREIGN_CURRENCY and FOREIGN_AMOUNT of target rows generated when
running PC_EX_TO_PC on PS_PROJ_RESOURCE should be in line with the rate set
definition.

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