Good link covering notifications in depth.
Click here
Wednesday, December 23, 2009
XML Data : loading xml data into xml table and retrieving the same
LOAD DATA
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))
create table abc (a xmltype)
select * from abc
insert into abc values (xmltype('234tt '))
select extractvalue(a,'/st/b') "aaa" from abc
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))
create table abc (a xmltype)
select * from abc
insert into abc values (xmltype('
select extractvalue(a,'/st/b') "aaa" from abc
Workflow Notification Mailer Attributes
You can use special message attributes to control how a notification
mailer generates the e–mail message for a notification, if the recipient
has a notification preference to receive e–mail notifications. For
example, if you want to customize notifications from a particular
department, you can define these attributes for those notifications.
• #WFM_FROM – Define this attribute for a message to specify the
value that appears in the From field of the message header when
the e–mail notification message is delivered to a user. If the
#WFM_FROM message attribute is defined for a notification, the
notification mailer that sends the message will use the
#WFM_FROM attribute value in the From field for that message,
overriding the mailer’s From Address parameter value.
• #WFM_REPLYTO – Define this attribute for a message to specify
the address of the e–mail account that receives incoming
messages, to the which e–mail notification response should be
sent. If the #WFM_REPLYTO message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_REPLYTO attribute value as the reply address for
that message, overriding the mailer’s Reply To parameter value.
• #WFM_HTMLAGENT – Define this attribute for a message to
specify the base URL that identifies the HTML web agent that
handles HTML notification responses. This URL is required to
support e–mail notifications with HTML attachments. The
default URL is derived from the Workflow Web Agent specified
in the Global Preferences web page, but you can override this
default by defining a different value for this attribute. If the
#WFM_HTMLAGENT message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_HTMLAGENT attribute value as the HTML web
agent for that message, overriding the mailer’s HTML Agent
parameter value.
mailer generates the e–mail message for a notification, if the recipient
has a notification preference to receive e–mail notifications. For
example, if you want to customize notifications from a particular
department, you can define these attributes for those notifications.
• #WFM_FROM – Define this attribute for a message to specify the
value that appears in the From field of the message header when
the e–mail notification message is delivered to a user. If the
#WFM_FROM message attribute is defined for a notification, the
notification mailer that sends the message will use the
#WFM_FROM attribute value in the From field for that message,
overriding the mailer’s From Address parameter value.
• #WFM_REPLYTO – Define this attribute for a message to specify
the address of the e–mail account that receives incoming
messages, to the which e–mail notification response should be
sent. If the #WFM_REPLYTO message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_REPLYTO attribute value as the reply address for
that message, overriding the mailer’s Reply To parameter value.
• #WFM_HTMLAGENT – Define this attribute for a message to
specify the base URL that identifies the HTML web agent that
handles HTML notification responses. This URL is required to
support e–mail notifications with HTML attachments. The
default URL is derived from the Workflow Web Agent specified
in the Global Preferences web page, but you can override this
default by defining a different value for this attribute. If the
#WFM_HTMLAGENT message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_HTMLAGENT attribute value as the HTML web
agent for that message, overriding the mailer’s HTML Agent
parameter value.
Tuesday, December 15, 2009
Oracle API's
1. API for updating organization Attributes. It updates mtl attributes that are specific to org and that do not exist in template.
Ego_Item_Pub.Process_Items();
2. API to assign Items to different organizations.
EGO_ITEM_PUB.Assign_Item_To_Org();
3. API for creation of OPM Items
Gmipapi.Create_Item();
4. API to create OPM Lot.
Gmipapi.Create_Lot();
Ego_Item_Pub.Process_Items();
2. API to assign Items to different organizations.
EGO_ITEM_PUB.Assign_Item_To_Org();
3. API for creation of OPM Items
Gmipapi.Create_Item();
4. API to create OPM Lot.
Gmipapi.Create_Lot();
Some Metalink notes for Diagnosing Module wise Workflow error
Running WFSTATUS and WFRETRY For Oracle Purchasing Workflows [ID 134960.1]
Thursday, December 3, 2009
How to provide drop down list in a notification message
Requirement might be select a reason for rejection from the given drop down list when rejecting the notification. in such case the attribute attached to the notification message must be defined with source as respond and the Type as Lookup and attach the lookup type to the same attribute.
For further details and tested example please click here
For further details and tested example please click here
Friday, November 20, 2009
Cache Clearing Technique
When you assign a new responsibility and it does
not show up for a long time, you can manually flush the
mid-tier cache.
Responsibility = Functional Administration
Core Services : Caching Framework : Clear All Cache
• This also resolves other issues related to lookups, profile options,
etc (basically any data that is cached by the Apps Tier)
not show up for a long time, you can manually flush the
mid-tier cache.
Responsibility = Functional Administration
Core Services : Caching Framework : Clear All Cache
• This also resolves other issues related to lookups, profile options,
etc (basically any data that is cached by the Apps Tier)
Current Workflow Functionality
• Oracle Workflow Best Practices
Release 12 and Release 11i
Metalink Note: 453137.1
Current – Recent Releases
• Metalink Note: 464727.1
Oracle Workflow Documentation Updates for
11i.ATG_PF.H.delta.7 (RUP 7)
• Metalink Note:737857.1
Oracle Workflow Documentation Updates for Release
12.0.6
• Metalink Note: 565731.1
Oracle Workflow Release Notes, Release 12.1.1
• ATG, RUP6, MetaLink Note: 760386.1
How to enable Bulk Notification Response Processing
for Workflow in 11i
• This feature allows users to respond to multiple
notifications with a similar response.
• ATG RUP 7, adds the ability to include a PL/SQL
Document Attribute in your notification subject line.
• This is really helpful if having to deal with translations in
emails.
ATG RUP 7, There is now a PL/SQL API call to allow a
message to be sent via email that does not have to be
associated with a Workflow Item Type/Key.
• Sends a message to be dispatched through e-mail by a
notification mailer.
• The message content and recipients provided in the
parameters do not need to be associated with any
workflow process or directory service roles.
• The message content must be complete, preformatted,
and email-ready, and should conform to the content type
specified.
Use the ‘Workflow Directory Services
User/Role Validation’ concurrent program
(FNDWFDSURV) to validate and correct the
information about user/role associations.
Also when you assign a new responsibility and it does
not show up for a long time, you can manually flush the
mid-tier cache.
Responsibility = Functional Administration
Core Services : Caching Framework : Clear All Cache
• This also resolves other issues related to lookups, profile options,
etc (basically any data that is cached by the Apps Tier)
Release 12 and Release 11i
Metalink Note: 453137.1
Current – Recent Releases
• Metalink Note: 464727.1
Oracle Workflow Documentation Updates for
11i.ATG_PF.H.delta.7 (RUP 7)
• Metalink Note:737857.1
Oracle Workflow Documentation Updates for Release
12.0.6
• Metalink Note: 565731.1
Oracle Workflow Release Notes, Release 12.1.1
• ATG, RUP6, MetaLink Note: 760386.1
How to enable Bulk Notification Response Processing
for Workflow in 11i
• This feature allows users to respond to multiple
notifications with a similar response.
• ATG RUP 7, adds the ability to include a PL/SQL
Document Attribute in your notification subject line.
• This is really helpful if having to deal with translations in
emails.
ATG RUP 7, There is now a PL/SQL API call to allow a
message to be sent via email that does not have to be
associated with a Workflow Item Type/Key.
• Sends a message to be dispatched through e-mail by a
notification mailer.
• The message content and recipients provided in the
parameters do not need to be associated with any
workflow process or directory service roles.
• The message content must be complete, preformatted,
and email-ready, and should conform to the content type
specified.
Use the ‘Workflow Directory Services
User/Role Validation’ concurrent program
(FNDWFDSURV) to validate and correct the
information about user/role associations.
Also when you assign a new responsibility and it does
not show up for a long time, you can manually flush the
mid-tier cache.
Responsibility = Functional Administration
Core Services : Caching Framework : Clear All Cache
• This also resolves other issues related to lookups, profile options,
etc (basically any data that is cached by the Apps Tier)
Workflow to BPEL Migration
A good reference on migrating to BPEL is:
Migrating to BPEL from Oracle Work Flow
An Oracle White Paper
March 2008
Migrating to BPEL from Oracle Work Flow
An Oracle White Paper
March 2008
Account Generator Workflows
Inventory COGS Account Generator
Item Type = INVFLXWF
Display Name = ‘Inventory Cost of Goods Sold Account’
Run by the concurrent program ‘Create Intercompany AP Invoices’, short name INCIAP
OM COGS Account Generator
Item Type = OECOGS
Display Name = ‘OM : Generate Cost of Goods Sold Account’
Run by the concurrent program ‘Interface Trip Stop’, short name WSHINTERFACE
To Debug change the said profiles
Account Generator:Purge Runtime Data = No
Account Generator:Run in Debug Mode = Yes
Item Type = INVFLXWF
Display Name = ‘Inventory Cost of Goods Sold Account’
Run by the concurrent program ‘Create Intercompany AP Invoices’, short name INCIAP
OM COGS Account Generator
Item Type = OECOGS
Display Name = ‘OM : Generate Cost of Goods Sold Account’
Run by the concurrent program ‘Interface Trip Stop’, short name WSHINTERFACE
To Debug change the said profiles
Account Generator:Purge Runtime Data = No
Account Generator:Run in Debug Mode = Yes
Some learnings in Oracle Workflow Notification
Message Templates : Oracle comes seeded with Message templates in the System: Mailer Item type (WFMAIL). If there are any extra messages that comes in the notification apart from that mentioned in the message body, the same comes from the Message template.
Points to note
1. Do not modify Oracle Supplied Message templates
2. One can add new custom Message templates in the Item Type System: Mailer or in your own Item Type.
To reference the Custom Message Template
1. Create a message attribute by name "#WFM_OPEN_MAIL_FYI" under the message which has your information.
2. The value much have the template message given in format- :
Message Attirbutes : Allow you to modify fetures of Workflow notification, without having to create seperate workflow mailers. Various Special Message attributes like few given below
#WFM_FROM - Change the from email address in notification
#WFM_REPLYTO - Changes the Reply To Email
Document Message Attribute : Allow you to build a message body from a query. These type of attribute references PL/SQL procedures to build a text stream.
Document Attributes Values plsql:/
procedure = PL/SQL Procedure
document_identifier = usually a concatenation of ITEM_TYPE:ITEM_KEY
example
apps.wf_engine.setitemattrdocument
(itemtype => 'WWAPAPR',
itemkey => l_curval,
aname => 'WW_OUTPUT_ATTACH',
documentid => 'PLSQLBLOB:ww_ap_pay_approval_wf_pkg.ww_set_ntf_attr/'
|| TO_CHAR (g_request_id)
);
PROCEDURE ww_set_ntf_attr (
document_id IN VARCHAR2,
display_type IN VARCHAR2,
document IN OUT BLOB,
document_type IN OUT VARCHAR2
)
document_id has the value passed from g_request_id
Workflow messages are not versioned and so any addition in the message attributes will effect the immediatly running notifications.
Workflow Notification Testing
1. Modify the Workflow Mailer Configuration using OAM
2. Enter an email address for the Test Address
Further reference
http://www.jrpjr.com
http://www.norcaloaug.org
Points to note
1. Do not modify Oracle Supplied Message templates
2. One can add new custom Message templates in the Item Type System: Mailer or in your own Item Type.
To reference the Custom Message Template
1. Create a message attribute by name "#WFM_OPEN_MAIL_FYI" under the message which has your information.
2. The value much have the template message given in format
Message Attirbutes : Allow you to modify fetures of Workflow notification, without having to create seperate workflow mailers. Various Special Message attributes like few given below
#WFM_FROM - Change the from email address in notification
#WFM_REPLYTO - Changes the Reply To Email
Document Message Attribute : Allow you to build a message body from a query. These type of attribute references PL/SQL procedures to build a text stream.
Document Attributes Values plsql:
procedure = PL/SQL Procedure
document_identifier = usually a concatenation of ITEM_TYPE:ITEM_KEY
example
apps.wf_engine.setitemattrdocument
(itemtype => 'WWAPAPR',
itemkey => l_curval,
aname => 'WW_OUTPUT_ATTACH',
documentid => 'PLSQLBLOB:ww_ap_pay_approval_wf_pkg.ww_set_ntf_attr/'
|| TO_CHAR (g_request_id)
);
PROCEDURE ww_set_ntf_attr (
document_id IN VARCHAR2,
display_type IN VARCHAR2,
document IN OUT BLOB,
document_type IN OUT VARCHAR2
)
document_id has the value passed from g_request_id
Workflow messages are not versioned and so any addition in the message attributes will effect the immediatly running notifications.
Workflow Notification Testing
1. Modify the Workflow Mailer Configuration using OAM
2. Enter an email address for the Test Address
Further reference
http://www.jrpjr.com
http://www.norcaloaug.org
Friday, November 6, 2009
How to Submit A XML Publisher Report from Script
Follow the steps to Submit A XML Publisher Report from Script
1. Select and assign the layout before submitting the request as below.
l_attached := fnd_request.add_layout ( template_appl_name => 'XXXX'
,template_code => 'MFG_LABEL_PRN'
,template_language => 'US'
,template_territory => 'en'
,output_format => 'PDF'
);
2. Call the Submit_Request API next.
ln_req_id := fnd_request.submit_request (
'mfg', 'MFG_LABEL_PRN ', 'MFG Label', TO_CHAR(SYSDATE), TRUE);
1. Select and assign the layout before submitting the request as below.
l_attached := fnd_request.add_layout ( template_appl_name => 'XXXX'
,template_code => 'MFG_LABEL_PRN'
,template_language => 'US'
,template_territory => 'en'
,output_format => 'PDF'
);
2. Call the Submit_Request API next.
ln_req_id := fnd_request.submit_request (
'mfg', 'MFG_LABEL_PRN ', 'MFG Label', TO_CHAR(SYSDATE), TRUE);
Thursday, November 5, 2009
How to call a Java Stored Procedure from PL/SQL Procedure
Below is an example to call a Java Stored Procedure from PL/SQL Procedure
1. Define a Java Stored Stored procedure as below in the database.
DROP JAVA SOURCE APPS."DirList";
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED apps."DirList" AS import java.io.*;
import java.sql.*;
public class dirlist
{
public static void getlist(string directory)
throws sqlexception
{
try
{
file path = new file( directory );
string[] list = path.list();
string element;
for(int i = 0; i < list.length; i++)
{
element = list[i];
#sql { insert into xx_dir_list (filename)
values (:element) };
} catch (exception e);
{
system.out.ptintln(e.getmeaasage);
}
}
}
}
2. Call the above Java Stored Stored procedure "DirList" from the PL/SQL Procedure as follows.
CREATE OR REPLACE PROCEDURE APPS.get_dir_list (p_directory IN VARCHAR2)
AS
LANGUAGE JAVA
NAME 'DirList.getList( java.lang.String )';
/
1. Define a Java Stored Stored procedure as below in the database.
DROP JAVA SOURCE APPS."DirList";
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED apps."DirList" AS import java.io.*;
import java.sql.*;
public class dirlist
{
public static void getlist(string directory)
throws sqlexception
{
try
{
file path = new file( directory );
string[] list = path.list();
string element;
for(int i = 0; i < list.length; i++)
{
element = list[i];
#sql { insert into xx_dir_list (filename)
values (:element) };
} catch (exception e);
{
system.out.ptintln(e.getmeaasage);
}
}
}
}
2. Call the above Java Stored Stored procedure "DirList" from the PL/SQL Procedure as follows.
CREATE OR REPLACE PROCEDURE APPS.get_dir_list (p_directory IN VARCHAR2)
AS
LANGUAGE JAVA
NAME 'DirList.getList( java.lang.String )';
/
Monday, October 12, 2009
Friday, August 28, 2009
How to Enable "About the Page" in Oracle Application?
In order to enable "About the Page" in Oracle Application following profile needs to be set to Yes.
Profile name : "FND: Diagonistics"
Better try setting the above profile from Functional Administrator.
Profile name : "FND: Diagonistics"
Better try setting the above profile from Functional Administrator.
Sunday, August 23, 2009
Some basics about OAF
1. On click of a button, Process Form Request is executed.
2. Process Request is similar to When-New-Form Trigger in Oracle Form
3. OA Page is loaded using XML Importer
4. In the method processFormRequest of the Controller, you can access the values of the page by using notation pageContext.getParameter("")
5. Application Module is like a connection manager which maintains state of the application.
6. Inside the controller, all the Database Related interactions for example interaction with View Objects happens via Application Module.
OAApplicationModuleImpl oaapplicationmoduleimpl = (OAApplicationModuleImpl)oapagecontext.getApplicationModule(oawebbean);
OADBTransaction oadbtransaction = (OADBTransaction)oaapplicationmoduleimpl.getDBTransaction();
7. processFormRequest
This method is commonly used to react/respond to the event that has taken place, for example click of a button.
8. processRequest
In this method, usually page rendering related code is written. Effectively, each GUI component is a bean that gets initialised duringprocessRequest.
As a start up, identify the VO associated to ur page by using "About this page" link which is enabled through a profile value. Then download all the files from the $JAVA_TOP/oracle/apps//.... to ur local drive.
1. Create a new project and set the classpath of the project to the downloaded files above.
2. Extend the standard VO identified above and change the query associated with it & create a new VO.
3. Use substitutions to replace the original VO with the extended VO.
4. Migrate ur files to the apps server.
2. Process Request is similar to When-New-Form Trigger in Oracle Form
3. OA Page is loaded using XML Importer
4. In the method processFormRequest of the Controller, you can access the values of the page by using notation pageContext.getParameter("
5. Application Module is like a connection manager which maintains state of the application.
6. Inside the controller, all the Database Related interactions for example interaction with View Objects happens via Application Module.
OAApplicationModuleImpl oaapplicationmoduleimpl = (OAApplicationModuleImpl)oapagecontext.getApplicationModule(oawebbean);
OADBTransaction oadbtransaction = (OADBTransaction)oaapplicationmoduleimpl.getDBTransaction();
7. processFormRequest
This method is commonly used to react/respond to the event that has taken place, for example click of a button.
8. processRequest
In this method, usually page rendering related code is written. Effectively, each GUI component is a bean that gets initialised duringprocessRequest.
As a start up, identify the VO associated to ur page by using "About this page" link which is enabled through a profile value. Then download all the files from the $JAVA_TOP/oracle/apps//.... to ur local drive.
1. Create a new project and set the classpath of the project to the downloaded files above.
2. Extend the standard VO identified above and change the query associated with it & create a new VO.
3. Use substitutions to replace the original VO with the extended VO.
4. Migrate ur files to the apps server.
How to Enable Personalization link for OAF Pages?
Click here to know how to enable Personalize Page.
ENABLE PERSONALIZATION
Set the value for following profiles
“FND: Personalization Region Link Enabled” to Yes (Minimal will also do but better to set Yes so that you get personalization links for all the regions)
“Personalize Self-Service Defn” to Yes
“Disable Self-Service Personal” to No
ENABLE PERSONALIZATION
Set the value for following profiles
“FND: Personalization Region Link Enabled” to Yes (Minimal will also do but better to set Yes so that you get personalization links for all the regions)
“Personalize Self-Service Defn” to Yes
“Disable Self-Service Personal” to No
Thursday, July 9, 2009
SQL operators New for Oracle10g
IS NAN : New for Oracle10g. Matches the NaN special value, which means "not a number"
IS INFINITE : New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values
You can also use the NOT operator to reverse the meaning
IS NOT NAN
IS NOT INFINITE
IS INFINITE : New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values
You can also use the NOT operator to reverse the meaning
IS NOT NAN
IS NOT INFINITE
How do you disable all the OA Framework personalizations in eBusiness Suite?
All the personalizations done to the system can be disabled by simply setting a profile option to Yes at site level.
Name of this profile option is Disable Self-Service Personal
Note:- You can de-activate personalizations against individual pages selectively, by clicking on button "Manage Personalizations". You may need to give yourself access to responsibility named "Functional Administrator", so that you can disable personalizations selectively.
Name of this profile option is Disable Self-Service Personal
Note:- You can de-activate personalizations against individual pages selectively, by clicking on button "Manage Personalizations". You may need to give yourself access to responsibility named "Functional Administrator", so that you can disable personalizations selectively.
Monday, June 29, 2009
How to find XML Publisher Version
Two ways to find XML Publisher versions.
Easy Way : After the output of the report is generated, open the output document file. Go to properties and the version will be visible at that point.
Harder Way : Log in to the server and open for the file MetaInfo.class using more command. This file is available at the following location :
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class
Easy Way : After the output of the report is generated, open the output document file. Go to properties and the version will be visible at that point.
Harder Way : Log in to the server and open for the file MetaInfo.class using more command. This file is available at the following location :
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class
Wednesday, June 3, 2009
Sunday, May 24, 2009
Thursday, May 21, 2009
Oracle Workflows Access Protection Concepts
Here is some thing one should make a note of before customizing any standard workflows.
Oracle Workflows Access Protection Concepts
Oracle Workflows Access Protection Concepts
Bulk updating workflow users
Such requirement comes in case when set of users needs their notification preference to be changed. Check out the below link for the solution
Bulk updating workflow users
Bulk updating workflow users
Simple Query to generate XML output
1. SELECT SYS_XMLAGG (SYS_XMLGEN (order_number), SYS.xmlgenformattype.createformat ('OE_ORDER_HEADERS_ALL')).getstringval () AS xml_row
FROM oe_order_headers_all
WHERE ROWNUM < 6
2. SELECT SYS_XMLAgg(
SYS_XMLGen(
TABLE(OE_ORDER_HEADERS_ALL, APPS_TS_TX_DATA),
sys.xmlgenformatType.createFormat('TABLE')
),
sys.xmlgenformatType.createFormat('USER_TABLES')
).getStringVal() AS xml_row
FROM user_tables
WHERE rownum < 6;
3. select sys_XMLAgg(xmlforest(header_id, order_number),sys.xmlgenformatType.createFormat('order')).getStringVal() AS xml_row from oe_order_headers_all
WHERE rownum < 6
4. SELECT XMLAgg(
XMLELEMENT
(header_id , order_number
)
).getStringVal() AS xml_row
FROM oe_order_headers_all
WHERE rownum < 6
FROM oe_order_headers_all
WHERE ROWNUM < 6
2. SELECT SYS_XMLAgg(
SYS_XMLGen(
TABLE(OE_ORDER_HEADERS_ALL, APPS_TS_TX_DATA),
sys.xmlgenformatType.createFormat('TABLE')
),
sys.xmlgenformatType.createFormat('USER_TABLES')
).getStringVal() AS xml_row
FROM user_tables
WHERE rownum < 6;
3. select sys_XMLAgg(xmlforest(header_id, order_number),sys.xmlgenformatType.createFormat('order')).getStringVal() AS xml_row from oe_order_headers_all
WHERE rownum < 6
4. SELECT XMLAgg(
XMLELEMENT
(header_id , order_number
)
).getStringVal() AS xml_row
FROM oe_order_headers_all
WHERE rownum < 6
How to make parameters conditionally mandatory or non mandatory from Concurrent Program Application
1. Create first value set with None Validation
Ex : Start Date (Parameter)
Create Second value set( End Date) with Special Validation
Click on Edit Information
Select event type as validate.
Paste the following code.
FND PLSQL "BEGIN
if ':$FLEX$.XXDB_START_DATE_VS' is null then
NULL;
end if;
END;"
The above code returns false if parameter 1 is null .
If parameter 1 is not null then second parameter get enable.
Attach this two value sets to start date and end date parameters
Ex : Start Date (Parameter)
Create Second value set( End Date) with Special Validation
Click on Edit Information
Select event type as validate.
Paste the following code.
FND PLSQL "BEGIN
if ':$FLEX$.XXDB_START_DATE_VS' is null then
NULL;
end if;
END;"
The above code returns false if parameter 1 is null .
If parameter 1 is not null then second parameter get enable.
Attach this two value sets to start date and end date parameters
How to trace back Workflow notification history?
1 CREATE OR REPLACE FUNCTION get_hist ( p_nid IN PLS_INTEGER
2 , p_disp_type IN VARCHAR2 DEFAULT WF_NOTIFICATION.doc_text ) RETURN VARCHAR2 AS
3 v_hist VARCHAR2(32767);
4 BEGIN
5 Wf_Notification.GetComments2 ( p_nid => p_nid
6 , p_display_type => NVL(p_disp_type,WF_NOTIFICATION.doc_text)
7 , p_hide_reassign => 'Y'
8 , p_hide_requestinfo => 'Y'
9 , p_action_history => v_hist );
10
11 RETURN v_hist;
12
13 END get_hist;
14*
APPS@SOLDEV2 on 18-SEP-2008 10:43:34> select get_hist(1574024) from dual;
GET_HIST(1574024)
————————————————————————————————————————
Action History
Num : Action Date : Action : From : To : Details
1 : 17-JUL-2008 12:03:45 : Submit : SYSADMIN : Searle, Matthew :
2 : 18-SEP-2008 10:21:00 : Request Information : Searle, Matthew : SEARLEM4B : Hello
--------------------------------------------------------------------------------
2 , p_disp_type IN VARCHAR2 DEFAULT WF_NOTIFICATION.doc_text ) RETURN VARCHAR2 AS
3 v_hist VARCHAR2(32767);
4 BEGIN
5 Wf_Notification.GetComments2 ( p_nid => p_nid
6 , p_display_type => NVL(p_disp_type,WF_NOTIFICATION.doc_text)
7 , p_hide_reassign => 'Y'
8 , p_hide_requestinfo => 'Y'
9 , p_action_history => v_hist );
10
11 RETURN v_hist;
12
13 END get_hist;
14*
APPS@SOLDEV2 on 18-SEP-2008 10:43:34> select get_hist(1574024) from dual;
GET_HIST(1574024)
————————————————————————————————————————
Action History
Num : Action Date : Action : From : To : Details
1 : 17-JUL-2008 12:03:45 : Submit : SYSADMIN : Searle, Matthew :
2 : 18-SEP-2008 10:21:00 : Request Information : Searle, Matthew : SEARLEM4B : Hello
--------------------------------------------------------------------------------
Looking for a ground to play with Oracle Application?
Solution Beacon have a few 11i and R12 eBusiness Suite systems running, that you can play about in - they refresh them periodically, and there’s no database login, but for finding your way around Oracle Apps, it’s a good starting point - plus you don’t need to install your own sandpit area to play in!
The links to the 11i environments can be found here.
The links to the 11i environments can be found here.
Metalink Notes on Oracle Workflow
- Doc ID 47711.1 : WF 2.x: How To Create A New Workflow In Versions 2.0.3, 2.5 & 2.6
- Doc ID 214089.1 : How to Format Workflow Messages for Email Notifications received as HTML and Web Based Notifications
- Doc ID 48666.1 : Workflow FAQ
- Doc ID 115322.1 : ORACLE FIXED ASSETS Account Generator and Workflow White Paper
http://workflowsig.oaug.org/
Which version of JDeveloper to be used for OAF
How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x
Solution
To determine which patch to use, you can check the framework version in your instance by using http://host:port/OA_HTML/OAInfo.jsp, then choose the matched JDeveloper patch
To know the corresponding patch for a given framework version refer to the metalink Doc ID 416708.1
Solution
To determine which patch to use, you can check the framework version in your instance by using http://host:port/OA_HTML/OAInfo.jsp, then choose the matched JDeveloper patch
To know the corresponding patch for a given framework version refer to the metalink Doc ID 416708.1
My learnings in Oracle
This blog would mostly refer to my finding and learning in Oracle Application and its underlying technologies. I proposed to start this blog so as to help me as a quick reference in time of need. I hope I can make this a fruitfull blog to myself and to any one by chance bumps into this blog.
Subscribe to:
Posts (Atom)
