Issue with Tax Line Handling in FBDI Invoice Import for India GST

We are implementing a new process to import invoices electronically using a middleware solution. As part of this, invoices are being imported via the FBDI template. The import includes header, line, and tax information.

This process is specific to India GST.

Currently, the tax lines in the FBDI file contain a consolidated tax amount, which includes both CGST and SGST. However, when the invoice is created in Oracle, the system is:

• Creating a separate SGST line correctly.
• But duplicating the CGST amount from the imported tax line, resulting in CGST being overstated.

Example:

• Invoice Total: ₹123,000
• Tax Total: ₹18,900
• Expected: CGST ₹9,450 + SGST ₹9,450