Startseite 5 Techblog 5 Solving issues with new E-Business Suite APEX integration for existing users

Solving issues with new E-Business Suite APEX integration for existing users

23. Februar 2025

Johannes Michler PROMATIS Horus Oracle


Executive Vice President – Head of Platforms & Development

In November 2024 Oracle released a new and greatly improved version of the E-Business Suite to Oracle APEX extension. When implementing this for 2 of our PROMATIS customers that had already an older solution for this I ran into issues when running an adop cycle after running the ADAPEXSCHREG.sql.

Here is how we were able to overcome this:

Issues with adop patch cycle

The Problem we ran into was, that ADAPEXSCHREG "forcibly" updates the fnd_oracle_userid to have the password of the APEX Schema/user as INVALID. This may be a good idea in general, however if you have previously adspliced the APEX schema within E-Business Suite (which may be a good idea for various reason), this will break a follow-up adop cycle. When adop validates to connect to the application that has now an "INVALID" password it fails; thus breaking the ADOP cycle.

As shown in this blog post I've been able to solve this by restoring the entry in fnd_oracle_userid from a backup; however you'll probably prefer to not even run into this situation.

    De-Register the custom application

    Fortunately it is easy to de-register the custom application. This process is described in 2085355.1 and basically all you have to do is the following:

    cd $AD_TOP/bin/
    perl adDeregisterCustomProd.pl


    De-Registering the application

    For at least one customer environment I had to run the process twice; once with an APP-CAPPS Application name and once with the all-lower version.

    Validate

    After de-registering I checked the fnd_oracle_userid (the record should no longer be anabled) and fnd_application table (the record should be vanished:


    Record gone from fnd_application

    
    

    You should then run an "adop -validate" and finally an (empty) patching cycle.

    Only then did I run ADAPEXSCHREG.sql which did then not cause any further issues. I hope Oracle will extend the ADAPEXSCHREG script to do some validations in that area.

    Summary

    With the above procedure it is possible to use a pre-existing APEX parsing schema with the new 12.2 APEX for EBS extension.