Data objects

Data objects and their schemas:

• Objects owned by base schema-
  - Tables
  - Indexes
  - Sequences
• Objects owned by APPS schema
  - Views
  - Packages
  - Procedures
  - Functions
  - Triggers
• Custom schemas for ASC might be:
  - ASCX: General ASC Customizations
  - INFX: Permanent interfaces
  - TRNX: Interfaces that are not permanent
  - MIGX: Migration of an organization’s data into ERP - recreated for each org
  - IEXX: Invoice Engine

Grants and synonyms to APPS

• Done by Oracle for tables and sequences in standard schemas
• Done by ASC for tables and sequences in custom schemas
(currently in FARGO environment you can execute the script
$ASCX_TOP/install/db/grant_syn.sql as apps to create all
necessary grants/synonyms for prompted schema)
• Must be redone if table or sequence is re-created

Database Object Naming

• Tables ASC_XXX_TABLENAME
• Indexes ASC_TABLENAME_T# (T: U-Unique N- Non-unique )
• Sequences ASC_XXX_SEQUENCENAME_S
• Views ASC_XXX_VIEWNAME_V
• Packages ASC_XXX_PACKAGENAME_PKG
• Procedures ASC_XXX_PROCEDURENAME_PROC
• Functions ASC_XXX_FUNCTIONNAME_FCN
• Triggers ASC_TABLENAME_XYZN
  (X: B=Before A=After O= Other -Instead Of
  Y: S=Statement R= Row
  Z: I=Insert U=Update D=Delete
  N: Digit if more than 1 trigger for a type exists)
  NOTE: XXX is a 2-4 character logical grouping
  

Truncating tables as APPS: The truncate command does not utilize synonyms. Must either:
•Be in same schema as table
•Hard code schema name
•Use a function or procedure, e.g. ASC_APPS_TRUNCATE_PROC('INFX_MY_TABLE');