Error 'The file is incomplete or corrupt and will not be displayed correctly! You might be able to view a partial content using Data View / Full View' When Opening the Grants Analyzer Output After Upgrade to Version 200.13 (Doc ID 3057061.1)

Last updated on NOVEMBER 06, 2024

Applies to:

Symptoms

After applying the latest version of the Grants Analyzer, 200.13, when trying to open the output of the analyzer, it gives:

The Grants analyzer log file shows:

GMSANL: Grants Award Analyzer

[28-OCT-2024 07:45:33]: **Starts**
[29-OCT-2024 16:31:18]: **Ends**
PROGRAM ERROR
Error in run_sig_sql at step 30: ORA-00904: "DB_VERSION": invalid identifier
See the log file for additional details
...
Error in run_sig_sql at step 30 running: SELECT 'EBS Applications = '|| release_name "Database Information" from fnd_product_groups
UNION ALL
SELECT 'EBS Platform = ' || platform_name FROM v$database
UNION ALL
select 'Database = ' || db_version from v$version where rownum = 1
UNION ALL
SELECT 'OS Platform Version at DB server = ' || dbms_utility.port_string FROM dual
UNION ALL
SELECT parameter ||' = '||value FROM v$nls_parameters WHERE parameter IN ('NLS_LANGUAGE', 'NLS_CHARACTERSET')
Error: ORA-00904: "DB_VERSION": invalid identifier
Processing signature: AC_DB_PARAMETERS "Database Parameters"
29-OCT-24 16:31:17-Query start
29-OCT-24 16:31:17-Query finish (.022 Sec)
29-OCT-24 16:31:17- Rows fetched: 31
29-OCT-24 16:31:17-Process start [S86]
29-OCT-24 16:31:17-Process finish [S86] (.016 Sec)
29-OCT-24 16:31:17-end section: AppsCheck
29-OCT-24 16:31:17-end section: Main Section
Signatures where exception occurred:
- AC_DB_INFO "Database Information"
29-OCT-24 16:31:18-Entered close_files

Steps to Reproduce:

1.  Project / Grants form based responsibility
2.  Grants:  Reports | Run and Projects:  Other | Requests | Run
3.  Grants Award Analyzer

Changes

 Upgraded the Grants Analyzer

Cause

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