Oracle APPS Account Payables Create Payment API
Hello, In this tutorial, I am going to share an unknown method for creating paymanets on Oracle EBS Account Payables. Since there isn’t any public API provided by Oracle, as developers we are investing into new methods. There is a…
Oracle EBS Service Invocation Framework (Business Events – SIF)
In this tutorial, I am going to invoke an external test web service with SIF. SIF mechanism is based on events, therefore we are going to define business events and subscriptions. After that, we can raise events in pl/sql. You…
Oracle APPS SQL Script for Profile Values
Hello, You can use the following sql script in order to find profile values
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
SELECT fpo.profile_option_name profil_adi, fpl.user_profile_option_name profil_kullanici_adi, DECODE (fpv.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User') profil_seviyesi, DECODE (fpv.level_id, 10001, 'Site', 10002, fa.application_short_name, 10003, frt.responsibility_name, 10004, fu.user_name) seviye_degeri, profile_option_value profil_degeri FROM fnd_profile_options fpo, fnd_profile_options_tl fpl, fnd_profile_option_values fpv, fnd_responsibility_tl frt, fnd_application fa, fnd_user fu WHERE fpo.profile_option_name = fpl.profile_option_name AND fpo.profile_option_id = fpv.profile_option_id AND fpv.level_value = fu.user_id(+) AND fpv.level_value = frt.responsibility_id(+) AND fpv.level_value = fa.application_id(+) AND fpl.user_profile_option_name = '<User Profile Option Name' |
Oracle Application Framework (OAF) View Object Extension
Hello, During extension developments for OAF pages, sometimes we need extra fields which are not available in standard view object. In this kind of situations, we are creating a new view object and make it extend standard view object. Please follow carefully…