EEX 9.0+: Due Employee and Cash Advance Applied Total Amounts Not Recalculated after Deleting Linked Cash Advance from Expense Report (Doc ID 1581016.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

After the installation of FSCM 9.0 ESA Bundle #42, should an Employee delete an applied Cash Advance from an Expense Report transaction, the columns of 'Due Employee' and 'Cash Advance Applied' totals are not properly being recalculated, creating confusion to the users. This has been triggered to be caused by the codeline changes introduced by the fix from  <Bug 13778206> (EX: Able to Apply a Cash Advance to Expense Reports for a Greater Amount if Currency Differs).

Additionally, the Cash Advance, once deleted from the initial Expense Report, no longer gets displayed as available to get re-applied into the same or different transaction.

Finally, this issue is also taking place in PeopleSoft Enterprise FSCM 9.1 Application Release, after ESA Bundle #22 was delivered.

REPLICATION STEPS:

    - Log into the FSCM Online Application as User ID EXA1
    - Navigate to: Employee Self-Service > Travel and Expense Center > Cash Advances > Create
    - Add a new Cash Advance for Employee ID KU0021 for an amount of 500 USD, and submit it for approval
    - Log into the FSCM Online Application as User ID EXS1
    - Navigate to: Manager Self-Service > Travel and Expense Center > Approvals > Approve Transactions
    - Retrieve the submitted Cash Advance, and approve it for payment
    - Log into the FSCM Online Application as User ID VP1
    - Navigate to: Travel and Expenses > Process Expenses > Expense Processing
    - In the Run Control ID, select the following parameters before launching it:
         · Stage Payments = Y
         · Post Liabilities = Y
         · Business Unit = US001
    - Navigate to: Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
    - In an Expenses Pay Cycle created for the occasion, launch Payment Selection, Payment Creation, Approval, and Printing of Checks, so the Pay Cycle ends up in Completed status
    - Navigate to: Travel and Expenses > Process Expenses > Expense Processing
    - In the Run Control ID, select the following parameters before launching it:
         · Post Payments = Y
         · Update Paid Statuses = Y
         · Business Unit = US001
    - Log into the FSCM Online Application as User ID EXA1
    - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Reports > Create
    - Add a new Expense Report for Employee ID KU0021 for an amount of 2000 USD, and apply the full 500 USD from the previous Cash Advance
    - Save For Later the transaction, and see how the Cash Advances Applied amount is set to 500 USD, while the Due Employee total is calculated to 1500 USD
    - Go back to the 'Apply Cash Advances' link/page, and proceed to delete the line from the Cash Advance
    - Once deleted, the Total Due Employee and Total Advance Applied columns are not recalculated even if the Update Totals button is used
    - Going back to the Expense Report Entry page, the Totals are also not recalculated: Cash Advance Applied, and Due Employee columns are incorrect
    - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Reports > Create
    - Start creating a second new Expense Report on behalf of Employee ID KU0021, say again for 2000 USD
    - Click on the 'Apply Cash Advance' link, and see that when searching for the Cash Advance transaction previously applied, it no longer is available for selection

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

ACTUAL BEHAVIOR:

After the deletion of the applied Cash Advance, the Expense Report Totals (Due Employee, and Cash Advance Applied) are not properly recalculated, amounts are wrong even when submitting for approval. Eventually, if user gets out of the Expense Report Entry component, and re-opens the Expense Report, the Cash Advance is nowhere to be located when trying to apply it again.

EXPECTED BEHAVIOR:

The Due Employee and the Cash Advance Applied Totals should be automatically recalculated, and the deleted Cash Advance should be again available for selection in this or any other Expense Report.

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