Total Pageviews

Showing posts with label EBS : Interface : AR. Show all posts
Showing posts with label EBS : Interface : AR. Show all posts

Tuesday, 11 July 2023

EBS : AR Interface Scripts in Oracle Apps (R12)

 AR Interface Scripts  in Oracle Apps (R12)



Some Important AR Interface Tables are :-

  • ra_interface_lines_all
  • ra_interface_distributions_all
  • ra_interface_errors_all

Standard Import Program Name :- Autoinvoice Import Program

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...