EEX 9.2: Expense Report Period End Accrual Accounting Lines (EXB) Get PC BU and Activity ID ChartFields Copied Over From Expense Distribution Rows (DST) (Doc ID 2792569.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

It has been detected that the Period End Accruals process (FS_PEACCRL AE Program) generates the Expenses Period End Accruals Accounting Entries (DST_ACCT_TYPE = 'EXB') for Expense Report transactions with unexpected Project Costing related values at ChartFields BUSINESS_UNIT_PC and ACTIVITY_ID, if the original Expense Distribution Accounting Line contains Project Costing values, (ChartFields BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, etc...). This happens even when ChartField Inheritance Groups are not being used, nor set up, for the module of Expenses.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an System Administrator User
    2.- At the Expenses Definition level for the Business Unit, select the options to 'Accrue Unprocessed Expenses'
    3.- Log into the FSCM Online Application as an Expenses Employee User
    4.- Create a new Expense Report, with one Expense Line having an Amount of 100 USD, and Transaction date of December 16th 2020
    5.- At the Distribution Accounting level, split the amount between two lines, for 70 USD, and 30 USD respectively
    6.- Define Project Costing related values only on the first Distribution Accounting Line, by populating Business Unit PC, Project ID, Activity ID, Source Type, Category, Subcategory
    7.- Submit the Expense Report for approval
    8.- Log into the FSCM Online Application as an Expenses Approver User
    9.- Open the submitted Expense Report, modify the Accounting Date to equal the Transaction Date at the Expense Line level, (December 16th 2020), and approve transaction
    10.- Log into the FSCM Online Application as an Expenses Administrator User
    11.- Launch the Period End Accrual Processing program for the Expenses Business Unit, and Accounting Date of December 31st 2020
    12.- Check the created Period End Accounting Entries for the Expense Report at hand, and confirm that the 'Expenses Period End Accruals' rows (DST_ACCT_TYPE = 'EXB') generated for the Distribution Line #1 have incorrectly inherited Business Unit PC, and Activity ID values

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

There is no ChartField Inheritance Group for Expenses Period End Accruals, and defaulting values from ChartFields such as Business Unit PC, and Activity ID, leaves the Accounting Entries with incorrect ChartField Combination values, which may cause trouble in General Ledger when trying to edit the Journals. This will delay posting of transactions to the main Ledger, and subsequent reporting (monthly, quarterly, yearly, etc...).

The functionality behind the Period End Accruals process(FS_PEACCRL AE Program) should not default any Project Costing related values into the generated Expenses Period End Accruals Accounting Entries (DST_ACCT_TYPE = 'EXB').

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.