Unable To Extract Tax Amount In Each Invoice Line With OTBI (Doc ID 2610452.1)

Last updated on DECEMBER 02, 2022

Applies to:

Goal

To extract a tax amount in each invoice line, I create a report using "Payables invoice - Transactions Real Time" subject area and Total Tax Charged. However, the tax amount is shown as below:

Invoice Distribution Amount Total Tax Charged Invoice Line Type
60,000 8,000 Item
40,000 8,000 Item

Would it be possible to get a tax amount in each invice line with OTBI? If yes, please let me know which subject area and account I can use.

Invoice Distribution Amount Total Tax Charged Invoice Line Type
60,000 4,800 Item
40,000 3,200 Item
*Tax Rate is 8%
 

Solution

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