Home » Applications » Oracle Fusion Apps & E-Business Suite » Legacy System- Trigger-Profile Option (R12,windows)
Legacy System- Trigger-Profile Option [message #614314] Tue, 20 May 2014 15:04 Go to next message
vaibhav15211
Messages: 20
Registered: August 2012
Location: Hyderabad
Junior 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
Re: Legacy System- Trigger-Profile Option [message #614315 is a reply to message #614314] Tue, 20 May 2014 15:09 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
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');
Re: Legacy System- Trigger-Profile Option [message #614413 is a reply to message #614315] Wed, 21 May 2014 09:43 Go to previous messageGo to next message
vaibhav15211
Messages: 20
Registered: August 2012
Location: Hyderabad
Junior Member
Hello BlackSwan,

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

Thanks
Vaibhav
Re: Legacy System- Trigger-Profile Option [message #614417 is a reply to message #614413] Wed, 21 May 2014 10:00 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
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/
Re: Legacy System- Trigger-Profile Option [message #614435 is a reply to message #614417] Wed, 21 May 2014 10:34 Go to previous messageGo to next message
vaibhav15211
Messages: 20
Registered: August 2012
Location: Hyderabad
Junior 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.
Re: Legacy System- Trigger-Profile Option [message #614439 is a reply to message #614435] Wed, 21 May 2014 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Legacy System- Trigger-Profile Option [message #614447 is a reply to message #614439] Wed, 21 May 2014 10:48 Go to previous messageGo to next message
cookiemonster
Messages: 10981
Registered: September 2008
Location: Rainy Manchester
Senior Member
This is an oracle apps question isn't it?
Re: Legacy System- Trigger-Profile Option [message #614451 is a reply to message #614447] Wed, 21 May 2014 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
why do you refuse to follow Posting Guidelines?

http://www.orafaq.com/forum/mv/msg/191488/607728/#msg_607728
Re: Legacy System- Trigger-Profile Option [message #614472 is a reply to message #614447] Thu, 22 May 2014 01:09 Go to previous messageGo to next message
Littlefoot
Messages: 19648
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).
Re: Legacy System- Trigger-Profile Option [message #614475 is a reply to message #614472] Thu, 22 May 2014 02:58 Go to previous messageGo to next message
cookiemonster
Messages: 10981
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.
Re: Legacy System- Trigger-Profile Option [message #616201 is a reply to message #614475] Fri, 13 June 2014 06:58 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: Using dbms_application_info.set_client_info() in alert query
Next Topic: AP Invoice validation error
Goto Forum:
  


Current Time: Tue Sep 30 13:33:25 CDT 2014

Total time taken to generate the page: 0.12778 seconds