Bulk Load of Price List Update not working.
Hello Experts,
I am trying to update the list proce using bulk price load, but not happening. I am using below insert:
INSERT INTO QP_INTERFACE_LIST_HEADERS(
ORIG_SYS_HEADER_REF,
LIST_TYPE_CODE,
NAME,
DESCRIPTION,
CURRENCY_CODE,
ACTIVE_FLAG,
--CURRENCY_HEADER,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
ROUNDING_FACTOR,
SOURCE_LANG,
LANGUAGE,
INTERFACE_ACTION_CODE,
PROCESS_FLAG,
PROCESS_STATUS_FLAG
) VALUES
(
'PG02', /* ORIG_SYS_HEADER_REF */
'PRL', /* List Type Code */
'MA Price List', /* Price List Name */
'MA Master Price List', /* Description */
'AUD', /* Currency Code */
'Y', /* Active Flag */
--'Corporate Pricelist Conversion list', /* Multi currency conversion list name */
sysdate, /* Start Date Active */
0