How to merge two extracts?

If you run the Concurrent Manager on a different server than the Oracle Application server, a separate extraction must be done from each server. To validate the extractions were completed successfully from each server; check the ETL log that one extraction came from the Oracle Applications Server and one from the Concurrent Manager Server.
 
A Merge tool is available to combine the two extracts into a single file which can be uploaded to Panaya’s servers.
  • Run the Panaya extractor both on the Oracle Applications server and on one of the Concurrent Manager servers, as described in the section: EXTRACTING THE CUSTOM CODE AND USAGE STATISTICS.

Using your Oracle Apps OS user, execute the following command in order to merge the two files into one:

java -cp panaya-extractor.jar MergeFiles appsETL=<oa_etl> concETL=<cm_etl> [<new_etl>]

Parameters explanation

  • <oa_etl> – is the full path of the extracted filename from the Oracle Application server
  • <cm_etl> – is the full path of the extracted filename from the Concurrent Manager server
  • <new_etl> – is the full path of the merged extracted filename. This is an optional parameter; the default value if not specified is "ETL_MERGE_ + timestamp.zip"

The merged file will be built as follows:

  • reports.zip/bin.zip/sql.zip – will be copied from the cm_etl file
  • framework.zip – will be copied from the cm_etl file, unless it is found in the oa_etl.zip file
  • Appl_tops.properties, etl.log – will be copied from the cm_etl and renamed to conc_appl_tops.properties, conc_etl.log
  • All other files will be copied from the oa_etl file

Upload the merged file to Panaya Code Box