EGL: FEC Export, Different SetIDs For ACCOUNT_TBL And ALTACCT_TBL (Doc ID 2211903.1)

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.

Symptoms

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?

STEPS
-----------------------
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: EURO
Ledger Code [blank]                            Report By: Account
Fiscal Year: 2013                                Detail/Summary: Detail
From Period: 7
To Period: 7

Extract Options
  Extract Data [checked]
  Generate File [checked]
  Include Field Names


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully create the required FEC extract output file.

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