question on custom top creation

[Sri]

Hi Erman,

we are following the note id 1577707.1 for custom top creation.we are on R12.2.5.
Do we need to manually create the custom schema and Tablespace in the backend Database for custom schema as we do it for prior versions of R12.2? OR adsplice will take care of creating schema and tablespaces?

Thanks for your support

[ErmanArslansOracleBlog]

You need to create the tablespaces, beforehand.. (unless you will use the standard tablespaces for your custom schema, which is not recommended..  Note: Custom data and index tablespaces are defaulted to APPS_TX_TX_DATA and APPS_TS_TX_IDX.)

[Sri]

thanks for the update erman.

We have created new custom application and was successfully installed using ADSPLICE. But custom schema is pointing to default seeded tablespace instead of custom tablespace. I pre-created tablespace before running adsplice command.

Please find the entries updated in newprods.txt as below

product=XXROCK
base_product_top=*APPL_TOP*
oracle_schema=XXXXROCK
sizing_factor=100
main_tspace=XXROCK_DATA
index_tspace=XXROCK_IDX
temp_tspace=TEMP
default_tspace=XXROCK_DATA

adsplice.log

Please enter the directory where your AD Splicer control file is located.

The default directory is [/u02/XXXXROCK/fs1/EBSapps/appl] : /u02/XXROCKAPPS/fs1/EBSapps/appl/admin/

Please enter the name of your AD Splicer control file [newprods.txt] : newprods.txt


Processing file /u02/XXROCK/fs1/EBSapps/appl/admin/newprods.txt...
Loading information for product 'XXRK'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /u02/XXROCK/fs1/EBSapps/appl/admin/newprods.txt

I have searched and found the below note id

12.2 adsplice Ignores Custom Tablespaces For New Custom Application Configuration and Only Uses OATM Tablespaces ( Doc ID 1987906.1 )

I didnt understand and need your help,can i just simply alter the default tablespace of the Custom schema to our Custom Tablespace?

[Sri]

Pls advice

[ErmanArslansOracleBlog]

This is a new behaviour..

This is the expected behavior of adsplice on 12.2.  Any new application, be it offered by Oracle as a seeded application or any new custom one, will abide by the mandatory OATM model.

So, my advice  -> stick with what Oracle says..

So, it is normal that your custom tbs entries in newprods.txt are ignored.

Use adsplice to create a new custom application and let it create the new application custom objects with the 12. 2 OATM tablespaces model.


As said in :12.2 adsplice Ignores Custom Tablespaces For New Custom Application Configuration and Only Uses OATM Tablespaces (Doc ID 1987906.1)

Here is the adsplice newprods.txt example to follow for 12.2:
product=xxebs                                     <<< Note that the product_top name used to be 8 characters maximum but is now 16 chars max
base_product_top=*APPL_TOP*
oracle_schema=xxebs
sizing_factor=100
main_tspace=USER_DATA <<< this is going to be ignored but you should anyway set it properly APPS_TS_TX_DATA
index_tspace=USER_IDX   <<< this is going to be ignored but you should anyway set it properly
temp_tspace=TEMP
default_tspace=USER_DATA <<< this should be APPS_TS_TX_DATA which is the default tablespaces that must be setup for the new user XXEBS
  <<< This last line is not ignored by adsplice and need to be aligned to the user created default tablespace which starting with 12.2 will always be APPS_TS_TX_DATA.

[Sri]

Thanks erman for the update.Now can we change the tablespace of our custom user to Custom tablespace

[Sri]

Hi erman

Our custom user xxrock and our custom tablespace xxdaata,can we assign this now.current table space is apps_ts_tx_data for xxrock

[ErmanArslansOracleBlog]

No you should not..
Please read the document carefully.

[Sri]

So for custom users as well,default tablespace should be APPS_TS_TX_DATA in R12.2.If yes then i think there is no need to create custom tablespace(data and index)

Pls correct me if i am wrong.thank you for the valuable updates erman

[ErmanArslansOracleBlog]

Yes. That 's correct. (this is the up-to-date info)

[Sri]

Thank you very much