Need exact Mapping of AP_LIABILITY_BALANCE in 11i to XLA_TRIAL_BALANCES in R12
Hello All,
We have recently upgraded our Oracle ERP from 11i to R12. We have a custom report based on a plsql procedure and the query refers to an obsolete table ap_liability_balance. I have found out from metalink that this table is obsolete in R12 and it is replaced by xla_trial_balances, but it really doesn't give any other information like how exactly it is mapped. Below is my query
SELECT alb.invoice_id invoice_id,
alb.code_combination_id code_combination_id,
SUM (alb.accounted_cr) - SUM (alb.accounted_dr) remaining_amount,
alb.vendor_id vendor_id,