Utilities


Peloton Object Parser


The Peloton Object Parser will automatically document objects from your Oracle EPM system.  Simply extract the objects from the system, place them in a folder on your local machine, and run the Parser against that folder.  It really is that easy.






The types of files that it will document are listed below (v1.8.0):

  • Classic Business Rule Exports (*.XML)
  • Calc Manager Business Rule Exports (*.XML)
  • Planning Form Definition Exports (.XML)
  • Composite Planning Form Definition Exports (*.XML)
  • Financial Reports Exports (*.DES)
  • Financial Report Books (*.KBK)
  • Financial Report Batch (*.BCH)
  • Security Export Files (*.SEC)

Other Benefits of the Parser:

  • It is Free!
    • I have been working on this utility for many years and truly believe that it is something that can help the Oracle community.  This lead us to the decision to give this utility away at no charge and really give back to the community.
  • No Installation Needed
    • It's a completely self sufficient utility
    • Will run from a flash drive as well
  • Non-Destructive Application
    • This application is non-destructive to your original files.  It will simply open them up, read through them, and create separate files of its own.
    • As a best practice, please do not run this utility on your production servers.  Simply copy the object files to a client machine and run it from there.

Direct Link to Download Page:

http://pelotongroup.com/how-we-deliver/solution-accelerators/


Peloton Object Parser Changelog:

v1.8.0

  • Initial public release




Scott's Flat File Modifier


The Flat File Modifier is a windows utility that will analyze any existing text file line by line and provide you the modifications below.  Since this application is non-destructive, it will only read from the original input file and create a copy of this file with the modifications specified.  This eliminates risk and saves time in the long run.




Modification Options:

  • Replace (Single Pass)
    • This option will read the text file line by line and do a single pass on that line looking for a value and replacing it.  The single pass option will only replace the first instance of the search value that it encounters on that line then continue to the next.
  • Replace (Multi Pass)
    • This option has the same functionality as the first but does a multiple pass on each line.  This option will ensure that all occurrences of the search value will be replaced.
  • Remove Row
    • The Remove Row option will search through the file and when it finds the search value, it will remove that row from the destination file.
  • Keep Only Row
    • This option will perform similarly to the Remove Row option but it will only keep rows in the destination file where it finds the search text.

Full list of features of the Flat File Modifier:

  • Finds and replaces text in any size file without loading it into RAM
  • Line by line, non-destructive text replacement
  • Analyzes file for Row Count, File Size, and Modified Date
  • Allows preview of any size text file
  • Optional advanced sequencing of text replacement capabilities
  • Exporting and importing of proprietary sequence files
  • High Performance Mode (disables GUI refreshing for faster performance)


Download the latest Version:

v3.0.0

  • Initial release

v3.0.1

  • Minor bug fixes
  • Enhanced error handling
  • Added row number toggle in preview window

v3.0.2

  • Minor bug fixes
  • Added Header Modification Option