My Oracle Support Banner

API Search Not Returning Non-Zero Data at the Category Level When Performing a CRUD Finance API Search in Instantis EnterpriseTrack (Doc ID 2397417.1)

Last updated on MARCH 18, 2019

Applies to:

Instantis EnterpriseTrack Cloud Service - Version and later
Instantis EnterpriseTrack - Version and later
Information in this document applies to any platform.


Using the Project Finance Data with any Finance template with "Display only Non-Zero Records(Y/N)" = Y, the Finance CRUD API search is not returning non-zero 0.00 values if at the Category level total is calculated to 0.00. The CRUD search is expected to return any calculated non-zero 0.00 value at the Category level. E.g., if the sum for the given month at the Category level is 0.00 due to positive and negative elements values off-setting each other to 0.00 the API is not returning the calculated non-zero 0.00 value.

The issue can be reproduced at will with the following steps:

  1. Add project with Financial data
  2. Create Category elements with off-setting values (+/-) that calculates to 0.00
  3. Download Project Finance Data template
  4. Set input values for Project ID
  5. Set option Display only Non-Zero Records(Y/N) = 'Y'
  6. Run the API search
  7. Result: blank "" value returning for calculated non-zero 0.00 value


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.