As Incurred Rev (BIL) Cannot Be Converted At The Same Rate As The Related SFA Cost Row

(Doc ID 2367584.1)

Last updated on MARCH 07, 2018

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On :  Grants 9.2 version, Functionality

ACTUAL BEHAVIOR  
---------------

PROJ_RESOURCE: Details of the currency

ACT
Transaction Date = 11/3 (invoice date of voucher)
Accounting Date =11/7
Currency Effective Date = 11/3 ( Rate of invoice date when then AP transaction for which this SFA was generated)
Currency Rate = Based on rate for 11/3

SFA
Transaction Date = 11/3 (Date Processed)
Accounting Date = 11/7(Date Processed unless you specify an Override Accounting Date)
Currency Effective Date = 11/3 ( Rate of invoice date when then AP transaction for which this SFA was generated)
Currency Rate = Based on rate for 11/3

When the SFA is priced (called in the Facilities Admin process), the BIL row for the SFA is created with:

BIL
Transaction Date = 11/7 (Copied from SFA row)
Accounting Date = 11/7(Copied from SFA row)
Currency Effective Date = 11/3 (Copied from SFA row)
Currency Rate = Based on rate for 11/3 (Copied from SFA row)

CA_ACCTG_LN_PC:

Accounting entry for the BIL row used the currency conversion date of 11/7 for revenue -- AMOUNT_BSE
Accounting entry for the SFA row used the currency conversion date of 11/3 -- RESOURCE_AMOUNT ( After POC for  BUG 24786484  - POC FOR GM_GMFACS BUGS 24608536 AND 24608306 )


when you run Schedule and Process Revenue, the only options on the Contracts Installation Options for Currency Conversion are:  Accounting Date or Transaction Date, not Currency Effective Date.  In either option, the BIL for revenue would be converted at a different rate (date when GM_GMFACS was run) than the SFA row (Rate when the source transaction was created). Based on the set up we want to see BIL and SFA row to have the same currency conversion date used in CA_ACCTG_LN_PC


EXPECTED BEHAVIOR
-----------------------
If the rate set map 1:1 for SFA to BIL, the SFA and BIL row in CA_ACCTG_LN_PC should have same amount calculated using the same currency conversion rate. It could be either the Accounting date /transaction date of the source transaction.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Create new market rate for say date 11/4. AP transaction created with invoice date of 11/3

1. Grants and Project BU is EGV05
2. Commitment control enable for PC, GL, AP, PO. Necessary set up done.
4. GL - DEUE1 is the primary BU with base currency as 'EUR'
5. Create a Proposal, submit and generate an award in EGV05. F&A is 50% of the expense.
6. Modify the Project Integration template such that it uses the GL BU of DEUE1 as primary BU.
7. Create a PO in DEUE1 with currency as 'EUR'. QTY 2 - Total Amount 2000 EUR. Budget check and dispatch
8. Run PC_PO_TO_PC - Proj_resource has 'COM' with resource_amount/currency_cd = 4000 / USD based on conversion rate that was set as 2 when converting EUR to USD
9. KK shows 2000 EUR as encumbrace
10. Create a voucher for this PO, using Qty 1, 1000 GBP, budget check and post
11. KK shows expense as 1333.33 as emcumbrance and expense
12. Run PC_AP_TO_PC
13. Run PC_PO_TO_PC
14. Run PC_POADJUST
15. Run GM_GMFACS  -- Run on 11/7


ACTUAL DATA

CA_ACCTG_LN_PC has Accounting entry

SFA :
RESOURCE_AMOUNT - 666.67
AMOUNT_BSE =0
CUR_EFFDT = 11/3
CURRENCY_CD =EUR
FOREIGN_AMOUNT = 500
FOREIGN_CURRENCY = GBP
RATE_MULTI = 1
RATE_DIV = 0.75

BIL :
RESOURCE_AMOUNT - 759.66
AMOUNT_BSE =555.56
CUR_EFFDT = 11/7
CURRENCY_CD =EUR
FOREIGN_AMOUNT = 500
FOREIGN_CURRENCY = GBP
RATE_MULTI = 1
RATE_DIV = 0.9

EXPECTED DATA

CA_ACCTG_LN_PC should have Accounting entry..

SFA :
RESOURCE_AMOUNT - 759.66
AMOUNT_BSE =666.67
CUR_EFFDT = 11/3
CURRENCY_CD =EUR
FOREIGN_AMOUNT = 500
FOREIGN_CURRENCY = GBP
RATE_MULTI = 1
RATE_DIV = 0.75

BIL :
RESOURCE_AMOUNT - 759.66
AMOUNT_BSE = 666.67 ( Currency conversion used should be that of 11/3 and not 11/7)
CUR_EFFDT = 11/3
CURRENCY_CD =EUR
FOREIGN_AMOUNT = 500
FOREIGN_CURRENCY = GBP
RATE_MULTI = 1
RATE_DIV = 0.75

 

Changes

 

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