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:

Symptoms

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.

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


STEPS
-----------------------
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

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

Changes

Cause

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