How to control Invoice Date on AP Invoice based on Reference_key

Summary:

How to control Invoice Date based on Reference_key

Content (please ensure you mask any confidential information):

We are seeing AP Invoice Interface populated with Invoice Date as NULL. However, the actual date which must be used is available in AP_INVOICES_INTERFACE.reference_key2.

Requirement - How to use this reference_key2 to be the Invoice Date while Importing AP Invoice in Payables.

Issue - As the Invoice_Date is NULL, be default all the invoices are getting created with SYSDATE. We would like to use reference_key2 to be used as the Invoice Date

select invoice_num, source, invoice_date,gl_date, reference_key2