Receipt Write Off-Functionality Data from IM_FINANCIAL_STAGE to GL_INTERFACE Through ODI
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.
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:
- Create a PO
- Ship and Receive the PO
- Change the VDATE to meet the Receipt Write-Off functionality
- Run the Receipt Write-Off batch
- Check the data in IM_FINANCIAL_STAGE table
- Run the ReIM to EBS Account Entry Package in ODI
- 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
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