How To Rename an old Custom TOP From ABC_TOP To XXABC_TOP as per published EBS Development Standards' Guide (Doc ID 1918277.1)

Last updated on OCTOBER 29, 2015

Applies to:

Oracle Applications DBA - Version 10.7 to 12.2 [Release 10.7 to 12.2]
Oracle Application Object Library - Version 11.5.0 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

By example, problems will result if an E-Busuiness Suite (EBS) System Administrator/Functional Developer creates a custom TOP with a name like ABC_TOP without the XX prefix. 

The custom application short name "ABC" now impacts today's EBS management of customizations, especially when an upgrade is imminent.  The naming convention of the custom application "ABC" -- without the "XX" prefix, as in "XXABC" -- prevents to protect the company customizations during an EBS upgrade.  Also the SysAdmin, at the time, might have chosen a custom application short name longer than 5 characters which will conflict with the re-registering process using adsplice during an upgrade to EBS 12.2 (ie. ABCDEFGHI_TOP) using adsplice.

AD Splicer error:

Error at line 8:
Product Abbreviation longer than 8 bytes.
Value is 'ABCDEFGHI'

 

EBS documentation reads as follows:

Release 11.0

<Note 70276.1> - HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM APPLICATIONS

Oracle  Applications
Developer’s Guide
RELEASE 11
April 1998, part# A58187-01

Setting Up Your Application Framework, pg 2-4: To reduce the risk that your custom application short name could conflict with a future Oracle Applications short name, we recommend that your custom application short name begins with ”XX”.

Release 11.5 (11i)

Oracle Applications
Developer’s Guide
RELEASE 11i
April 2000, part# A75545-02

Setting Up Your Application Framework, pg 2-4: To reduce the risk that your custom application short name could conflict with a future Oracle Applications short name, we recommend that your custom application short name begins with ”XX”.

Release 12.0

Oracle® Applications
Developer's Guide
Release 12
December 2007, Part No. B31458-03

Setting Up Your Application Framework, pg 2-3:  To reduce the risk that your custom application short name could conflict with a future Oracle Applications short name, we recommend that your custom application short name begins with "XX".

Release 12.1

Oracle® Applications
Developer's Guide
Release 12.1
April 2009, Part No. E12897-02

Setting Up Your Application Framework, pg 2-3: To reduce the risk that your custom application short name could conflict with a future Oracle Applications short name, we recommend that your custom application short name begins with "XX".

Release 12.2

Oracle® E-Business Suite
Developer's Guide
Release 12.2
August 2013, Part No. E22961-09

Setting Up Your Application Framework, pg 2-3: To reduce the risk that your custom application short name could conflict with a future Oracle Applications short name, we recommend that your custom application short name begins with "XX".

 

The following information can be found in regards to a custom application short name in the Oracle EBS Developer's Guide:

Although your short name can be up to 50 characters, we recommend that you use only four or five characters for ease in maintaining your application and in
calling routines that use your short name. To reduce the risk that your custom application short name could conflict with a
future Oracle Applications short name, we recommend that your custom application short name begins with ”XX”

 

The choice of a custom TOP application name ABC_TOP which does not include the first letters prefix "XX" can potentially conflict with new Oracle-seeded modules introduced during an EBS upgrade or patching.  Hence, then the EBS System Adminstrator will be attempting to solve the issues of: 

- How to change a custom application definition from ABC_TOP to XXABC_TOP? 

- How can one be changing the product code and custom application name without breaking all the customized functionality that are tied hereto?  

The custom application has been in Production for a long time so many business transactions were processed over the years under ABC_TOP.

Details:
System Administrator > Navigator > Query for the custom application.  The Basepath now showing as ABC_TOP. Can it be changed to XXABC_TOP?
The application form interface prevents updating the custom application information once created.

As realized that changing the custom application from ABC_TOP to XXABC_TOP will have to be done using a table-modifying datafix script trying to keep whole all the previous transactions done over the years, the system administrator is hoping that Oracle Development can supply such datafix script.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms