My Oracle Support Banner

ORD INIT Transaction Has Negative "Net Sales Amt Ex VAT" And With "Net Tax" (Doc ID 2981186.1)

Last updated on OCTOBER 17, 2023

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 23.2 and later
Information in this document applies to any platform.


 When receiving an ORD INIT sales transaction, client expect only the "Liability Amt" metric to be populated. However, they are also receiving "Net Tax". As "Net Sales Amt" is correctly zero, the metric "Net Sales Amt ex VAT" is being calculated as negative: "Net Sales Amt" - "Net Tax".
This is causing issue analyzing aggregated "Net Sales Amt ex VAT", as this negative amounts are being deducted from the actual value.


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.