Updated Response for Import Data Slice REST API

When using the Import Data Slice REST API, the response now provides information about cells saved to Essbase.

• numAcceptedCells shows the total number of cells that were accepted for save without errors.

• numUpdateCells indicates how many cells out of numAcceptedCells were updated in Essbase. Only cells where the input values are different from the values in Essbase are updated.

• numRejectedCells indicates the number of cells that the user does not have read-write access to; cells where row or column member names are invalid and do not exist; cells where the data is invalid (for example, an invalid Smart List value); and cells that are non-numeric (Smart List, Text, or Date type) with data when aggregateEssbaseData is set to true. 

• rejectedCells shows the cells that were rejected if IncludeRejectedCells is true.

• rejectedCellsWithDetails shows the reasons why the cells were rejected if IncludeRejectedCellsWithDetails is true.

Business Benefit: The updated response provides detailed information on how much Essbase data was actually updated compared to the amount of data that was imported as well as which cells were rejected and why.

Steps to Enable

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

Tips And Considerations

Use these Implementation Best Practices to ensure success with your REST API projects.

Key Resources

• REST APIs for Oracle Fusion Cloud EPM:
  • Import Data Slices
  • REST Resources and Methods
  • About the REST APIs for EPM Cloud
  • EPM Cloud REST API Compatibility
  • Quick Reference Table - REST API Resource View

Access Requirements

• Service Administrators