Home » Applications » Oracle Fusion Apps & E-Business Suite » The PL/SQL procedure that generates a PL/SQL document
The PL/SQL procedure that generates a PL/SQL document [message #170512] Thu, 04 May 2006 02:52 Go to next message
ying
Messages: 143
Registered: May 2002
Senior Member
Hi,

I have been trying to generate a PL/SQL document and I have define an atribute of type Document so that the document is embedded inside an HTML representation of the notification as viewed from the Notification Web page, or the HTML
attachment to an e–mail message.

As refer to the Oracle Workflow Developer Guide, the standard API for generating the PL/SQL is as below:

procedure <procedure name>
(document_id in varchar2,
display_type in varchar2,
document in out varchar2,
document_type in out varchar2)

Question No 1.
But, I'm confused with the example given as mentioned below:
*************************************************************
For example, the following string represents the PL/SQL
document, po_req:2034, generated by the procedure
po_wf.show_req.

plsql:po_wf.show_req/po_req:2034
**************************************************************
To me it should be plsql:po_wf.show_req/docid001:text/html
as base on the standard API, it requires argument document_id and display_type, please advise.

Question No 2.
I tried to create my own procedure for generating PL/SQL document as per attachment and in my workflow process, I have an document type attribute which the value is pl/sql:CY_DOCUMENT.INFOR_A/doc_p:ch006

When I run the process, I get error message in my notification as below:

Error
3402: No valid session exists for this user. Please establish a new session through the login page.
Error Name: WFSEC_NO_SESSION
Error Stack:
Wf_Notification.GetAttrText(175564, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(175564, #ATTACHMENTS)
Wf_Notification.GetAttrText(175564, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(175564, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(175564, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178425, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178425, #ATTACHMENTS)
Wf_Notification.GetAttrText(178425, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(178425, #WF_SIG_POLICY)
Wf_Notification.GetAttrText(178425, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178973, #WF_PROXIED_VIA)
Wf_Notification.GetAttrText(178973, #ATTACHMENTS)
Wfa_Sec.GetSession()
fnd_document_management.get_launch_document_url(pl/sql:CY_DOCUMENT.INFOR_A/doc_p:ch007)
Wf_Notification.GetAttrDoc(178973, MYDOCUMENT, text/html)


pls advise...
Re: The PL/SQL procedure that generates a PL/SQL document [message #170779 is a reply to message #170512] Fri, 05 May 2006 02:37 Go to previous messageGo to next message
ying
Messages: 143
Registered: May 2002
Senior Member
Just wonder, why no reply this topic, I really stuck....
Re: The PL/SQL procedure that generates a PL/SQL document [message #177899 is a reply to message #170779] Sat, 17 June 2006 10:38 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Question No 1:
Developer's Guide says default value should be:
plsql:<procedure>/<document identifier>
-> <document identifier> should identify the document.
For me you can pass any value but it is better to pass like in the example the name of the item type and the item key.
Question No 2:
Did you check your message attribute ? Try with these parameters
Type: Document
Source: Send
Frame Target: New Window
Attach Content: Checked
Re: The PL/SQL procedure that generates a PL/SQL document [message #177971 is a reply to message #170512] Sun, 18 June 2006 20:20 Go to previous messageGo to next message
ying
Messages: 143
Registered: May 2002
Senior Member
Thanks for your reply, I have managed to solve my problem.
Re: The PL/SQL procedure that generates a PL/SQL document [message #418533 is a reply to message #177971] Mon, 17 August 2009 01:47 Go to previous messageGo to next message
mikemacm
Messages: 1
Registered: August 2009
Junior Member
Hi Ying
I know this was a couple of years ago, but how did you manage to solve your problem?
Thanks

Mike Confused
Re: The PL/SQL procedure that generates a PL/SQL document [message #418536 is a reply to message #418533] Mon, 17 August 2009 02:14 Go to previous message
ying
Messages: 143
Registered: May 2002
Senior Member
Hi Mike,

I try to recall, but not sure it is correct or not.
Mty experience was that, if we make any changes on the package which use for generating the "document", it requires to re-start the server in order to get the "changes" to be reflected.

Ying.
Previous Topic: pmp course
Next Topic: Error while creating customers on sales pages (merged 4) Oracle e-business suite---CRM Sales
Goto Forum:
  


Current Time: Fri Dec 09 23:20:32 CST 2016

Total time taken to generate the page: 0.08578 seconds