Skip to main content

ZPA Forms Extractor 1.0.0

· One min read
Maintainer

ZPA Forms Extractor 1.0.0 is out! It is a new tool that brings the PL/SQL code of Oracle Forms within reach of ZPA.

Forms keeps its code inside binary modules (.fmb, .mmb, .pll, .olb). The extractor opens them through Oracle's Forms API and writes:

  • every trigger, program unit, menu item and record group query to its own file, as compilable PL/SQL;
  • a metadata.json with the blocks, items, alerts and LOVs of each form, ready to be used as ZPA's Forms metadata.
zpa-forms-extractor --input forms/ --output extracted/ --metadata-format legacy
zpa-cli --sources extracted/orders.fmb --forms-metadata extracted/orders.fmb/metadata.json

The extractor runs on a machine with Oracle Forms Builder installed and needs Java 8 or newer. With ZPA 4.2.1, use --metadata-format legacy.

See Oracle Forms support for the complete workflow with the ZPA CLI and the SonarQube plugin, and the project README for installation and troubleshooting. The tool is open source under the Apache License 2.0.

Download it from the release page.