Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importance of application Alias

Ryansun-OracleMar 26 2014 — edited Mar 26 2014

4.2.1

Hi Everyone,

  A quick question, How is the application alias set in Apex for an application? Under Edit application properties I see that it is a non-mandatory field. In some cases it is just the application id and in others it has the application id with a a few more numbers. The reason, I ask is we recently hit an issue when we exported the code from our development env and moved it to another and the import failed(done using the sqlplus option and not the application builder as per our standard process which works fine). But the app alias on that environment for the existing older version was different and we were getting a bunch of unique constraint violated errors causing the script to fail. When I corrected the alias, to the older one, it worked. Now we don't set the alias as such, but was wondering, how an what the significance is. I see there is a

p_name  => nvl(wwv_flow_application_install.get_application_name,'My App'),

  p_alias => nvl(wwv_flow_application_install.get_application_alias,'F_123'),

in the application create. Can this be manually manipulated in the edit properties. If we change it and try to move the script to other environments where the application exists, will it break if the alias is different?

thanks!

Ryan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2014
Added on Mar 26 2014
2 comments
652 views