Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Get Started with Redwood for Oracle Cloud SCM Begin Now
Get Started with Redwood for Oracle Cloud SCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Pricing
Discussion List
-
"On Document" Aggregation Method for Tier PricingI am currently using tier pricing to adjust a discount list. The requirement is the ability to calculate the item price based on the TOTAL order quantity (NOT item quant… -
Restrict edit access for price lists coming through 3rd party into the Oracle SaaS systemIs it possible to restrict edit access for price lists coming through 3rd party into the Oracle SaaS system and retain edit access for price lists created manually in Or…
-
Rate plan recurring price(Charges) not being picked in the SO order lineSummary: Rate plan recurring price(Charges) not being picked in the SO order line Content (please ensure you mask any confidential information): Hi For a Subscription it…
-
Pricing Algorithm : custom lookup / webservice / PLSQL codeHi Team, We are trying to implement R12 pricing to Oracle Fusion Pricing. We could see some of customization in R12 pricing by using custom lookups and PLSQL API's for m…
-
How to fix the freight charges of sales orderWhen creating the sales order the shipping charge is calculated as a multiplication of the base price of the shipping and the item quantities. Does anyone know of a work…
-
Is it possible to Delete Pricing Data from Interface Tables using invocation from OIC?Summary: We are importing price list data from external systems using standard FBDI import program invoked from OIC. Before every import we need to clean pricing interfa…
-
How to create price inquiry form based on customerHow to create price inquiry form based on customer
-
How to get QP_LIST_PRICE Charge Component alone Using Price Sales Transaction APISummary How to get QP_LIST_PRICE Charge Component alone Using Price Sales Transaction APIContent Hi Team, Below API takes more than 5 seconds to get result. Basically i … -
Price Sales Transaction - how to use override currency conversion rate?Summary: Hi, we are using price sales transaction (PST) REST-API calls in order to show price before order submission, aka document price In the PST payload we pass the …
-
Can we update ASSESSABLE_VALUE in AutoInvoice interface line using REST API or any other methodSummary: Can we update ASSESSABLE_VALUE in AutoInvoice interface line using REST API or any other method Content (please ensure you mask any confidential information): C…
-
Price List APISummary: HI Guys, Could you please share the REST API that allows us to retrieve the price before creating the Order and Order Line? The below shared response is for exi…
-
Can we Add ShipToSiteName and its attribute for Customer Pricing Strategy assignment?Summary: We need a way to assign Pricing Strategy to Customer Ship To site. Out of Box Oracle Cloud has a few options that including, Customer and Bill To Site Name. I c…
-
How to adjust price based on sales amountSummary: For Item A the general price will be 100 But if sales order amount more than 10000 per SO in total, the price will be 90. So if we got one sales order: Line 1 I…
-
Pricing (Discount rules) Service Mapping - Populate AR Lines DFFSummary: Business requirement. There is a need to populate information from Pricing discount rule DFF to an AR Line DFF. Is it possible to accomplish this through Servic…
-
I am creating a data extraction query, but cannot fetch rule name and to link to discount list.Would appreciate help if you could provide the table name and the respective join for this.
-
Extending Pricing Algorithms to apply Shipping Charge Attribute AdjustmentsSummary: Unable to find the step 'create shipping charges' in the calculate shipping charges algorithm to do algorithm customization to extend Pricing Algorithms to appl…
-
Customer Rebate IssueSummary: Not able to create a claim. Content (please ensure you mask any confidential information): Customer Annual Volume Program is defined and executed. Loaded transa… -
OM bundled item ordering, line level discounts, and discounted drop ship purchase ordersSummary: We have a business scenario where a supplier will provide us a cost break when fulfilling orders via drop ship if we sell a combination of certain products toge…
-
Default Access Set (reference data set) to "Common" when creating a new price listSummary: We have required Data Access set default as a "COMMON" when create new Price List, we not select every time COMMON in Data Set LOV and New Price list create tim…
-
set the customer DFF where the value is a value set as a conditional column on price adjustment matrHow can I set the customer DFF where the value is a value set as a conditional column on price adjustment matrix of price list
-
Promotion as a Markup PercentageSummary: Promotions as markup percentages on the net price (List - discount). Also to do the the benefits by product category. Content (please ensure you mask any confid… -
Discount for cutomer for quantity in a quarterHi, We looking for a way to give a customer a quantity in a quarter, in different saes orders for Example if customer by more then 500 from item ABC he should get 10% di… -
How to get item Price with discounts in ExcelHello Experts, We are having one requirement to have Net prices for items after calculating discounts in report format in excel. To reduce the data in report, we can ext…
-
Query to fetch Discount lists rule name and rule typeHi Everyone, We have a requirement to fetch Discount Lists "Rule Name" and "Rule Type" columns but unable to find joining conditions for the same. Please refer the scree…
-
Price List Create CSV Ends in Debug ErrorSummary: Downloaded current copy of Price List FBDI. Input data. Click to create CSV and the process hits a debug error - Run-tie error '5'. Invalid procedure call or ar…
-
While importing Pricelist Batch, batch Name provided in the FBDI file is not available in the LOV.Summary: I am trying to import two Price list with 'Price list Batch' FBDI template, in sheet 'QP_PRICE_LISTS_INT' i have provided the same batch name for two pricelist.…
-
Limitation on attribute based discount lines.Hi Team, Need to know on the below requirement! Is there any limitations on adding no of discount lines based on attribute in a discount list? We have to add close to 9K…
-
Able to add Item in the Price list and create Charge but isn't being saved.Summary: Am able to add Item in the Price list and create Charge. Its neither being saved nor save and close is working and even no error is popping up. Please suggest a…
-
Custom "View Object Attribute" as ShipFromOrganizationCode in Service Mappings : SalesSummary: We have a requirement to create "Attribute Based Rule" having conditions columns as "ShipFromOrganizationCode" on discount list. ShipFromOrganizationCode shall …
-
Why after set up Create Promotions That Add Free Items not workSummary: I follow the instruction to create a Promotions That Add Free Items and after that I create one sales order to test this configuration and not work because the …