<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Technical Articles arrow Oracle Workflows arrow WF Notification API Install
This website has now moved to http://apps2fusion.com





WF Notification API Install | Print |  E-mail
Written by Anil Passi   
Tuesday, 29 January 2008

#Assume apps password is bond77
#Assume Custom schema name is xxschema
#Assume Custom schema password is xxschema
xxdevenv:XXDEV$ load_wf_api.sh bond77 xxschema xxschema
Ensure you have passed SCRIPTNAME appsPassword XX_Schema_login XX_Schema_password
Hit enter if format is correct or else Control C to quit and try again

Connecting to sqlplus -s bes/bes
CREATE TABLE XX_NOTIFICATIONS_API

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATIONS_API_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATIONS_API_U1

Index created.

CREATE TABLE XX_NOTIFICATION_QUERIES

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATION_QUERIES_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATION_QUERIES_U1

Index created.

INDEX XX_NOTIFICATION_QUERIES_N1

Index created.

CREATE TABLE XX_NOTIFICATION_COLUMNS

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATION_COLUMNS_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATION_COLUMNS_U1

Index created.

INDEX XX_NOTIFICATION_COLUMNS_N1

Index created.

Connecting to sqlplus -s apps/m0nk3y5

Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.

PACKAGE xx_notifications_insert_pkg

Package created.

No errors.
PACKAGE BODY xx_notifications_insert_pkg

Package body created.

No errors.
PACKAGE xx_notifications_api_pkg

Package created.

PACKAGE BODY xx_notifications_api_pkg

Package body created.


Trigger created.

No errors.
Log filename    : L5681566.log


Report filename : O5681566.out
Oracle Workflow Definition Loader 2.6.4.0.

Access level: 100, Mode: FORCE

Uploaded 2 ITEM_TYPE record(s) to database.
Uploaded 38 LOOKUP_TYPE record(s) to database.
Uploaded 5 MESSAGE record(s) to database.
Uploaded 40 ACTIVITY record(s) to database.
Uploaded 0 ROLE record(s) to database.
xxdevenv:XXDEV$

Comments (0)add
You must be logged in to a comment. Please register if you do not have an account yet.

busy