Hi,
We have implemented and integrated our Oracle APEX 18.2 instance with our Oracle EBS R12 instance in development. We are now on the stage of determining how we deploy applications from our development to our test and uat instances.
Currently, we export applications via the Export utility in APEX UI. Then we are required to use Oracle Enterprise Manager to deploy the said sql file.
This works okay but I have a few concerns that I would like to clarify.
We have multiple development instances in our company. Like one for HR, another for Finance team etc. During development, its possible to create applications on these 2 separate instances. There is a chance that both APEX application might generate the same application id since they are on different instance. If these two were deployed to production, will one overwrite the other? If yes, how do we prevent this? Is there a way to use the Application Alias and generate a new application id in production. The probability of getting the same application alias is low since we have naming convention where we suffix the alias by module like 'HREMP','HREDUC' etc.
Regards,
Allen