My Oracle Support Banner

Financial Posting Batch has Failed with Errors and Getting Closed Connection Issue In RFI (Doc ID 2708340.1)

Last updated on OCTOBER 04, 2023

Applies to:

Oracle Retail Invoice Matching - Version 16.0.2 and later
Oracle Retail Financial Integration - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

When running Financial  Posting Batch in Retail Invoice Matching (ReIM), Batch getting failed and getting closed connection issue in Retail Financial Integration (RFI).


Steps To Recreate :

  1. All the transactions are accurately mapped to their accounts.
  2. IM_SYSTEM_OPTIONS.GL_MAX_SEGMENT = 20 and IM_SYSTEM_OPTIONS. WS_FIN_ACC_VALID_URL = NULL.
  3. Only use the first 9 segments in account mapping and SYSTEM_OPTIONS.FINANCIAL_AP = 'A'.
  4. Ran the Diagnostic script to verify the account set up and its all accurate .
  5. TAP and PPA account is set up accurately as non dynamic.
  6. UNR, TAX, REASON transactions are mapped as dynamic with corresponding mapping defined in IM_DYNAMIC_SEGMENT_LOC/ DEPT_CLASS.
  7. Create an Invoice along with Receipts with Perfect Match.
  8. Run Automatch Batch then Invoice & Receipt matched successfully.
  9. Run Financial Posting Batch observed that batch got aborted with the errors.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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