Oracle eBS經驗分享

In Oracle e-Commerce Gateway, the 810 Invoice Outbound program (ECEINO)

----------------------------------------------------------------------------------------------------

Run the following update, this will re-set the transaction to be exported when you run the 810 or 812 Outbound

update ra_customer_trx_all
set printing_pending = 'Y',
printing_count = NULL,
printing_last_printed = NULL,
printing_original_date = NULL,
EDI_processed_flag = 'N',
EDI_processed_status = NULL
where customer_trx_id = &enterCustomer_trx_id;

commit;