EEX 9.1+: EX_SHEET_HDR. Budget_HDR_STATUS Not In Sync With EX_SHEET_DIST.BUDGET_LINE_STATUS When EX Payment is Canceled with Stopped-Reopen/hold options (Doc ID 2250522.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

On : 9.2 version, Expense Report

ACTUAL BEHAVIOR
----------------------
Budget Status Goes Back to Not Checked When EX Payment is Canceled with Stopped-Reopen/hold options.

If the payment is cancelled/re-issued on any paid expense reports, budget header status is flipped back to N (Not Checked) by Expense Close process (EX_TRAN_PRCS), but budget line status remains Y

EXPECTED BEHAVIOR

-------------------------

EX_SHEET_HDR. Budget_HDR_STATUS should be in sync with EX_SHEET_DIST.BUDGET_LINE_STATUS

STEPS
-------------
The issue can be reproduced at will with the following steps:
1. Create, approve and pay an expense report
2. Now navigate to Accounts Payable>Payments>Cancel/Void Payments>Payment Cancellation and cancel the payment with payment status as Stopped and cancel action as reopen/put on hold and save.
3. Run cancel payment and note that EX_SHEET_HDR. Budget_HDR_STATUS is flipped to 'N' where as EX_SHEET_DIST.BUDGET_LINE_STATUS remains 'V'
4. Run budget checking again and note that the EX_SHEET_HDR. Budget_HDR_STATUS is flipped to V again - this step should not be needed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, report has to be budget checked twice to have the line status and header status to be in sync.

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.