Oracle Applications Blog

This article provides a summary of the options available for Direct Data Access in Fusion Cloud Applications. Let's start discussing the most common question - 'can I setup direct SQL access?' At the time of writing direct client connections to issue queries to the applications database are not possible for Oracle Cloud Applications, due to the robust security layers in place. As such tools like SQL Developer cannot be used. However, you can access most of the applications data through specific supported features and published API's. This article looks at these options. Web Services This is the recommended mechanism for getting, creating, updating and deleting small to medium volumes of records by remote systems. We've written about both the RESTful and SOAP services in this blog , plus they are documented in the Oracle API Catalog (for REST) and (for SOAP) in product-specific documentation books, such as the one for common objects . Angelo Santag...

Price List :      Price lists are essential for ordering products because each item entered on an order must  have a price. Each price list contains basic list information and one or more pricing lines, price breaks, pricing attributes, qualifiers, and secondary price lists. Modifiers:       Using modifiers, you can set up price adjustments, benefits, freight and special charges, and promotional limits to control spending or usage. You can define simple discounts and surcharges as well as more advanced deals and promotions. Modifiers can adjust net price either up or down Qualifiers:       Qualifiers are used in sync with Price Lists and Modifiers. Qualifiers can be set   According to the business needs. A qualifier consists of one or more conditions that define eligibility for a discount, promotion, or surcharge SQL QUERY SELECT qph.NAME "Modifier Name",        qpl.list_line_no "Modifier Line No...