EEX 9.1+: Highlighted Fields Are Required (15,30) Error Message At Reconcile Cash Advance Page (EX_ADV_RECON) (Doc ID 1960512.1)

Last updated on JANUARY 28, 2025

Applies to:

Symptoms

ISSUE:

Users are unable to manually reconcile a Cash Advance in the Reconcile Cash Advance page (EX_ADV_RECON), if the transaction's Amount has been fully applied into one or several Expense Reports, and the Due Company column stores a 0 value. The system is asking for required values in the highlighted fields of Check Number (PS_EX_ADV_CHK.CHECK_NBR), and Check Amount (PS_EX_ADV_CHK.AMOUNT) when the User clicks on the Reconcile Button. It seems that the system is expecting for such Fields to be manually populated, even in those cases where it is not needed, because all the Cash Advance amount has been used up.

This is a similar scenario, thought not 100% the same, as the one reported in Bug 14673788 (EX: Cash Advance Reconciliation Page Grays Outs Save For Later And Reconcile Buttons). In that case, the user did not apply all the Cash Advance amount, so Employee Payment information was expected to be filled in. In this case though, that should not be required.

REPLICATION STEPS:

   - Create a new Cash Advance transaction for 1,000 USD
   - Submit the Cash Advance for Approval
   - Approve the Cash Advance transaction
   - Stage For Payment this Cash Advance transaction
   - Post the Liabilities for this Cash Advance transaction
   - Create a new Pay Cycle for this Cash Advance, and run Pay Cycle Selection and Creation, until Pay Cycle is Completed
   - Run the Update Paid Statuses process
   - Run the Post Payments process
   - Create a new Expense Report transaction for 1,000 USD, and fully apply the previously created Cash Advance
   - Submit the Expense Report for Approval
   - Approve the Expense Report transaction
   - Post the Liabilities for this Cash Advance transaction
   - Navigate to: Travel and Expenses > Manage Accounting > Reconcile Cash Advance
   - Open the Cash Advance transaction
   - Confirm that the Cash Advance is Paid, Posted, and that the Due Company column is 0,00 USD
   - Click on the Reconcile button
   - The system triggers an Error Message

ERROR MESSAGE:

   " Highlighted fields are required. (15,30)
     Enter data into the highlighted fields. "

BUSINESS IMPACT:

The Cash Advance Reconciliation page can no longer be used, no changes can be saved, nor the transaction can be manually reconciled. The system is asking for field values that are absolutely not necessary if the entire amount of the Cash Advance has been used up.

EXPECTED BEHAVIOR:

For those Cash Advances where the full amount has been applied against Expense Report transactions, the reconciliation should be done via the Expense Processing Application Engine Program (EX_TRAN_PRCS) on an automatic/batch process basis. Only those Cash Advances that remain unused, or have partial amounts that will no longer applied against any new Expense Report, need to be reconciled manually. A fix is requested so that Cash Advance Reconciliation page filters out all those transactions whose amount has been fully applied. 

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.