Is there any documentation of a breakdown of how to interpret the Oracle GLAS evidence report, in particular the ORCL OPTIONS report? It lacks column headers.
Feb 14, 2024 05:07 PM
Sorry, I missed your answer.
There are about 80 different queries that are aggregated in the ORCL_OPTIONS file. Most queries have a different mapping of columns to COL010-COL200. In actuality only one query even uses COL160 and none uses COL170-COL200. They are just there for possible future extensions.
Apr 02, 2024 06:44 AM
Hi,
I guess you're talking about the ZIP archive downloadable from the UI.
It contains mostly raw data used by Oracle for their GLAS audit. Usually the only file read by customers is the ORCL_DETAIL.csv and the 3PTV_JAVAReport_*.csv because they may need some edits.
The ORCL_OPTIONS.csv contains results of queries run directly on the customer's Oracle databases. These queries are defined by Oracle. The columns contain as follows:
For the type and content of the query you can usually ask the database administrators as they are familiar with the underlying tables and view.
Best regards,
Martin
Feb 19, 2024 05:03 AM
Thank you for the explanation; however, it still leaves columns COL010 - COL200 as a mystery. I will take your advice and follow up with our Database Admins as well.
Feb 23, 2024 10:03 AM
Sorry, I missed your answer.
There are about 80 different queries that are aggregated in the ORCL_OPTIONS file. Most queries have a different mapping of columns to COL010-COL200. In actuality only one query even uses COL160 and none uses COL170-COL200. They are just there for possible future extensions.
Apr 02, 2024 06:44 AM