Package Rating Components Error 'The Prompt Table In DERIVED.EDITTABLE19 Is Not Available. (4,3)' (Doc ID 2684701.1)

Last updated on JULY 09, 2021

Applies to:

Symptoms

When attempting to add a new value in Package Rating Component #19, the following error occurs.

"The prompt table in DERIVED.EDITTABLE19 is not available. (4,3)
The prompt table for this field is controlled be the contents of another field. This controlling field is not included in the component."

Same with Component #20, with the only difference in the message being 'DERIVED.EDITTABLE20'. The same issue does not occur with any of the other component fields 1-18

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

1. Navigate to Set Up SACR > Product Related > Recruiting and Admissions > Application Evaluation > Rating Comp Definition Table 
2. Make sure there are at least 19 values set up for the institution, or add more as necessary.
3. Navigate to Set Up SACR > Product Related > Financial Aid > Awards > Packaging Rating Components > Packaging Rating Components 2.
4. Click on prompt for fields 19 and 20.

Cause

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