Forum Stats

  • 3,752,060 Users
  • 2,250,453 Discussions
  • 7,867,705 Comments

Discussions

Oracle Forms New Feature Ideas

1235713

Comments

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,815 Employee
    edited Aug 19, 2020 7:51AM

    @Walid KHARRAT

    Please review this for your FSAL script and installation idea.

    https://community.oracle.com/thread/4111118

  • MWaseem
    MWaseem Member Posts: 197 Blue Ribbon
    edited Aug 21, 2020 3:25AM

    Can we have Oracle Forms Integration With Oracle OAS (Oracle Analytices Server).

  • Walid KHARRAT
    Walid KHARRAT Member Posts: 110 Red Ribbon
    edited Aug 21, 2020 7:07AM

    Thanks for your suggestion, i will also evaluate vbscript and python to do this, both can do the job(create folder,download, extract...) and i can create exe from script. a small exe to deliver to pc clients...

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,815 Employee
    edited Aug 21, 2020 8:19AM

    @Akhtar_w

    Forms 12.2.1.4 can already make calls to Analytics Publisher (on-prem or Cloud).

  • MWaseem
    MWaseem Member Posts: 197 Blue Ribbon
    edited Aug 21, 2020 9:30AM

    Thanks Sir for Your Reply Michael Ferrante-Oracle . Can You Please Refer a document or process how to make call to Analytics Publisher (on-prem) from oracle forms.

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,815 Employee
    edited Aug 21, 2020 10:02AM

    Refer to the Forms New Features guide and/or refer to the 12.2.1.4 Builder Help.  Specifically look for the information about SET_REPORT_OBJECT_PROPERTY.  That section has most of the technical details. For the most part, the concept is exactly the same as making calls to Reports.  You should be able to mostly re-purpose your existing code.

    The New Features Guide and many others can be found on the Forms product page:

    https://www.oracle.com/application-development/technologies/forms/forms.html

    MWaseem
  • german.ardila
    german.ardila Member Posts: 1 Blue Ribbon
    edited Sep 3, 2020 11:40AM

    Hi,

    It would be nice,

    * SAML2 or Openid authentication, SSO Alternatives other than OAM.

    * Log with Active Directory, without OID dependency.

    * Automated scripts or deployment for FSAL in desktops. In web centric, it's tedious to have to manually deploy this for users. For reference Office 365 installer, automatically, downloads, install everything it needs and also put dekstop/start menu icons.

    Thanks,

    beans
  • Charon
    Charon Member Posts: 157 Bronze Badge

    There is so much wrong with the Forms Builder I will just write all my ideas here:

    - Let us choose an editor font (with ligatures please)

    - Editor Color Schemes

    - ability to "fold" code blocks

    - FontAwesome in Forms

    - don't store as FMB

    so we can use git

    why even one file per Form? Why not a couple of files where each trigger and program unit gets stored in their own file (to preserve formatting and line feeds, these get butchered in the XML file and make clean diffs impossible)

    - DoubleClick on Trigger while pressing SHIFT opens a separate editor. Would like to do the same when pressing F11 with SHIFT.

    - Enable use of MouseWheel in Object Navigator

    - Get rid of MDI user interface. Dock all windows and use Tabs at the top to navigate between them.

    - Miniature view of code on the right side of the window

    - create set_block_property for "Number of Records Displayed"

    - create set_menu_item_property HINT_TEXT

    - when converting an FMB to XML don't append spaces to each line

    - let us put images and JavaClasses into a special file which we can deploy with our fmx. it always is a hassle to use a JAR for this

    - please allow NVL2 in PL/SQL

    - make it an error during compile time if referencing a non existing field in a set_item_*/get_item_*/find_item

    I know this is impossible since a variable could be in use. So only check it if a literal is used. Or climb up the call tree to find out which literal was used.

    That this isn't picked up by the compiler makes maintaining Forms really hard when you restructure big parts of your application.

    - Blocks:

    Check "Query Data Source Name" and "DML Data Target Name" for validity during compile.

    And last but not least:

    Make the FormsBuilder OpenSource so we as a community can do great stuff with it ;-)

    beansSFrix
  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,815 Employee
  • Frank Hoffmann
    Frank Hoffmann Member Posts: 790 Gold Badge

    Mike,

    two enhancement requests

    1.) After the repository installation this script should come at the end. I have seen many customers where Weblogic stopped working because of Password_life_time restriction.

     PREFIX FRM12214:

    CREATE PROFILE RCU_PROFILE

     LIMIT PASSWORD_REUSE_MAX UNLIMITED

    PASSWORD_REUSE_TIME UNLIMITED

    PASSWORD_LIFE_TIME UNLIMITED; 

    alter user FRM12214_IAU profile rcu_profile;

    alter user FRM12214_IAU_APPEND profile rcu_profile;

    alter user FRM12214_OPSS profile rcu_profile;

    alter user FRM12214_STB profile rcu_profile;

    alter user FRM12214_IAU_VIEWER profile rcu_profile;

    alter user FRM12214_WLS_RUNTIME profile rcu_profile;

    alter user FRM12214_WLS profile rcu_profile;

    2.) Weblogic is storing the "HOSTNAME" of the repository DB in the runtime environment during installation. (Example Windows Server)

    When the Hostname changes you are lost

    Suggestion - as Hint in the documentation

    Add for example an entry in HOSTS

    192.168.1.19 REPOSDB

    Do your Repository Installtion now - if your Datebase moves from 192.168.1.19 -> 192.168.1.20 the startup of weblogic will hang.

    If you switch the entry in HOSTS it directly starts up and you do not have to change any scripts.

    With this trick you could also place your old serverhostname there and simply switch the IP adress.


    Frank

    Richard Harrison