Payables and Cash Management - EBS (MOSC)

MOSC Banner

Need exact Mapping of AP_LIABILITY_BALANCE in 11i to XLA_TRIAL_BALANCES in R12

edited Sep 8, 2014 9:09AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

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,

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