SQL & PLSQLs
SQL, PL/SQL files
Note: SQL files will be deployed in the order given in the
SQL_ORDER.seq file. If the
SQL_ORDER.seq file not available, files will be executed based on the extension of the files (
typ, tps, tpb, sql, pkh, plb, pkb, pks, pls, pck, fnc, trg, spc, bdy, prc). If you have few files in
SLQ_ORDER.seq file, those SQLs will be executed first and rest will be executed as per their extension.
Executes all files with DB user configured on environment instances properties sections (apps). Make sure you have schema qualified your objects like
CREATE TABLE XXHR.XXHR_PER_SOCIETIES ….
If you would like to execute other schema users, name the file name starting with
SCHEMAPOS_AAQ.sql and define the following properties on your Workfow:
XML files containing object definitions
For XDF files which need to be executed with Schema user, create properties at your workflow as below and provide values in Env Instance section: