Wednesday, July 8, 2009

Regular and Customer specific pricing in iStore (using advanced pricing)

BEST PRICE

  • Set IBE: Use Price list associated with Specialty Site = NO
  • Set – Event Phases - > Search flag - > YES
  • Use Party_Id and Cust_Account_Id for Qualifying

o ASO_PRICING_INT.G_HEADER_REC.cust_acct_id

    • ASO_PRICING_INT.G_HEADER_REC.party_id
    • ASO_PRICING_INT.G_LINE_REC.cust_acct_id
    • ASO_PRICING_INT.G_LINE_REC.party_id
  • Customer specific pricing shows up in Catalog pages.
  • No caching.

LIST PRICE

  • Set IBE: Use Price list associated with Specialty Site = YES
  • Can use secondary price lists – reduces performance depending on the # of sec price lists and qualifiers
  • Item price cache used

CUSTOMER ACCOUNT PRICE

  • Set IBE: Use Customer Account Price List = YES
  • Pricelist defined in customer account – receivables is used.

Pricing APIs:

oracle.apps.ibe.catalog.StoreMinisite.getPriceListID()

oracle.apps.ibe.catalog.Item.getListAndBestPrices()

oracle.apps.ibe.catalog.PriceAdapter.sendRequest()

IBEVPRCB.pls

1 comment:

Annapurna said...

hey I want to customise this UOM code error such that it gives me the name of the first item(if there are more than one item) causing this error.
Can you tell me which package or Pl\sql code to look into.