My Oracle Support Banner

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

Last updated on JULY 08, 2020

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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