E-Business Tax (MOSC)

MOSC Banner

How to identify all suppliers with associated Fiscal Classification?

edited Jan 7, 2010 2:40AM in E-Business Tax (MOSC) 1 commentAnswered
 Hallo,

we have POs where the Tax Rate is 19%, while Supplier has Fiscal Classification with Tax Rate of 0. For those cases, invoices with "wrong" Tax Amount were created, because AP Invoice was created with 19% based on PO Tax (and not on Supplier Tax of 0%).

We know the root cause of those transactions: Supplier Fiscal Classification had been associated to Supplier after PO had been created.

Now we want to identify all affected POs via SQL-query. We found ZX_LINES for PO-Tax information very fast, but we have no idea where to find information about Fiscal Classification associated to Supplier. We looked through all Notes/Bugs/Whitepapers already and found numerous references to ZX_PARTY_TAX_PROFILE, but here no reference to Fiscal Classifications (ZX_DETERMINING_FACTORS) is available. No help with Diagnostic files, either.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center