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 MAY 21, 2018

Applies to:

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

Symptoms

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.

STEPS
-----------------------
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

Changes

 

Cause

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

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


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