Skip to main content

Posts

Showing posts from 2015

Address Styles in Oracle Apps

How to create a new address style for Location addresses. SOLUTION To add an address style: In System Administrator > Application > Flexfield > Descriptive > Segments 1. Enter Oracle Human Resources in the application field. 2. Enter Personal Address Information or Location Address in the title field as appropriate. 3. Run the query. 4. Uncheck the Freeze Flexfield Definition check box. Note: Read the warning. 5. Choose New from the File menu. 6. Enter the country code in the code and name fields. 7. Enter a description and select the Segments button. 8. Define the segments. Note: You can only use the columns provided by Oracle HR for your segments. 9. Save your work. Note: Make sure any new segments are enabled. You can choose whether segments are displayed or not. 10. Check the Freeze Flexfield Definition check box. 11. Choose the Compile button. When compilation is complete, exit your current login session. Then log in again to see your updated s

Price breaks based on Weight?

This post describes how to use the attribute mapping method in Oracle Advanced Pricing to implement a complex contract pricing rule Recently I came across the following pricing requirement that seemed to be tricky at first glance: - Use price breaks based on a weight of an item as defined in a DFF.  An item from Inventory is assigned to a contract line and has a quantity of 1 with a UOM of Each Each item has a break price (either by item category or the item number) based on the weight. E.g., price is $1000 < 5000 tons and $1500 if weight is between 5001 and 9999 tons and $2000 if > 10000 tons. The Advanced Pricing allows you to hook up your SQL code to drive pricing. The attribute mapping feature of  Oracle Advanced Pricing  helped us to implement the above pricing rules by adding a few lines of SQL code. First, we cannot use the standard price break functionality to achieve this since standard price break uses volume or quantity as basis. We followed the steps bel