Page Comparison

...

Recompiling invalids

Consider adding compileInvalidSqls operation in Deploy workflow if SQL files are being deployed. This operation can take longer if there are many invalid objects in Schema.

...

1. Give necessary rights to APPS user, so it can select on any other schema objects. For example, SELECT ANY TABLE privilege can be given to APPS and similarly other ANY type Grants can be given to APPS user.
2. Use custom schema user in FlexDeploy to create objects and grant to APPS.
   1. Create custom user and password properties on Deploy workflow to be at Environment Instance Scope. For example,
      Image RemovedImage Added
   2. Defined values for these user and password in various Environment Instance pages in Topology.
   3. Use custom properties on Project Files tab for specific Files.
      Image RemovedImage Added
3. If you want the file to populate with the correct schema user and password property attached, create the filename like "SCHEMASCHEMANAME_FILENAME.sql"
   1. e.g. SCHEMAPOS_registertrans.tbl
   2. This will automatically try to use the properties FDEBS_DB_SCHEMAPOS_USER and  FDEBS_DB_SCHEMAPOS_PASSWORD, so if using the filenames to link the schema users, follow this naming standard of the property codes.