#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$
Apps2Fusion Articles 
Comments
I have a workflow developed in which there are few details in the workflow notification which needs to be displayed in the table format.
There is header and line level data and i have created a message in that notification which displays header level data in (using html table tags) table and line level data in separate table.
The issue is since i am not able to iterate in the HTML message body of workflow notification, it just displays one line even if there are more than one lines in line level data.
Kindly suggest a way in which iteration can be achived so that email notification displays all line level data.
Thanks,
Manjiri
RSS feed for comments to this post