Import Null Values Using REST or SOAP Services

Enhance data integration by importing null values using REST or SOAP services in Oracle E-Business Suite Release 12.2.13. Previously, importing data via web services did not fully support null values, often requiring workarounds or leading to incomplete data updates when fields required clearing and resetting. This feature enables the explicit import of null values through REST and SOAP services, allowing accurate data representation by clearing existing values in fields where no data is provided and ensuring precise updates to order information.

This functionality delivers significant business value by improving data integrity during integration, reducing manual data correction efforts, and supporting accurate order updates through automated systems. It addresses needs in industries with heavy reliance on system integrations, such as e-commerce and supply chain management, where clearing outdated or irrelevant data is critical for order accuracy. Use cases include resetting obsolete order fields during bulk updates via web services. Implementation considerations includes ensuring service configurations support null value handling and testing integrations to confirm accurate data clearing without unintended consequences.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

  • Ensure REST and SOAP service integrations are configured to explicitly handle null values to prevent data misinterpretation during imports.  
  • Verify null value imports in a non-production environment to confirm accurate field clearing without affecting unrelated data.  
  • Document null value handling in integration protocols to maintain consistency across system updates and data exchanges.

Key resources

  • Oracle Order Management Implementation Manual