1 person found this helpful
Just upload old rdf as it is and check. if it gave data then just add one column in that and check. if it gave correct data then the problem with that tables may be.
Otherwise do one thing.
Just try with formula column.
Give like this...
function CF_GL_DATEFormula return Char is
select bb.gl_date into v_gl_date
from ap_invoices_all bb
, ap_supplier_sites_all cc
, AP_SUPPLIERS dd
where :invoice_number = bb.invoice_num
and bb.vendor_site_id = cc.vendor_site_id
and bb.vendor_id = dd.vendor_id
and :supplier_site_code = cc.vendor_site_code
and :supplier_name = dd.vendor_name;
when others then
Hope this will help you...