Page tree
Skip to end of metadata
Go to start of metadata

On this page:

Target audience:

CAST Administrators

Summary: this page provides detailed information about CAST's support for Oracle Forms and Reports technologies.

Detailed technology support

Language Version
Supported
Supported by reference
Deprecated support

Forms/Reports 10g: 9.0.4

(tick)  

Forms/Reports 10g R2: 10.1.2.0.2

(tick)  

Forms/Reports 10g R2: 10.1.2.3.0

(tick)  
Forms/Reports 11g(tick)  
Note that currently CAST only supports the storage of Forms analysis results in CSS or Oracle CAST schemas.
Please see Support category explanations for more information about the column headings.

Required third-party software

Note that if the CAST Delivery Manager Tool (DMT) is being run (whether from the CAST AIC Portal or direct from the CAST Management Studio (CMS)) from the SAME workstation as the one used for CMS to run the analysis/snapshot generation, then any IDEs or APIs will need to be installed on the workstation running CMS so that the DMT can access them.

To successfully deliver and analyze Oracle Forms and Reports code, the following third-party software is required:

Forms version supported
Install on workstation running the DMT (for extraction)
Install on workstation running CMS (for analysis)
32bit only

Software required

  • Oracle Forms
    • Oracle Forms 32bit must be installed on the workstation on which the extraction is being run from (i.e. the workstation running the CAST Delivery Manager Tool).
      • You must ensure that the following two Windows environment variables are correctly configured for your installation of Forms. If this is not the case, you may find that the CAST Delivery Manager Tool will stop during the extraction phase and will not be able to continue due to an invalid Forms module. If this occurs, the Log summary will contain the name of the Forms module which caused the error. You can then remove this module and re-run the package action.
        • The path to the Oracle Forms Builder installation must be configured in the PATH environment variable
        • The FORMS_PATH environment variable must point to the correct Forms source code directory
    • You must ensure that you install the same version of Oracle Forms as was used to develop the source code you are extracting.
    • Recommended language for NLS_LANG global parameter: CAST highly recommends that the installation of Oracle Forms uses an NLS_LANG global parameter set to ENGLISH (United Kingdom or United States) to avoid issues with resolving references between Forms objects.

    • CAST recommends organizing your Oracle Forms source code as follows:
      • All the source code must be stored in a single folder (PLL / FMB all in one folder), or:
      • All the PLLs must be stored in a dedicated folder and the FMBs in different dedicated folder.
  • Oracle Reports
    • When delivering Oracle Reports (i.e. no Oracle Forms is included), it is not necessary to install Oracle Forms on the workstation on which the extraction is being run from (i.e. the workstation running the CAST Delivery Manager Tool). Instead the CAST Delivery Manager Tool will accept raw .rex files.
Nothing required

Note about Oracle Reports

When you need to deliver Oracle Reports, the CAST Delivery Manager Tool can only handle .rex files. If you have Oracle Reports .rdf files and would like to include them in the delivery, you can convert them to .rex files as follows:

@@Echo on
REM set the REPORTS_PATH Oracle Environment Variable to point to the reports and templates required by rwconverter.exe. This environment variable is
REM used to locate reports and external objects that you use in your reports, such as PL/SQL libraries, external queries, and external boilerplate.
REM see https://docs.oracle.com/cd/B14099_19/bi.1012/b14048/pbr_rfap.htm#i648209 for more information.
set REPORTS_PATH=<path_to_reports>;<path_to_dependencies>
 
REM change directories and move to the location of your *.rdf files
cd D:\path_to\some_folder\
 
REM loop through all .rdf files in the current folder and convert into .rex files
for %%f in (*.rdf) do C:\path_to\rwconverter.exe source=%%f userid=<userid> stype=rdffile dtype=rexfile dest=..\rex1%%f.rex batch=yes
pause

Packaging with CAST Delivery Manager Tool

DMT optionsDescriptionDiscover: What does the DMT consider as a project?

Forms/Reports on file system

This option requires that you specify the folder containing the following Oracle Forms and Reports files. The embedded extractor will handle the processing of these raw files:

Oracle Forms

  • .fmb
  • .olb
  • .mmb
  • .pll

Oracle Reports

  • .rex

For each of the following files, one "project" will be discovered by the DMT - one "project" is equal to one "Analysis Unit" in the CAST Management Studio:

Oracle Forms

  • .fmb
  • .olb
  • .mmb
  • .pll

Oracle Reports

  • .rex

Oracle Forms and Reports objects and links

The following section lists the objects and links between objects that the Oracle Forms and Reports analyzer is capable of detecting and storing in the CAST Analysis Service:

Oracle Forms objects

Previous IconCurrent IconMeta Model Description
Meta Model Name
 
Oracle Forms WindowCAST_Forms_Window
 

Oracle Forms Window TabCAST_Forms_Window_Tab

Oracle Forms AlertCAST_Forms_Alert
 

Oracle Forms Alert TabCAST_Forms_Alert_Tab

Oracle Forms CanvasCAST_Forms_Canvas
 

Oracle Forms Canvas TabCAST_Forms_Canvas_Tab

Oracle Forms DatablockCAST_Forms_DataBlock

Oracle Forms Data Block RelationCAST_Forms_DataBlock_Relation

Oracle Forms Library Tab DataBlockCAST_Forms_DataBlock_Tab

Oracle Forms DataBlock ItemCAST_Forms_DataBlockItem

Oracle Forms Library Tab DataBlock ItemCAST_Forms_DataBlockItem_Tab

Oracle Forms FunctionCAST_Forms_Function

Oracle Forms Library Tab FunctionCAST_Forms_Function_Tab

Oracle Forms LOVCAST_Forms_LOV

Oracle Forms Library Tab LOVCAST_Forms_LOV_Tab

Oracle Forms MenuCAST_Forms_Menu

Oracle Forms Library Tab MenuCAST_Forms_Menu_Tab

Oracle Forms Menu ItemCAST_Forms_MenuItem

Oracle Forms Library Tab Menu ItemCAST_Forms_MenuItem_Tab

Oracle Forms Menu Module (.MMB file)CAST_Forms_MenuModule

Oracle Forms Module (.FMB file)CAST_Forms_Module

Oracle Forms Menu Module ParameterCAST_Forms_ModuleParameter

Oracle Forms Object Library (.OLB file)CAST_Forms_ObjectLibrary

Oracle Forms Library TabCAST_Forms_ObjectLibraryTab
Oracle Forms PackageCAST_Forms_Package

Oracle Forms Library Tab PackageCAST_Forms_Package_Tab

Package BodyCAST_Forms_PackageBody

Oracle Forms Library Tab PackageCAST_Forms_PackageBody_Tab

Oracle Forms PL/SQL Library (.PLL file)CAST_Forms_PlsqlModule

Oracle Forms Popup MenuCAST_Forms_PopupMenu

Oracle Forms Popup Menu ItemCAST_Forms_PopupMenuItem

Oracle Forms ProcedureCAST_Forms_Procedure

Oracle Forms Library Tab ProcedureCAST_Forms_Procedure_Tab
 

Oracle Forms ProcedureCAST_Forms_PrivateProcedure

Oracle Forms Property ClassCAST_Forms_PropertyClass

Oracle Forms Library Tab Property ClassCAST_Forms_PropertyClass_Tab

Oracle Forms Record GroupCAST_Forms_RecordGroup

Oracle Forms Library Tab Record groupCAST_Forms_RecordGroup_Tab

Oracle Forms TriggerCAST_Forms_Trigger

Oracle Forms Library Tab TriggerCAST_Forms_Trigger_Tab

Oracle Forms Visual AttributeCAST_Forms_VisualAttribute

Oracle Forms Visual Attribute TabCAST_Forms_VisualAttribute_Tab

Oracle Forms Visual AttributesCAST_Forms_VisualAttributes

Oracle Forms Library Tab Visual AttributesCAST_Forms_VisualAttributes_Tab
 

Oracle Forms Package TypeFORMS_TYPEPACKAGEHEADER
 

Oracle Forms Sub ProcedureFORMS_SUBPROCHEADER
 

Oracle Forms Sub FunctionFORMS_SUBFUNCHEADER

 

Oracle Forms CursorFORMS_SUBCURSORHEADER
 

Oracle Forms VariableFORMS_SUBVARIABLEHEADER
 

Oracle Forms Sub ProcedureFORMS_SUBPROCBODY
 

Oracle Forms Sub FunctionFORMS_SUBFUNCBODY
 

Oracle Forms CursorFORMS_SUBCURSORBODY
 

Oracle Forms VariableFORMS_SUBVARIABLEBODY

Oracle Reports objects

Previous Icon
Current Icon
Meta Model Description
Meta Model Name
Previous Icon
Current Icon
Meta Model Description
Meta Model Name
 

Oracle Report Data LinkFORMS_RDF_DATA_LINK

Oracle Report Database ColumnFORMS_RDF_DB_COLUMN
 

Oracle Report Summary ColumnFORMS_RDF_SUMMARY_COLUMN
 

Oracle Report Formula ColumnFORMS_RDF_FORMULA_COLUMN
 

Oracle Report Placeholder columnFORMS_RDF_PLACEHOLDER_COLUMN
 

Oracle Report File QueryFORMS_RDF_EXT_FILE_QUERY

Oracle Report GroupFORMS_RDF_GROUP

Oracle Report ModuleFORMS_RDF_MODULE
 

Oracle Report Data ModelFORMS_RDF_DATA_MODEL
 

Oracle Report Predefined SourceFORMS_RDF_PREDEFINED_SOURCE
 

Oracle Report System ParameterFORMS_RDF_SYSTEM_PARAMETER
 

Oracle Report User ParameterFORMS_RDF_USER_PARAMETER
 

Oracle Report ElementFORMS_RDF_ELEMENT
 

Oracle Report Non OraDB QueryFORMS_RDF_NON_ORADB_QUERY
 

Oracle Report QueryFORMS_RDF_QUERY
 

Oracle Report Ref Cursor QueryFORMS_RDF_REF_CURSOR_QUERY
 

Oracle Report Unknown QueryFORMS_RDF_UNKNOWN_QUERY
 

Oracle Report BP ButtonFORMS_RDF_BUTTON
 

Oracle Report BP ChartFORMS_RDF_CHART
 

Oracle Report Form ParameterFORMS_RDF_PARAMETER_FORM
 

Oracle Report user columnFORMS_RDF_USER_UNKNOWN_COLUMN
 

Oracle Report Layout ModelFORMS_RDF_LAYOUT_MODEL
 

Oracle Report HeaderFORMS_RDF_HEADER
 

Oracle Report TrailerFORMS_RDF_TRAILER
 

Oracle Report BodyFORMS_RDF_BODY
 

Oracle Report MarginFORMS_RDF_MARGIN
 

Oracle Report Repeating FrameFORMS_RDF_REPEATING_FRAME
 

Oracle Report FrameFORMS_RDF_FRAME
 

Oracle Report FieldFORMS_RDF_FIELD
 

Oracle Report BP TextFORMS_RDF_BP_TEXT
 

Oracle Report BP PolygoneFORMS_RDF_BP_POLYGONE
 

Oracle Report BP PolylineFORMS_RDF_BP_POLYLINE
 

Oracle Report BP FreehandFORMS_RDF_BP_FREEHAND
 

Oracle Report BP LineFORMS_RDF_BP_LINE
 

Oracle Report BP RectangleFORMS_RDF_BP_RECTANGLE
 

Oracle Report BP Rounded RectangleFORMS_RDF_BP_ROUNDED_RECTANGLE
 

Oracle Report BP EllipseFORMS_RDF_BP_ELLIPSE
 

Oracle Report BP ArcFORMS_RDF_BP_ARC
 

Oracle Report BP ImageFORMS_RDF_BP_IMAGE
 

Oracle Report BP UnknownFORMS_RDF_BP_UNKNOWN

Oracle Report Program UnitFORMS_RDF_PROGRAM_UNIT
Link Type
When is this type of link created?
Use (U)This type is generically used to describe an interaction between two objects.

For example:

  • between a Form Module and its Menu Module
Call (C)A link of this type is created from a (popup) menu item invoking a menu to the cascading (popup) menu.

For example:

  • Between a data block item and the sequence specified in its Initial Value property.
  • Between a Form Module and the Report Modules via Report Objects.
Inherit (I)A link of this type is created from an object created by subclassing to the source object. It is also created between an object and its property class and between a subclassed Module and its reference modules.
Match (X)This type of link indicates a link you have created using a Reference Pattern.
Rely OnThis type of link is created between a data block and the server objects used to construct it.
AccessThis type of link is created when there is a reference in the code to a data block item through host variable syntax (:block.item or :item).
MonitorThis type of link is created between a data block relation and the data block.
Link Type
When is this type of link created?
Rely On
  • from Oracle Report Data Link to child column
  • from parent column to Oracle Report Data Link
  • from group to query
  • from query to PL/SQL code (function, procedure, package)
  • from database column to query

Notes

The following section lists technical and functional aspects with regard to analysis of Oracle Forms source code:

Please note that currently inter-Application links (i.e. links between source code in separate Applications) between the following combinations of technologies is not supported:

  • Between Oracle Forms Analysis Units in different Applications
  • Between Oracle Forms Analysis Units and Oracle Server PL/SQL Analysis Units in different Applications

If you do require link resolution, then all Analysis Units must belong to the same Application.

Objects containing non printable ASCII characters

Oracle Forms objects containing non printable ASCII character such as DC2 (Device Control2) are skipped during the analysis and a warning message will be outputted to the log file.

 

  • No labels