SQL Scripts for Custom Table Creation in Oracle Application 12.2.x

Due to introduction of Online Patching, Post 12.2.x version, there are certain steps to be followed while creating Custom Table.

1. For new table creations - after creating the table in custom schema execute below script to generate edition view and synonym for it in APPS schema.

exec AD_ZD_TABLE.UPGRADE('xxcust_schema','xxcust_Table');

2. For table alterations - after running the DDL run below script to regenerate the edition view for synchronizing any table changes.

exec AD_ZD_TABLE.PATCH('xxcust_schema','xxcust_table')

3. Table grants must be done through API to avoid invalids.

exec AD_ZD.GRANT_PRIVS('SELECT','xxcust_table,'xx_role')

4. To view objects in all editions, add "_ae" to the data dictionary views

select * from user_objects_ae;

5. To update seed data tables in Patch edition, execute prepare command.

example:
 exec ad_zd_seed.prepare('WF_MESSAGES');

 The prepare Procedure will create a edition based storage for the run edition data for which the updates will be made. During cut-over, the run time data will be synced using forward/reverse cross edition triggers.

Comments

Post a Comment

Popular posts from this blog

Oracle BI Publisher Tags For-each grouping for Matrix report

For-Each Extensions For-each tags can be confusing.  We will be going over the following tags:     For-each@ section :    For-each@ cell   For-each- group :   field1; field2;     For-each-group: current-group() ;field3;   For-each-group@ column       Sample XML:  <CORPORATION>      <NAME>Vision</NAME>     <DEPT>     <DEPT_NAME>IT</DEPT_NAME>      <EMPLOYEE>         <EMPNO>6</EMPNO>        <ENAME>Rich Walker</ENAME>        <JOB>CLERK</JOB>        <SAL>100</SAL>     </<EMPLOYEE>>     <EMPLOYEE>        ...
Read more

Messages in Oracle Application

Image
  What is a message in Oracle Application? Oracle Application uses the Message Dictionary to store translatable  Error  and  Warning  messages that can be used by any programs written in Forms, Reports, Java, or PL/SQL. These messages mainly provide information about business rule errors, such as missing or incorrect data, and how to resolve them, warn about the consequences of intended actions, inform about the status of an application, pages, or business objects, and indicate that processes and actions are performing or are completed. By using the messages in the Message Dictionary, you can define standard messages that you can use in all your applications(Oracle Form, Reports, OAF and ADF), provide consistency for messages within and across all your applications, define flexible messages, and change or translate the text of your messages without regenerating or recompiling your application code. How will you create a Message? In Application Developer Responsi...
Read more