EGL9.2: How to Include Employee Details in FEC (Audit Files France) for Accounting Entries from PeopleSoft Global Payroll (Doc ID 2051941.1)

Last updated on NOVEMBER 16, 2016

Applies to:

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

Goal

Customers have to submit FEC file for French tax audit purpose where all accounting entries booked during a fiscal year are brought together. In FEC it is required to include details about customer, supplier and employee transactions (data from PeopleSoft AP,AR,GP subsystems) also.  Customers are facing no trouble with details from AP and AR. However, no details could be found on accounting entries for employee.

Employee accounting entries usually come from HR. The details of transaction accounting entries could be found in GP_ACC_LINE_STG record in HRMS, where-as transactions in accounting entry table(GP_ACC_LINE) in Financials are aggregate only.
 

Solution

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