Advanced Pricing - EBS (MOSC)

MOSC Banner

Bulk Load of Price List Update not working.

edited Nov 1, 2013 2:50AM in Advanced Pricing - EBS (MOSC) 1 commentAnswered
 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 */

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