Does the Grants Award Analyzer Require the Award_id or the Award Number? (Doc ID 3057034.1)

Last updated on NOVEMBER 05, 2024

Applies to:

Oracle Grants Accounting - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

When running the Grants Award Analyzer, is the Award_id or the Award Number required? Per EBS Grants Award Analyzer (Doc ID 2627952.1), the parameters only list:

Parameters

Award: (Required)
Maximum Rows: (Default of 20)

When running the analyzer in SQLPLUS and passing the award number, the following is returned:

SQL> @gms_award_analyze.sql

Submitting Grants Award Analyzer...
===========================================================================
Award ID This parameter is required.
===========================================================================

Enter the Award_ID: 1234

===========================================================================
Enter the maximum number of rows to display on row limited queries
===========================================================================

Enter the Maximum Rows to Display [20]:

Files are located on Host : XXXX
Output file :
GRANTS_AWARD_Analyzer_XXXX_2024-11-01_08_23.html
Log file :
GRANTS_AWARD_Analyzer_XXXX_2024-11-01_08_23.log
**************************************************
**** ERROR ERROR ERROR ERROR ERROR ERROR ****
**************************************************
**** The analyzer did not run to completion!
**** INVALID ARGUMENT: Invalid Award ID specified.
**** Please rerun the analyzer with proper parameter value.
***************************************************************
*** WARNING WARNING WARNING WARNING WARNING WARNING WARNING ***
***************************************************************
*** Invalid parameters provided. Process cannot continue.
Parameter Values
1. Award ID: 1234
2. Maximum Rows to Display: 20
3. Debug Mode: Y
Error in validate_parameters at step: 8

PL/SQL procedure successfully completed.

Where, '1234' is the Award Number not the Id.

Solution

	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

Goal

Solution

References

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

Does the Grants Award Analyzer Require the Award_id or the Award Number? (Doc ID 3057034.1)

Applies to:

Goal

Solution

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

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