Thursday, November 12, 2015

Scrpit to add new line in APPROVED Standard PO

Step 1: insert the data interface tables as below

DECLARE
insert into po_headers_interface
(INTERFACE_HEADER_ID,
 ACTION,
 ORG_ID,
 DOCUMENT_TYPE_CODE,
 PO_HEADER_ID,
 firm_flag
)
VALUES
(po_headers_interface_s.NEXTVAL,
 'UPDATE',
 82,-- ORG ID
 'STANDAD',
 67089, -- po header Id
 );

 insert into po_lines_interface
 (INTERFACE_LINE_ID,
  INTERFACE_HEADER_ID,
  ACTION,
  LINE_NUM,
  shipment_num,
  line_type,
  ITEM_ID,
  UNIT_PRICE,
  quantity,
  need_by_date)
  values
  (po_lines_interface_s.nextval,
    po_headers_interface_s.CURRVAL,
   2, -- Line num
   2, -- Ship num
   'Goods',
   2, -- Item id
   100000, unit pirce
   1,
   to_date('02-NOV-2015','DD-MON-YYYY')
   );
  
COMMIT;
END;  

Step 2 : Ran the standard "Import Standard Purchase order" program to move the data from interface tables to base tables.

Base tables : PO_HEADERS_ALL
                     PO_LINES_ALL
                     PO_LINE_LOCATIONS_ALL
                     PO_DISTRIBUTIONS_ALL

Error Table : PO_INTERFACE_ERRORS

No comments:

Post a Comment