My Oracle Support Banner

PROD:REIM: IM_AP_STAGE_DETAIL_HIST:LINE_GROUP_NO Is Different For Tax And Item Line For The Same Inv (Doc ID 2983768.1)

Last updated on OCTOBER 30, 2023

Applies to:

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


On : 19.3 version, Posting

When attempting to Post the invoice which is having total 3 Tax rate codes GB EXEMPT,GB STANDARD,GB_ZERO as per the understanding of the customer each tax rate code should have one line group number for each but all these GB STANDARD,GB_ZERO tax rate codes are merged with single Line Group Number ,
the following error occurs.

LINE_GROUP_NO is different for Tax and Item Line for the same Invoice

The issue can be reproduced at will with the following steps:
1. Create a Purchase Order (PO) with an item. 
2. Create the receipt with same item.
3. Create the invoice with the same item but with different quantity or cost.
  Invoice has cost discrepancy
4. Run the Automatch batch, the invoice goes to unresolved match status and resolve the discrepancy.
  resolved discrepancy with CBC
5. Run Rollup and Financial Posting Batch to Post the Invoice.
  invoice and DMC are posted

The issue has the following business impact:
Due to this issue, users cannot post the invoice to finance application




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.