Order and Service Management (Communications Industry) (MOSC)

MOSC Banner

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,

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