My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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.


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


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

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