HOW TO create table in Oracle R12 EBS database
Edition-Based Redefinition EBR Upgrade or the R12.X.X Upgrade has very fine benefits Downtime reduction Run Edition Patch Edition Module upgrades Oracle Payments Payment acknowledgement import Sub ledger accounting Enhanced multi reporting currency functionality MOAC Multi Organization Access Control There are change in approach on table creation or database object creation. Step 1: Create a sequence in your custom schema CREATE SEQUENCE xx_YOUR_SEQUENCE_seq START WITH 1 INCREMENT BY 1 NOCACHE; Step 2: Provide Grants or Privileges from custom schema GRANT ALTER, SELECT ON XXCustom_Schema. xx_YOUR_SEQUENCE_seq TO APPS WITH GRANT OPTION; GRANT SELECT ON XXCustom_Schema. xx_YOUR_SEQUENCE_seq TO APPSRO; Step 3: Create a table in your custom schema CREATE TABLE XXCustom_Schema.XXCTS_YOUR_TABLE_TAB ( USER_ID NUMBE...