FCUBS - XP - Expense Contract ESN Update is Incorrect (Doc ID 3071526.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
FCUBS - XP - Expense Contract ESN Update is incorrect

User reported an issue that ESN Number was not updated rightly in Expense Contract Table.
Especially when we do Payment to Expense Contract, Payment Event Sequence Number is updated in CSTB_CONTRACT & CSTB_CONTRACT_EVENT_LOG but not updated in XPTB_CONTRACT_MASTER Table

Due to this issue, all Expense Reports are having issues as Logic to get Expense Contract Details is below across all Modules.

Select * from Xptb_Contract_Master where Event_Seq_No = (Select Max(Latest_Event_Seq_No) from CSTB_CONTRACT)

 

EXPECTED BEHAVIOR
-----------------------
Event sequence number to be updated properly in Expense Contract Table


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Consider an Expense Contract
2. Perform a Payment to Expense Contract
3. ESN is updated properly in CSTB_CONTRACT MASTER
4. But not in Xptb_Contract_Master


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, all Expense Reports are having issues

Cause

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