FEC: The Report Shows Foreign Amount Without Signature (Doc ID 2214159.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On :  9.2 version, Global

ACTUAL BEHAVIOR  
---------------
FEC: The report shows foreign amount without any signature  

The issue is that column 17 (POSTED_TRAN_AMT) has always positive amount for both debit and credit which is wrong and different as it is in PS_LEDGER table.

EXPECTED BEHAVIOR
-----------------------
FEC: The report should reflect the proper sign (+/-) as it is in ledger table
---------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Ensure GL module is included for FEC reporting: Statutory Reports > FEC
Audit Files FRA > Setup FEC Products FRA
2) Find out if you account is setup for FEC reporting: Statutory Reports >
FEC Audit Files FRA > Setup FEC Accounts FRA (ex:530000)
3) Create a journal and post  it using the specific account above
4) Run the FEC Data report: Statutory Reports > FEC Audit Files FRA > Export
FEC Data FRA
5) Read the report and noticed that POSTED_TRAN_AMT (PS_FEC_RPT_D_ACC) field
is always positive which is wrong and different as it is in PS_LEDGER table.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use properly this report

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