R12.2: PA: Custom Projects WebADI Integrator Does Not Pass the Project Information to the Custom Projects API Causing "No Data Found" Exception (Doc ID 2020251.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Oracle Web Applications Desktop Integrator - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Using custom WebADI Integrator to update the task information for a particular project. This is a system upgraded from 11i to 12.2.4.
The webadi integrator does not work as it throws the 'No Data Found' exception in the custom package that is called from the WebADI Integrator.

The error message is no data found while trying to Upload data to Projects via WebADI layout to Projects public Project API.

This is being returned by the custom package that gets called from the WebADI template where it can be observed that users are receiving the NO DATA FOUND error like above.
Under the custom package  - UPDATE_TASK procedure is called… The initial IF Condition in this package is to test if the task id is null..  After the END IF of the above IF condition there is the exception part, where the package is raising the no data found exception.

 

Cause

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 hundreds of Community platforms