EEX 9.2: Expense Report Period End Accruals EXB Rows Missing PC Business Unit And Activity ID If DST Line Distribution Has Project Costing Values, And ChartField Inheritance For Project Is Enabled
(Doc ID 2587692.1)
Last updated on APRIL 21, 2020
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
For those Expense Report transactions that have yet to be posted, and Period End Accruals have been generated, if the original Expense Line Accounting Details contain Project Costing ChartField values (such as PC Business Unit, Project ID, and Activity ID), those values get properly defaulted in the DST rows of the Period End Accruals Accounting Entries.
However, should at the ChartField Inheritance level, for Expenses Control Accounts Group, the Project ID ChartField has been set to 'Always Inherit', then, when running the Period End Accruals Expenses process (FS_PEACCRL AE Program), it creates not only the DST rows (which are correct), but the EXB lines as well, and these ones only have Project ID ChartField populated, leaving PC Business Unit and Activity ID as blank.
1.- Log into the FSCM Online Applications as a System Administrator User
2.- Navigate to: Set Up Financials/Supply Chain > Business Unit Related > Expenses > Expenses Definition
3.- Open the needed Expenses Business Unit, and go to the Business Unit 1 tab, to ensure that at the Period End Accruals section, the below settings are configured:
a) Accrue Unprocessed Expenses = Y
b) Accrue Wallet Entries = Y
c) Accrue for Billable Expenses = Y
4.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > ChartField Inheritance > ChartField Inheritance
5.- Open the existing ChartField Inheritance Group 'Expenses Control Accounts' under Set ID SHARE
6.- Set ChartField Project to 'Always Inherit', and save the changes
7.- Navigate to: Set Up Financials/Supply Chain > Business Unit Related > Project Costing > Project Costing Options
8.- Open the needed Business Unit, and at the Project Costing Options tab, select: Business Unit, Project, Activity = Required
9.- Log into the FSCM Online Application as a Project Costing User
10.- Navigate to: Project Costing > Project Definitions > General Information
11.- Create a brand new Project ID, and set it to Approved and Active status
12.- Navigate to: Project Costing > Activity Definitions > Project Activities
13.- For the new Project ID value, create a new Activity ID
14.- Navigate to: Project Costing > Project Definitions > Team
15.- Add 2 resources to the Project ID, and its Activity ID, one as a consultant, and the other one as project manager. Commit both resources, and create its Assignments
16.- Log into the FSCM Online Applications as an Expenses User
17.- Navigate to: Employee Self-Service > Travel and Expense Center > Expense Reports > Create/Modify
18.- Define an Employee ID, and manually enter a new Expense Report transaction (Header and Line information)
19.- At the Expense Report Line level, expand the Accounting Details, and manually enter the values in ChartFields: PC Business Unit, Project ID, and Activity ID
20.- Save the Expense Report, which should be in Pending status
21.- Navigate to: Travel and Expenses > Process Expenses > Period End Accrual Processing
22.- Create a new Run Control ID with today's Accounting Date, and the Business Unit value needed, and launch the process
23.- Confirm that the Period End Accruals Expenses process (FS_PEACCRL AE Program) completes in Success at the Process Monitor level
24.- Navigate to: Travel and Expenses > Manage Accounting > View/Adjust Accounting Entries > Period End Acctg Entries
25.- Open the generated Accounting Entries for the Expense Report in question, and confirm that the DST rows have values on all PC ChartFields (PC Business Unit, Project ID, and Activity ID), while the EXB rows only have Project ID (ChartFields PC Business Unit and Activity ID are left blank)
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
This causes issues later on in General Ledger and Project Costing, because those Period End Accrual Accounting Entries are to be interfaced to those modules, and not having proper PC Business Unit and Activity ID values, while required at the Project Costing Options level for the Business Unit in question, ensures Journal Edit failing, and Expenses to Project Costing integration having issues.
The delivered Period End Accruals Expenses process (FS_PEACCRL AE Program) should be generating the Period End Accrual Accounting Entries for those Expense Report transactions that are not yet posted, and if Project Costing ChartFields are populated, not only inherit the Project ID, but also PC Business Unit and Activity ID, in both DST and EXB Accounting Lines.
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