Applications

Expand all | Collapse all

Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

  • 1.  Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    Oracle Ace
    Posted 08-12-2020 09:47
    For those folks that have upgrade from EBS 12.1.3 to 12.2.9 have you seen any issues with any of the following:

    Custom Forms. Has the upgrade caused any problems with custom forms and are any additional steps needed other than needing to recompile them?

    WebADI Templates. Will WebADI templates from 12.1.3 work in 12.2.9 or do they need to be re-created?

    Thanks,

    ------------------------------
    Alfredo Abate
    Sr. Oracle Systems Architect
    Brake Parts Inc.
    McHenry IL
    (815) 759-7676
    ------------------------------


  • 2.  RE: Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    OATUG Star Partner
    Posted 08-13-2020 07:29

    Customisation's and various tables will be affected and Oracle Seeded data entered as part of the Upgrade. Take a look at ConfigSnapshot for use throughout the Upgrade and beyond for business as usual activities, patching etc. especially the Customisation Identification and Impact Analysis. The tool will also identify new fields and functionality being introduced or being make obsolete as part of the Upgrade so you can plan and act accordingly.

    Please note you can run the ConfigSnapshot Customisation Identification and Impact Analysis against your R12.1.3 environment before even starting the Upgrade as it is an essential part of Upgrade planning and you do not have to stand up and R12.2.9 environment to do this.

    www.ConfigSnapshpt.com   

    I hope this helps.

    Kind regards
    Martin Jenkinson



    ------------------------------
    Martin Jenkinson
    Account Director
    ConfigSnapshot – Rookery Software
    Malmesbury, Wiltshire
    (646) 652-6855
    ------------------------------



  • 3.  RE: Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    OATUG Star Partner
    Posted 08-13-2020 09:50
    Hi Alfredo,
    WebADI templates may need to be recreated, all depends on the level of customization or integrators you have. I've seen cases that upgrades mess up the Webadi, I will suggest asking Oracle Support thru an SR for known issues.
    Custom Forms..you need the details and make an impact analysis. Are tools out there that could help you identify issues, but even with that, you can't ensure that they will work. My own experience with upgrades similar to the 12.1 to 12.2, varies from case to case. Sometimes I had to redevelop the custom forms, as some stuff could change significantly, sometimes you don't need to recompile, sometimes you need to re-engineer them completely
    To avoid the issues that normally you could experiment with webadi, take a look at our tool at more4apps. Upgrades/patches don't affect our tool and your users have zero downtime after the upgrades as our tools support any version of excel and any version of EBS (12.0 - 12.2)

    Regards,

    Carlos

    ------------------------------
    Carlos Urtubia
    Pre-Sales Consultant
    More4apps
    Hamilton
    (506) 6540776
    ------------------------------



  • 4.  RE: Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    Posted 08-14-2020 08:46

    Hi Alfredo,

    As you know you are already licensed for API Wizard, so if you do need to recreate the templates and forms, you may as well just use  API Wizard to replace the templates since it would be free since you are already licensed, and that would also help you in the future when this situation arises again as API Wizard loaders are immune to upgrades and patches so you'll have a much more seamless upgrade path. Let me know what processes you need and we can talk outside of this forum and get you the loaders you need. 

    Thanks!
    Sarah



    ------------------------------
    Sarah Conzemius
    VP of Business Development
    API Wizard
    Stamford CT
    (800) 691-8714
    ------------------------------



  • 5.  RE: Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    OATUG Star Partner
    Posted 08-14-2020 07:33

    Hi Alfredo,

     

    Happy to add a little detail for this question as we're seeing many customers upgrading to 12.2.x (whether or not they plan to go Oracle SaaS):

    Custom Forms. Has the upgrade caused any problems with custom forms and are any additional steps needed other than needing to recompile them?

    One of the key changes in R12.2 is in the patching mechanism, which relies on database editioning. As part of this change Oracle requires that customizations only reference objects in the APPS schema and not the underlying tables. As this restriction was not in place prior to 12.2 it is possible that some customizations do reference underlying tables. If the specific schema name is not included before the object name then the customization should use the synonym with that name, which should reference the correct APPS object. However, if a schema other than APPS is referenced in the customization it should be changed so that the customization refers to the APPS object. Once this is done recompile the custom object and migrate to the system accordingly.

    WebADI Templates. Will WebADI templates from 12.1.3 work in 12.2.9 or do they need to be re-created?

    Templates itself will not have an issue. We need to make sure the APPS schema is referenced in the custom packages/views used by the WEBADI instead of standard schema names.



    ------------------------------
    Peter Quintiliani
    Apps Associates
    pete.quintiliani@appsassociates.com
    (781) 413-1413
    ------------------------------



  • 6.  RE: Upgrade EBS 12.1.3 to 12.2.9 - Custom Forms and WebADI

    Posted 08-14-2020 09:24

    Alfredo,

     

    When we upgraded from 12.1.3 to 12.2.6, we had to reapply all of our customs to the 12.2.6 version of the forms.  If you use personalizations, those are persistent and just need to be tested for applicability.

     

    If you have not already done so, I would recommend making sure all customizations (forms, extensions, bolt-ons, etc) reference the apps synonym for any tables rather than going directly to the product table.  This will save a lot of issues when it comes to on-line patching.

     

    After we upgraded to 12.2.6 and 12.2.9, Web ADI templates needed to be recreated.  We still have an open 12.2.9 SR with Oracle on the LOV for a DFF stating no value in accounting date even though the date exists.  There is a workaround for that but we are still waiting for a patch. 

     

    Tom Mullen

    Oracle ERP Project Lead

    Financial Systems - 10742

    Sandia National Laboratories

    505.263.4507