My Oracle Support Banner

LINE_GROUP_NO On IM_AP_STAGE_DETAIL Is Populating Incorrectly FOr MRCHI And NMRCHI (Doc ID 2893673.1)

Last updated on SEPTEMBER 15, 2022

Applies to:

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

Symptoms

On : 19.0.1 version, Other

You have observed that IM_AP_STAGE_DETAIL.LINE_GROUP_NO is populating incorrectly for TRAN_CODE=REASON and LINE_TYPE_LOOKUP_CODE=ITEM

 
The issue can be reproduced at will for multiple scenarios

Scenario 1
  1. Created a PO with 2 item
  2. Create the invoice with cost and qty discrepancies.
  3. Match the invoice with discrepancies write off and charge back quantity
  4. Noticed the reason code LINE_GROUP_ID is different than UNR and TAX

Scenario 2
  1. Set Prorate Across Tax Codes flag to yes.
  2. Create a non-merchandise invoice.
  3. Add two non-merchandise codes with different tax rates to the invoice.
  4. Run reimposting batch.
  5. Verify that on the IM_AP_STAGE_DETAIL table, the LINE_GROUP_NO field on the tax line does not match the one on the NMRCH line



 

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.