You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle Procurement withholding tax problem - sql

Summary

Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution level

Content

Hi, this is a sql question relating to Procurement in Oracle Fusion Financials.

On some POs I see no withholding tax at po line location level, but there is nonrecoverable_tax / recoverable_tax created by the tax rule at po distribution level.

Is there anyway I can access (using sql) the tax code that is being applied in the creation of those amounts, as otherwise I can only report the effect (rec tax / nonrec tax) but not the cause (tax code 20% standard etc)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!