Introduction
Oracle Fusion Supply Chain Management (SCM) provides powerful Order Management (OM) capabilities, yet businesses often need to implement customized price adjustments beyond standard configurations. While Oracle Fusion OM Extensions allow for business logic customizations, they have read-only access to manual price adjustments, making direct modifications impossible.
To address this limitation, we implemented a hybrid solution using OM Extensions and Oracle Integration Cloud (OIC) to dynamically apply price adjustments. This post will walk through the solution architecture and the technical steps required to automate order pricing adjustments efficiently.
1. Understanding Order Price Adjustments in Fusion SCM
Dynamic pricing adjustments are necessary for businesses that require:
• Customer-based Discounts – Special pricing based on customer tier.
• Volume-based Discounts – Adjustments for bulk purchases.
• Contractual & Industry-specific Pricing – Applying unique pricing rules.
• Geographic-based Adjustments – Price changes based on shipping locations.
While Fusion SCM includes a pricing engine, it lacks flexibility in handling complex conditions dynamically. OM Extensions alone cannot modify manual price adjustments at the time of order submission, requiring an external solution to apply them post-save.
2. Implementing OM Extensions & OIC for Price Adjustments
Since OM Extensions only provide read-only access to manual price adjustments, we implemented a three-step solution using Oracle Integration Cloud (OIC) to apply adjustments asynchronously.
Solution Components
1️⃣ OM Extension Identifies Adjustment Requirements
2️⃣ OM Extension Triggers an OIC Integration
3️⃣ OIC Applies the Adjustments via API After the Order is Saved
Let’s break down the implementation.
3. Step-by-Step Technical Implementation
Step 1: Identify Manual Price Adjustments Using OM Extension
• Since OM Extensions cannot modify manual price adjustments, we leveraged Order-Level EFF (Extended Flexfields) to store adjustment data.
• On order save, the extension detects if a manual adjustment should be applied and stores the reason code and adjustment value in an EFF field at the order level.
• This acts as a temporary marker, allowing OIC to retrieve the required adjustment details asynchronously.
Step 2: Invoke OIC SOAP Web Service for Order Adjustment
• If any line-level EFF fields were updated during order save, the OM Extension triggers an OIC SOAP Web Service.
• The SOAP service calls an external API that adds the manual adjustment to the order.
• However, since Fusion SCM enforces strict locking mechanisms, adjustments cannot be applied immediately—requiring an asynchronous approach.
• Example of OIC SOAP call from OM Extension
Step 3: Asynchronous Adjustment Application in OIC
• To avoid locking conflicts, the OM Extension submits an asynchronous SOAP OIC Integration.
• In order to make the OIC integration async – the manually created WSDL should not contain the output message:
• This integration continuously monitors a custom EFF field at the header level until it detects a “Pending” status.
• Once the order is fully saved and unlocked, the OIC integration:
• Applies the manual adjustment using the API.
• Updates the header-level EFF status field from “Pending” to “Complete”.
This ensures that price adjustments are applied only after the order has been fully saved and unlocked, preventing transaction conflicts.
4. Solution Benefits
✅ Overcomes OM Extension Limitations – Since OM Extensions cannot modify manual adjustments, this solution provides a structured workaround.
✅ Ensures Data Integrity – Adjustments are applied only after the order is saved, preventing conflicts.
✅ Eliminates Locking Issues – The asynchronous OIC integration ensures that adjustments are made only when Fusion SCM allows them.
✅ Fully Automated Process – No manual intervention is required, making pricing adjustments seamless and efficient.
5. Conclusion
By integrating OM Extensions with Oracle Integration Cloud, we successfully implemented a workaround for Fusion SCM’s pricing limitations. This approach enables businesses to apply dynamic price adjustments without modifying standard order processing logic.
If your organization needs custom pricing automation in Oracle Fusion SCM, CID Solutions can help you design and implement tailored solutions. Contact us today!