Category Archives: Apps Technical

XML Bursting from RDF

XML Publisher Bursting from RDF

Create a new Oracle Report using Oracle Report Builder using the following query:

Create new RDF as below:

Open Report Builder, Click on SQL Query in data model and enter your sql valid query.

XMLBursting001

 

Connect to database:

XMLBursting002

In the query passing two bind parameters (ORG_ID & SALES_ORDER_NUMBER) Click on ok button and the Variables are created in User Parameters Section.

XMLBursting003

XMLBursting004

XMLBursting005

Add one more mandatory parameter P_CONC_REQUEST_ID to have Trace generated after the Concurrent Program.

XMLBursting006

Save your report.

XMLBursting007

XMLBursting008

Compile the Report using Ctrl+Shift+K :

XMLBursting009

Move your report to custom top:

XMLBursting010

 

XML Bursting2

Related posts:

Workflow with Approval Notification

Creating WF Local Roles:

Adhoc roles can be created through PL/SQL from database or they can be created from Applications using User Management Responsibility. If PL/SQL is used to create roles, all user names and role names in UPPER case to avoid some errors:

Script to Create an Adhoc Role:

 Script to validate WF Roles:

 Script to Add user to an already existing Adhoc Role:

 Script to Remove user from an existing Adhoc Role:

Using Adhoc roles in workflow notifications:
Once the Roles are created in the database we can load the Roles from database as discussed from Oracle Worflow Builder as below:

Navigation: File > Load Roles from Database

Select roles you want to use and then click OK.

NEW_XAOA_NF028

NEW_XAOA_NF029

Open the notification properties and then navigate to node tab, select performer as the role you just created and loaded from database.

Modified Package Code:

Sample Code to test the workflow:

 Sample scripts to test the Workflow:

Once triggered See the below Approval Notification for either Workflow –> Notifications or directly on the screen depending on the Profile Option setup:

NEW_XAOA_NF023

Open the Notification:

NEW_XAOA_NF024

Once Approved see the Activity history or Status Diagram from Status Monitor. This can be done at any stage of the workflow once kicked off. Usually while debugging this is the first place we need to check and then check in wf tables.

NEW_XAOA_NF025

NEW_XAOA_NF026

NEW_XAOA_NF027

 

Some of the workflow tables:

WF_LOOKUP_TYPES_TL
WF_MESSAGES
WF_MESSAGE_ATTRIBUTES
WF_NOTIFICATION_ATTRIBUTES
WF_ITEM_ATTRIBUTES
WF_ITEM_ACTIVITY_STATUSES

WF_ITEM_ATTRIBUTE_VALUES

Please respond if any questions.

Related posts:

Workflow with Approval Notification

Sample workflow with Approval notification:

In the node change the Performer type to Item attribute as we intent to set the attribute value from function. We can also load the roles from database and add it here. The timeout is also important in a notification as if the user does not respond in a particular time period we can control the workflow path. The Time out can also be an item attribute.

NEW_XAOA_NF019

Drag another end so that when in the notification when user selects another result which is Reject, it should also flow till the end. Use can also use default as when there are multiple results, then other than the result mentioned in the flow rest all comes under this flow. Any can also be chosen if the workflow should also follow this path in either case.

NEW_XAOA_NF020

Validate and save the workflow in the database or on the desktop and upload it using WFLOAD.

NEW_XAOA_NF021

NEW_XAOA_NF022

Once the Workflow is saved in the database then validate using following scripts:

Next

Related posts:

Workflow with Approval Notification

Sample workflow with Approval Notification:

Create a new notification by using right click on the notifications menu in Custom workflow:

NEW_XAOA_NF010

Set the Notification properties:

NEW_XAOA_NF011

Select the Message which we have created.

Drag the item attribute to the message as we are using the item attribute in the message:

NEW_XAOA_NF012

Now edit the Main Process so to add the new Notification:

NEW_XAOA_NF013

Delete the link between existing Function and End to add the Notification in between:

NEW_XAOA_NF014

NEW_XAOA_NF015

Form a link between Function and notification:

NEW_XAOA_NF016

Now when creating the link between Notification and end, The workflow asks for the result type based upon the Result selected in the workflow notification. If the result of the notification is custom lookup it prompts for the custom lookup values in the lookup:

NEW_XAOA_NF017

Edit the properties of the Notification to add the performer:

NEW_XAOA_NF018

Next

Related posts:

Workflow with Approval Notification

Sample Oracle workflow with an Approval Notification:

Open the existing workflow which is created earlier from the database or by using WFLOAD:

NEW_XAOA_NF001

Save the file on the desktop:

NEW_XAOA_NF002

Once the workflow file is saved on the desktop, Now we will be modifying that wft.

The target is to send an email notification to one person using Oracle workflow.

For this as step one we are creating an Item Attribute which is similar to a Global Variable in a PLSQL Package. There are different types of item attributes like Text, number, date, lookup, form, url, document, role, attribute and event. Here we are selecting a text. We can even go for a Role type but then we need to create a role and assign it then to the attribute.

NEW_XAOA_NF003

Set the item attribute properties:

NEW_XAOA_NF004

Once the attribute is created then create a new message which needs to be send in the notification.

NEW_XAOA_NF005

Set the properties of the new message:

NEW_XAOA_NF006

In the body the actual email notification Body and in the subject the email notification subject goes in. We can also modify using html body if we need to enter the data in tables with different color coding, .etc. Here in the message body we have appended the Item attribute just for reference on how to add item attributes which change dynamically in the workflow.

NEW_XAOA_NF007

As we are using standard Approve/Reject notification we are selecting an existing lookup. Else if we want to create a new, we can always create a new lookup with its values and use it here.

NEW_XAOA_NF008

Add the display name and description which are mandatory.

NEW_XAOA_NF009

Next

Related posts: