Automated export of Oracle GLAS CSV file

[peter_osang]

Hello,

Is there a way to automate the export of the Oracle GLAS audit data from FNMS?   A command line tool that could be run on the FNMS application server would suffice.

[ChrisG]

I believe that unfortunately there isn't a way to do this. As far as I know the logic that generates the Oracle GLAS audit data .zip file is only executed in response clicking on the Download archive link on the Oracle Instances page in the web UI.

[mloewenberg · Accepted solution]

Large parts of the Oracle GLAS audit data archive are generated during the Inventory Import. During the download the ORCL_DETAIL.csv and ORCL_OVERVIEW.csv are generated and added.

[peter_osang]

Thanks both.   I can see the zip file containing the CSV files is written to the Document table by the writers.  It is given the name 'OracleLMSAuditEvidence.zip'.   I should be able to extract it from there.

[ChrisG]

Yes, you can get some of the content from the Document table. Just be aware that what you will get from there is different from what you will get if you download the archive from the UI: as @mloewenberg noted, there are additional files added to the archive when it is downloaded from the UI.

[avi0408]

Hello @ChrisG , is there any way to change the frequency of this oracle GLAS Archive report generation as it used to run after every publisher recon as well.

Thanks, Awadh

[mloewenberg]

Hello,

currently the implementation triggers the Oracle GLAS Archive report generation after each run of the reconciliation. There is no way to regulate this.

It is implemented this way as some parts of the generate file depend on reconciled data and thus could change with a reconciliation.

Best regards, Martin