Receipt Write Off-Functionality Data from IM_FINANCIAL_STAGE to GL_INTERFACE Through ODI (Doc ID 2087533.1)

Last updated on APRIL 15, 2017

Applies to:

Oracle Retail Invoice Matching - Version 13.2.5 to 13.2.9 [Release 13.2]
Oracle Retail Invoice Matching - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms

Retail Invoice Matching (ReIM) 13.2.5 / Retail Invoice Matching (ReIM) 14.0.1

Receipt write off functionality is performed in Retail Invoice Matching (ReIM) and data is populated in IM_FINANCIAL_STAGE.
When the REIM_TO_EBS_ACCOUNT_ENTRY package is executed in ODI, the interface is executed successfully, but there are no inserts into GL_INTERFACE (target).


Steps to Reproduce:

  1. Create a PO
  2. Ship and Receive the PO
  3. Change the VDATE to meet the Receipt Write-Off functionality
  4. Run the Receipt Write-Off batch
  5. Check the data in IM_FINANCIAL_STAGE table
  6. Run the ReIM to EBS Account Entry Package in ODI
  7. Check the GL_INTERFACE table

Expected Result:  For receipt write off batch, the doc_date populated should be the vdate.  For pre-paid invoice which is matched, it should be the match date.
Actual result:  Note that the account date populated is the same as invoice_date

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms