EGL: FEC Export, Different SetIDs For ACCOUNT_TBL And ALTACCT_TBL
Last updated on DECEMBER 07, 2016
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
FEC Export, different SetIDs for ACCOUNT_TBL and ALTACCT_TBL
When running the French FEC Export process, the resulting file has no data (just the column headers). Going through the App Engine trace, it would appear that the problem is because the SetID for our Alternate Accounts (FS_40, ALTACCT_TBL) is different than the SetID for our GL Accounts (FS_05, ACCOUNT_TBL). So when the program attempts to get a list of accounts out of the FEC_ACCOUNT_TBL, it's looking for SetID "SHARE" instead of "SARLP" and gets no rows, so there's nothing to process as it goes.
What are we missing?
The issue can be reproduced at will with the following steps:
1. Set up FEC accounts for reporting
2. Run the Export FEC data FRA process for below parameters to create the output file -
Business Unit: FRA01 Include Beginning Balances [checked]
Ledger Code [blank] Report By: Account
Fiscal Year: 2013 Detail/Summary: Detail
From Period: 7
To Period: 7
Extract Data [checked]
Generate File [checked]
Include Field Names
The issue has the following business impact:
Due to this issue, users cannot successfully create the required FEC extract output file.
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