My Oracle Support Banner

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

Last updated on AUGUST 20, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
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.

Changes

 

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
Changes
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.