EEX 9.2: Cancel Travel Authorizations Process (EX_BCHK_AUTH AE Program) Abends at Step FS_BP_PROC.Delete.uHdrStat Wrongly Updating PS_EX_TAUTH_HDR.BUDGET_HDR_STATUS = I on All Transactions (Doc ID 2973400.1)

Last updated on JULY 21, 2024

Applies to:

Symptoms

Having enabled the Commitment Control functionality, an Employee has created a Run Control ID for the Cancel Travel Authorizations functionality, selecting 6 approved and successfully budget checked Travel Authorizations.

After launching the Cancel Travel Authorization process (EX_BCHK_AUTH AE Program), the system has abended at Step FS_BP_PROC.Delete.uHdrStat. The abend has corrupted all existing Travel Authorizations, with a Header Budget Status of 'Document in Process' (PS_EX_TAUTH_HDR.BUDGET_HDR_STATUS = I).

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an Expenses User
    2.- Create 5 different Travel Authorization transactions, and submit them for approval
    3.- Log into the FSCM Online Application as an Approver User
    4.- Proceed to budget check, and approve, all 5 Travel Authorizations
    5.- Log into the FSCM Online Application as an Administrator User
    6.- Navigate to: Travel and Expenses > Process Expenses > Cancel Travel Authorizations
    7.- Create a new Run Control ID naming it ABC, defining the needed criteria:
         - Business Unit = US003
         - Select Option = All
    8.- Click on SEARCH button
    9.- Confirm that the system displays the 5 Travel Authorizations previously created
    10.- Select one of them, and save the Run Control ID ABC
    11.- Create a second Run Control ID, naming it XYZ, and define the below same criteria:
         - Business Unit = US003
         - Select Option = All
    12.- Click on SEARCH button, select the exact same Travel Authorization previously selected on Run Control ID ABC, and click on RUN button
    13.- Confirm that the EX_BCHK_ATUH AE Program completes successfully
    14.- Navigate to: Travel and Expenses > Process Expenses > Cancel Travel Authorizations
    15.- Open previously created run Control ID ABC, and confirm the already canceled Travel Authorization is still selected
    16.- Without making any changes, click on RUN button
    17.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
    18.- PROBLEM: Find the EX_BCHK_AUTH Process Instance, and confirm it is in No Success
    19.- PROBLEM: Query Record Field PS_EX_TAUTH_HDR.BUDGET_HDR_STATUS on all existing transactions, and confirm it has been wrongly updated to a value of 'I' (Document in Process)

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.

ERROR MESSAGE:

This problem corrupted all existing Travel Authorizations existing in the Database, and updated them as 'Document In Process'. This will affect subsequent runs of Budget Checking Process, and the available Budget on the current open Accounting Period.

When canceling an approved and valid budget checked Travel Authorization transaction, the Budget Check Request run should only consider as eligible transactions those selected for online cancelation, none others.

Cause

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