OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Legacy System- Trigger-Profile Option

Home » Applications » Oracle Fusion Apps & E-Business Suite » Legacy System- Trigger-Profile Option (R12,windows)

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

Legacy System- Trigger-Profile Option [message #614314]

Tue, 20 May 2014 15:04

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello,

I am working on a interface on which I need an input.
The Legacy system inserts the data into a custom table INV_UPDATE_TBL in oracle system and a trigger INV_INSERT_TRG is fired. In this trigger I am using the following query.

SELECT FND_PROFILE.VALUE('org_id') into v_org_id from dual;

to pick the org id but I am not sure if this will work or not as the instance has not come into action and thus the profile options are not set.

Please suggest.

I don't have the option to run and test as client interaction is required to do the testing, so I want to know beforehand if I fnd_profile.value will be able to pick the value of ORG_ID, and if yes then how?

Thanks,
Vaibhav

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614315 is a reply to message #614314]

Tue, 20 May 2014 15:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SELECT FND_PROFILE.VALUE('org_id') into v_org_id from dual;
not as above but as below
V_ORG_ID := FND_PROFILE.VALUE('org_id');

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614413 is a reply to message #614315]

Wed, 21 May 2014 09:43

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello BlackSwan,

Thanks for your prompt reply. But the solution provided is not working.

Thanks
Vaibhav

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614417 is a reply to message #614413]

Wed, 21 May 2014 10:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

see a picture of my car which is not working.
Tell me how to make my car go.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614435 is a reply to message #614417]

Wed, 21 May 2014 10:34

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Instead of being sarcastic if you would have provided a solution, it would have been great.
But it seems your seniority has given you only arrogance and nothing else, because it is not the first time with me nor the first time on forum that you have given this kind of reply.

Any human can tell by seeing the picture that the car won't move without wheels. As far as your car is concerned, I don't think it will work because except engine it needs a driver with a head also.

Thanks for not helping out as always.

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614439 is a reply to message #614435]

Wed, 21 May 2014 10:39

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

Senior Member
Account Moderator

To specify what BlackSwan said is the you don't even post a picture of your car.

Quote:

I am not sure if this will work or not as the instance has not come into action and thus the profile options are not set.

This is completely meaningless from the point of view of Oracle database/instance and SQL or PL/SQL. If the instance is not there then you cannot execute anything in the database.
Note you posted this in SQL & PL/SQL forum.

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614447 is a reply to message #614439]

Wed, 21 May 2014 10:48

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

Senior Member

This is an oracle apps question isn't it?

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614451 is a reply to message #614447]

Wed, 21 May 2014 12:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

why do you refuse to follow Posting Guidelines?

http://www.orafaq.com/forum/mv/msg/191488/607728/#msg_607728

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614472 is a reply to message #614447]

Thu, 22 May 2014 01:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

cookiemonster wrote on Wed, 21 May 2014 17:48

This is an oracle apps question isn't it?

I'd say it is, "FND_PROFILE" sounds like that. Release 12 (as stated in topic information line).

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #614475 is a reply to message #614472]

Thu, 22 May 2014 02:58

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

Senior Member

@vaibhav15211 - there are sub-forums here for oracle apps questions.
Most oracle professionals don't use oracle apps or know anything about it, which is why no-one understands your question.
Me and Littlefoot know enough to recognize apps questions sometimes, but not enough to provide answers.
I'm moving this to appropriate forum so hopefully someone who actually knows about apps will see it.

Report message to a moderator

Re: Legacy System- Trigger-Profile Option [message #616201 is a reply to message #614475]

Fri, 13 June 2014 06:58

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

Senior Member

Unless the profile is set as Site level, you need to use fnd_global.apps_initiate to get the value.
Check the link.

By
Vamsi

Report message to a moderator

Previous Topic:	Using dbms_application_info.set_client_info() in alert query
Next Topic:	Import Dff values is No by default

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 15:01:49 CST 2024