EEX 9.1+: Record Field PS_EX_SHEET_LINE.EX_LINE_STATUS Stores Incorrect Value DNC After All Approvals Have Been Completed (Doc ID 1580910.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

Issue:

It has been detected that for certain Expense Report Lines, which have been denied by any approval level (Reviewer, HR Supervisor, Expense Manager, Pre Pay Auditor, or Project Manager), and confirmed again as Denied by the subsequent approver level, the value stored in Record Field PS_EX_SHEET_LINE.EX_LINE_STATUS is set to 'DNC', even after all approval levels have been completed, and the transaction has been set to 'Approved For Payment' ready for further processing. Those Expense Lines denied, and confirmed and left as denied by the rest of approvers are not being set to a status of 'DEN', which should be the expected one. The value of 'DNC' is not a delivered Translation Status for Field EX_LINE_STATUS, and as such, the transaction data is left as corrupted, and confuses the users as it is unknown what this value represents.

Replication Steps:

    - Log into the FSCM Online Application as User ID VP1
    - Navigate to: Set Up Financials/Supply Chain> Product Related > Expenses > Management > Transaction Definition
    - Open the existing row for Expense Reports, and make sure to activate: Reviewer, Pre Pay Auditor, and Project Manager
    - Navigate to: Set Up Financials/Supply Chain> Product Related > Expenses > Management > Approver Assignments
    - For Business Unit US001, and Approver Profile REVIEWER, list User IDs EXS1 and EXS2 as the assigned approvers
    - Navigate to: Set Up Financials/Supply Chain> Product Related > Expenses > Management > Approver Assignments
    - For Business Unit US001, and Approver Profile PREPAYAUD, list User IDs EXS3, and EXS4 as the assigned Pre Pay Auditor approvers
    - Navigate to: Project Costing > Project Definitions > General Information
    - Add a new Project ID, GCS_EX_PROJ, under Business Unit US001
    - Navigate to: Project Costing > Activity Definitions > Project Activities
    - Create a new Project Activity from the new Project ID GCS_EX_PROJ
    - Navigate to: Project Costing > Project Definitions > Team
    - Add Employees KU0021 and KU0006 as Resources to the Project Activity, marking KU0006 as Project Manager
    - Log into the FSCM Online Application as User EXA1
    - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create
    - Select Employee ID KU0021, and add a new Expense Report
    - Define the PC Business Unit, Project ID, and Activity ChartField values in the Accounting Defaults from the Expense Report
    - Add 4 new Expense Report Lines, and submit the transaction for approval
    - Log into the FSCM Online Application as User EXS1 (Reviewer)
    - Navigate to: Manager Self-Service > Travel and Expense Center > Approvals > Approve Transactions
    - Retrieve the submitted Expense Report, select all 4 ER Lines with the 'Approve' flag, and click on the REVIEW button
    - Log into the FSCM Online Application as User EXS3 (Pre Pay Auditor)
    - Navigate to: Manager Self-Service > Travel and Expense Center > Approvals > Approve Transactions
    - Retrieve the submitted Expense Report, un-select the 'Approve' flag from Expense Lines #2, #3, and #4, and define them as 'Out Of Policy', and proceed to approve the remaining of the transaction
    - Query Record Field PS_EX_SHEET_LINE.EX_LINE_STATUS for the Expense Report in question, and see that Line #1 has a value of PAR, while Lines #2, #3, and #4 have stored a value of DEN
    - Log into the FSCM Online Application as User MGR1 (Project Manager)
    - Navigate to: Manager Self-Service > Travel and Expense Center > Approvals > Approve Transactions
    - Retrieve the submitted Expense Report, again un-select the 'Approve' flag from Expense Lines #2, #3, and #4, and define them as 'Out Of Policy', and proceed to approve the remaining of the transaction
    - Query Record Field PS_EX_SHEET_LINE.EX_LINE_STATUS for the Expense Report.

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 Result:

For all the affected Expense Report Lines, the Record Field PS_EX_SHEET_LINE.EX_LINE_STATUS is left storing the value of 'DNC', which is not a delivered Translation value for Field EX_LINE_STATUS. This is confusing users who perform queries on their Expense Reports and find missing Expense Lines, or do not understand the value stored.

Expected Result:

The value of 'DNC' should be included as a Translation value for Field EX_LINE_STATUS, and once all approval levels required have been acted upon, and the Expense Report is set to 'Approved For Payment' status, those Expense Report Lines whose status are 'DNC' should be rest to 'DEN'.

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