Can some one tell me how to find encumbrance for a PO and Invoice OR
the driving tables for joins?
How is the amount on active encumbrance field derived for a PO? (Doc ID 219903.1)
Where Are PO Encumbrance Type And Invoice Encumbrance Type Defined In R12? (Doc ID 781856.1)
R12: Validate and Funds Check Invoice Simultaneously Causes 'Encumbrance Acctg Fail' Hold (Doc ID 1269725.1)
R12: How to troubleshoot Funds Check Hold Issues on Payables Invoices (Doc ID 1055606.1)
R10.7/11/11i: PO: Purchasing Encumbrance Accounting Concepts and Process Model (Doc ID 1089107.1)
In addition running the below diagnostic script may help not only troubleshooting encumbrance related issue, but the script provided will give you the related tables for queries.
R12: Diagnostic Script to help troubleshoot Purchasing Accounting or Encumbrance Issues (Doc ID 1483743.1)