Insert or Update "effective_date" and "expiration_date" into po_headers table
Hi All
Am doing an insert from an excel sheet into the po_headers_interface table via a concurrent job that runs a PL-SQL package. This in turn populates the po_headers table.
2 fields that are being ignored though are "effective_date" and "expiration_date"
SQL shown below is pretty standard for doing this.
INSERT INTO po_headers_interface
(interface_header_id, process_code, action, org_id,
document_type_code, document_subtype, document_num,
po_header_id, currency_code, rate_type,
rate_date, rate, agent_id,
vendor_id, vendor_site_id, ship_to_location_id,
bill_to_location_id, terms_id, freight_carrier, fob,