My Oracle Support Banner

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.

Symptoms

ISSUE:

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.

REPLICATION STEPS:

    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.

ACTUAL RESULT:

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.

EXPECTED BEHAVIOR:

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.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.