Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Dataloader for price update 2 .mnt file is not updating in database?

edited Dec 22, 2017 5:22PM in Retail Point-of-Service Solutions (MOSC) 9 commentsAnswered

Dear All ,

We had an MNT file to update the promo price , runs by dataloader & its success. But no changes is happening at DB level when check itm_item_prices table . Showing the old price and no update / insert happens.

Please find the sample price update 2 mnt file which i m trying to update .:-

UPDATE|PRICE_UPDATE_2|4057826698580|PROMO_PRICE|*|*|777|2017-10-18 12.00.00.000000000 AM|2017-10-18|1||

dataloaderconfig.xml propertile file for price_update_2.:-

  <RecordType name="PRICE_UPDATE_2">

    <Dao name="ItemPrices">

      <Field configParam="getOrganizationId" name="OrganizationId" />

      <Field filePosition="03" name="ItemId" />

      <Field filePosition="04" name="ItemPricePropertyCode" />

      <Field filePosition="05" name="LevelCode" />

      <Field filePosition="06" name="LevelValue" />

      <Field filePosition="07" name="Price" />

Tagged:

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