My Oracle Support Banner

ECA: PSA_ACCTGGL Process Is Using An Incorrect Date for Currency Conversion for 'BIL' Rows Associated with 'SFA' Row. (Doc ID 2367584.1)

Last updated on NOVEMBER 17, 2020

Applies to:

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

Symptoms

PSA_ACCTGGL process is using an incorrect date for currency conversion for 'BIL' rows associated with 'SFA' row.


Replication Steps in Demo:     

  1. Create a new market rate for say date 11/4. Payables transaction was created with an invoice date of 11/3.
  2. Grants and Project BU is EGV05.
  3. Commitment control enable for PC, GL, AP, PO. The necessary setup is done.
  4. 'DEUE1' is the primary GL 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 the primary BU.
  7. Create a PO in DEUE1 with currency as 'EUR'. QTY 2 - Total Amount of 2000 EUR. Budget check and dispatch.
  8. Run PC_PO_TO_PC - PROJ_RESOURCE has 'COM' with resource_amount /currency_cd of 4000 / USD based on conversion rate that was set as 2 when converting EUR to USD.
  9. Commitment Control ledger shows 2000 EUR as an encumbrance.
  10. Create a voucher for this PO, using Qty 1, 1000 GBP, budget check, and post.
  11. Commitment Control ledger shows expense as 1333.33 as encumbrance 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 (FA Rates are specified as 50% for the Project Activity



Actual Data:

CA_ACCTG_LN_PC has an 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  <<<<<<< This is incorrect. The expectation is that it should be 666.67 based on a 0.75 conversion rate on 11/3
CUR_EFFDT = 11/7        <<<<<<< This is incorrect. Expectation is to that this value should be 11/7
CURRENCY_CD =EUR
FOREIGN_AMOUNT = 500
FOREIGN_CURRENCY = GBP
RATE_MULTI = 1
RATE_DIV = 0.9           <<<<<<< This is incorrect. The expectation is that it should be 0.75 which is conversion rate on 11/3

Expected Data

CA_ACCTG_LN_PC should have an 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

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.