OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Using dbms_application_info.set_client

Home » Applications » Oracle Fusion Apps & E-Business Suite » Using dbms_application_info.set_client_info() in alert query (11i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using dbms_application_info.set_client_info() in alert query [message #615759]

Mon, 09 June 2014 01:49

arunkrishnangs87
Messages: 4
Registered: May 2014
Location: India

Junior Member

Hi,

I need to include "dbms_application_info.set_client_info()" in the oracle alert query that I give in the select statement column while defining an alert. Without setting the org_id, no data is fetched as it have to retrieve value from view.

Regards,
Arun

Report message to a moderator

Re: Using dbms_application_info.set_client_info() in alert query [message #615761 is a reply to message #615759]

Mon, 09 June 2014 02:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Without setting the org_id, no data is fetched as it have to retrieve value from view.

What does this mean?
What is org_id?
What query?
What do you want to get (this is the purpose of a query)?
What do you expect from "dbms_application_info.set_client_info"?
What alert?
What is "oracle alert query"?

We know nothing but what you tell us.

Report message to a moderator

Re: Using dbms_application_info.set_client_info() in alert query [message #615762 is a reply to message #615759]

Mon, 09 June 2014 02:21

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Not clear what you are trying to do.

set_client_info procedure is to include additional information for a particular action. All you need to do is pass the required information enclosed in single quotes as parameter. In your context what are you doing, please post the details.

Also, in your topic title, you mentioned Oracle versiona s 11i. When was 11i released? Always it is better to post the correct and complete version details.

[Updated on: Mon, 09 June 2014 02:22]

Report message to a moderator

Re: Using dbms_application_info.set_client_info() in alert query [message #615802 is a reply to message #615762]

Mon, 09 June 2014 06:36

arunkrishnangs87
Messages: 4
Registered: May 2014
Location: India

Junior Member

Hi,
I am creating 2 oracle alerts in 11i.
The query which I have to use while creating the 2 alerts are taking data from view (APPS.OKE_K_HEADERS_FULL_V).
For both the alerts the query is same, only the organization id changes. So before querying, I have to set the organization to the correct ones.
So in SQL developer, while querying, I added
begin
dbms_application_info.set_client_info('organization id');
end;
For both the queries, only the organization will be changing in the above anonymous block.

Is there any way, I can include it in the select query itself so that the data will come.

Regards,
Arun

Report message to a moderator

Re: Using dbms_application_info.set_client_info() in alert query [message #615803 is a reply to message #615802]

Mon, 09 June 2014 06:41

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

This is an oracle apps specific question. Most of the regulars on this site don't use oracle apps so won't be able to answer. I've moved the topic to the oracle apps sub-forum so hopefully someone who knows apps will see it and answer.

Report message to a moderator

Re: Using dbms_application_info.set_client_info() in alert query [message #616196 is a reply to message #615802]

Fri, 13 June 2014 06:44

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

Is there any way, I can include it in the select query itself so that the data will come.

No you can't if you want to use the view which is having MOAC.
You may use the direct table instead of the view.

By
Vamsi

Report message to a moderator

Previous Topic:	Internal Requisition sourcing using iprocurement
Next Topic:	Legacy System- Trigger-Profile Option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:45:54 CST 2024