EEX 9.2: Record Field EX_SHEET_PYMNT.ACCOUNTING_DT Is Populating As NULL, When Running Expense Transaction Process (EX_TRANS_PRCS) With "Cancel Payment" Option Enabled (Doc ID 2942899.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

Record Field EX_SHEET_PYMNT.ACCOUNTING_DT populated as NULL by Expense Transaction Process (EX_TRANS_PRCS) with Cancel Payment option enabled

Setup:
1. Setup Financials/Supply Chain > Business Unit Related > Expenses  > Expenses Options , Open it for the Set ID. Note Down the Bank Information.
2. Go to Banking > Bank Accounts > External Accounts , Open an Same Account mentioned in the Expenses Option setup.
3. Go to Payment Method tab , Search for the Payment Method "EFT" and Set the Settle By as "Financial Gateway" and check "Default" check box for the same row. Save the Page.
4. Go to Travel and Expenses > Manage Employee Information > Update Employee Detail , Open any Employee and make sure the employee has default payment method as EFT and a default Bank Account.

Steps:
1. Go to Employee Self Service > Expenses tile > Create Expense Report tile
2. Create the Expense Report for the Same Employee as per the Setup above.
3. Submit the Expense Report.
4. Get the Expense Report Approved by Approvers.
5. Go to Travel and Expenses > Process Expenses > Expense Processing and Run the process with options "Stage Payment" and "Post Liabilities".
                -- This will stage the data of Expense Report to Paycycle processing.
6. Pay the Expense Report using Paycycle and Run AP_FG_PROC process from Paycycle Results.
               -- This will send the data to Financial Gateway for dispatching the Payment.
7. Go to Financial Gateway > Process Payments > Payment Dispatch, Search and select the Payment done in Step 6. Click on Dispatch Settlment.
8. Go to Travel and Expenses > Process Expenses > Expense Processing and Run the process with options "Post Payment"
               -- This will create Payment Accouting Entries for Expenses and mark the Expense Report as Paid.
9. Go to Accounts Payable > Payments > Cancel/Void Payments > Payment Cancellation > Cancel Payment , Search and open the Payment completed in Step 6.
10.  Select Payment Status as "Void" and Cancel Action as "Re-Open Voucher(s)/Re-Issue" and Save the Page.
11. Go to Travel and Expenses > Process Expenses > Expense Processing and Run the process with options "Cancel Payment" process.
               -- This mark the Expense Report as Staged and create new schdule EX_SHEET_PYMNT to process the cancelled payment again.
12. Check the Value in EX_SHEET_PYMNT.ACCOUNTING_DT in Databse.

• EX_SHEET_PYMNT.ACCOUNTING_DT is populated as NULL that is causing the PYCYCL_DATA.PAY_DOC_DT and PMT_INVOICE_TBL.INVOICE_DT as NULL when running Paycycle again to process the payment.

Cause

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