EEX 9.1+: Advance Reconciliation Count Not Filtering Displayed Value By Selected Business Units At Expense Processing Run Control ID Page (Doc ID 1999482.1)

Last updated on MARCH 25, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses Argentina - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

In the Expense Processes Application Engine Program Run Control ID page (RUN_EXTRNPRC) there are many counters. One of them, the Advance Reconciliation, is not properly filtering the number of transactions by the Business Unit values defined in the 'Selected Business Unit' page (RUN_EXTRNPRC_BU) of the Run Control ID.

Although there is nothing wrong in the EX_TRAN_PRCS process itself, as upon processing, it will only pick up those transactions from the defined Business Units, the displayed value in this counter upon creating the Run Control ID, even after pressing the Refresh button, is displaying the number not filtering the results by the selected Business Units.

The counters in this Expense Processes Run Control ID page are being calculated by delivered codeline stored in RUN_EXTRNPRC.GBL.PostBuild (Component PeopleCode).

More importantly, should the system be configured so there is Business Unit Row Level Security, Expenses Users should only be displayed information related to those Business Units they have access to. As of now, even with Row Level Security put in place, the Advance Reconciliation counter is still displaying the number of transactions in the whole system.

REPLICATION STEPS:

   - Have an Employee whose Expenses Profile is linked to GL Business Unit US001
   - Create a new Cash Advance on behalf of that Employee for an amount of 1000 USD, and submit it for approval
   - Process the Cash Advance transaction through all required approvals, until it is in 'Approved For Payment' status
   - Run the Stage Payments process, so that the Cash Advance gets a status of 'Staged'
   - Run the Post Liabilities process against the Cash Advance in order to have its EXACCRUAL Accounting Entries generated
   - Run the Pay Cycle Selection and Creation, until completion, so a payment is created for the affected Cash Advance
   - Run the Update Paid Statuses process at the Expense Processing Run Control ID
   - Launch the Post Payments process, so that the Cash Advance gets its EXPAYMENT Accounting Entries generated
   - Create a new Expense Report on behalf of the same Employee, for an amount also of 1000 USD, and apply the whole amount of the prior Cash Advance
   - Once that is done, submit the Expense Report for approvals
   - Process the Expense Report transaction through all required approvals, until it is in 'Paid' status (Note that the amount due to the Employee is 0)
   - Run the Post Liabilities process against the Expense Report in order to have its EXACCRUAL Accounting Entries generated
   - Navigate to: Travel and Expenses > Process Expenses > Expense Processing
   - Create a brand new Run Control ID with the following settings:
        - Advance Reconciliation = Y
        - All Business Units = N
        - Business Unit = US003
   - Save the changes, and then refresh the Run Control ID
   - See that the Advance Reconciliation count is displaying a value of 1, though the selected Business Unit is US003, and the affected Cash Advance transaction is for Business Unit US001

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.

BUSINESS IMPACT:

This causes confusion to the Expenses Users, as they launch the Expense Processing Application Engine Program (EX_TRAN_PRCS) with the Advance Reconciliation option selected for those Business Units they have been granted access to, and are responsible for, and upon completion, the counter remains still showing a value of 1.

EXPECTED BEHAVIOR:

Extra functions and validation should be added into the codeline so that the Advance Reconciliation counter is displaying the proper value given the defined/selected Business Units in the Run Control ID.
 

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