Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Welcome to my New Home

Posted on March 29th, 2007 by Sanjit Anand ||Email This Post Email This Post

Well, I have decided to start writing and sharing online. Not for any particular purpose other than to write, so i have started my own oracle apps blog at wordpress, but because of fire wel issue, I was not able to utilize my own home as a reference point, which I have started with single mind.

So,after several weeks of thought and evaluating some hosting company I have decided to move this blog to a new home. From now on I will be using as my new home. Next couple of weeks I will try to import all post from wordpress to

Thanks again for your interest and I hope you enjoy my Blog entries.

Farewell wordpress , and hello my own domain ..oracleappshub.comicn thumbs 32x32

Posted in Blogroll | 1 Comment »

Oracle Pricing API

Posted on March 28th, 2007 by Sanjit Anand ||Email This Post Email This Post

Some time back, I had opportunity to work some conversion in oracle pricing module; Though It was pretty simple task for mine only price list and qualifier need to convert. A week back, when a friend of mine asked some information about Pricing Module, I thought to share the information, which I collected at that time. So here are the lists of Application Program Interfaces (APIs) that Oracle Pricing has. These APIs can be used in custom programs or for doing conversion or migration activity for using some of the pricing functions.

  • QP_Price_formula_PUB.Get_Price_Formula (Formula Calculation API): The Formula Calculation package consists of entities to calculate the value of a formula.
  • QP_Price_formula_PUB.Process_Price_Formula (Update Formula Prices API): The Update Formula Prices package consists of entities to update formula prices.
  • QP_CUSTOM.Get_Custom_Price (Get Custom Price API): You may add custom code to this customizable function. The pricing engine while evaluating a formula that contains a formula line (step) of type “function” calls this API.
  • QP_PREQ_GRP.Price_Request (Price Request API): The Price Request Application Program Interface (API) is a public API that allows you to get a base price and to apply price adjustments, other benefits, and charges to a transaction.
  • QP_MODIFIERS_PUB.Process_Modifiers (Business Object for Modifier Setup API): The Business Object for Modifier Setup package consists of entities to set up modifiers.
  • QP_QUALIFIER_RULES_PUB.Process_Qualifier_Rules (Qualifiers API): The Qualifiers package consists of entities to set up qualifiers.
  • QP_ATTR_MAPPING_PUB. Build_Contexts (Attribute Mapping API): The Attribute Mapping package consists of entities to map attributes.
  • QP_Price_List_PUB.Process_Price_List (Price List Setup API): The Price List Setup package consists of entities to set up price lists.

I hope this information given above will be useful in your Oracle Advanced Pricing endeavors.

Posted in Oracle Pricing | 6 Comments »

Oracle Pricing Module – A Note

Posted on March 25th, 2007 by anand ||Email This Post Email This Post

It provides an advanced, highly flexible pricing engine that executes pricing calculations for Oracle Order Management. Some of the features which Pricing allows you are:

  • Apply a surcharge
  • Discounts by percentage or amount
  • Calculate the price of order lines using list prices specified in price lists and pricing formulas.
  • Apply price modifiers/qualifiers that you define to a line.
  • Calculate freight charges and show it as a separate component in Order Management

Concepts in pricing

Price Lists
Price lists are essential to ordering products because each item entered on an order must have a price. Each price list contains basic list information like price list name, effective dates, currency, pricing controls,rounding factor,shipping defaults such as freight terms and freight carrier,and one or more pricing lines, pricing attributes.

Pricing Formulas
Formulas are mathematical expressions that the pricing engine uses to determine the list prices of items and the discounts that apply to those items.

Price List Qualifiers/Modifiers

Price List Qualifiers/Modifiers Modifiers enable you to setup price adjustments (for example, discounts and surcharges) and freight and special charges (modifier lists) that the pricing engine applies immediately to pricing requests.Using modifiers you can:

  • Setup a modifier list with multiple modifier lines
  • Create eligibility rules for modifiers by assigning list and line level qualifiers
  • Qualifiers help the pricing engine to determine who is eligible for the modifier.

Pricing Attributes

Pricing attributes are characteristics of products and services that specify when the characteristics help to determine the price of a product or service. Distance, age of a related product, customer class, product family group, and level of service are examples of pricing attributes. You can specify one or a combination of pricing attributes and assign them to a product. At order entry time, the pricing engine evaluates the attributes you have specified during formula setup to calculate the price.

Steps for pricing an order

  • Create a price list (one time)
  • This includes creation of price list headers and lines(which associates items to a particular price)
  • Create pricing formulas (optional)
  • Create price list modifiers/qualifiers (optional)
  • Create an order.
  • Attach the price list to that order.

Posted in Oracle Pricing | 11 Comments »

EDI and there prevalent EDI standards

Posted on March 11th, 2007 by Sanjit Anand ||Email This Post Email This Post

Electronic Data Interchange (EDI) is the electronic exchange of routine business transactions. These transactions include documents such as purchase orders, invoices, inquiries, payments acknowledgements etc.

EDI is the cross-industry electronic business interchange standard that enables individuals, companies and organizations to participate in global e-commerce.

EDI enables a commonly understood and standardized format of the relevant data to be transmitted from one computer system to another with minimal human intervention.


EDI extracts information from a business process (e.g. purchase order, invoice etc). The data is usually transmitted over a Value Added Network (VAN – which acts as a electronic post offices) and delivered to a trading partner. Once the trading partner receives the information, the EDI systems will automatically translate the standardized EDI data into application data and moved to the appropriate business application.

dgreybarrow EDI Standards

  • United States
    • X12
    • EDIFACT (Multi- Industry)
  • UK
    • TRADACOMS (Retail)
    • ODETTE (Automotive)
    • EDIFACT (Multi- Industry)
  • Germany
    • VDA (Automotive)
    • ODETTE (Automotive)
    • EDIFACT (Multi-industry)
  • France
    • ODETTE (Automotive)
    • GENCODE (Retail)
    • EDIFACT (Multi- Industry)
  • Brazil
    • RND (Automotive)
    • NTC (Transportation)
    • CNAB (Banking)
    • X12 (Multi-industry)
    • EDIFACT (Multi- Industry)
  • Mexico
    • X12
    • EDIFACT (Multi- Industry)
  • Japan
    • CII (Multi-industry)
    • EDIFACT (Multi- Industry)
  • Australia
    • X12 (Multi-industry)
    • EDIFACT (Multi- Industry)

Posted in EDI | No Comments »