Cloned Date, Version Details, URL of Oracle Applications,Cloned date of oracle application and Version Query to get Version details.. ++++++++++++++++++++++++++++++++++++ SELECT product, VERSION, status FROM product_component_version; Query to get cloned date of an oracle instance +++++++++++++++++++++++++++++++++++++++++ SELECT resetlogs_time FROM v$database; ======================== Query to get the front end URL from backend ++++++++++++++++++++++++++++++++++ SELECT home_url ...
oracle apps R12
How to remove End date of specific responsibility for specific user in oracle apps R12
posted on , by Unknown
How to remove End date of specific responsibility for specific user in oracle apps R12 If you want to remove end date for particular user say user ABC and want to have access to that responsibility then run below script in back-end(plsql window) to get access to required responsibility : {**Note-you need to have APPS access to run below script} DECLARE p_user_name VARCHAR2 (50) := 'ABC'; p_resp_name VARCHAR2 (50) := 'Responsibility_Name'; v_user_id NUMBER (10) := 0; v_responsibility_id ...
Workflow Email Override oracle apps R12 If you are testing with for alert.Sending email to required user then you need to enter your email in workflow mailer then and then only you will get email.Also just updating and changing email address wont work until and unless you run below script from backed and commit the changes. --workflow email override BEGIN FND_SVC_COMP_PARAM_VALS_PKG.LOAD_ROW ( x_component_name => 'Workflow Notification Mailer', x_parameter_name => 'TEST_ADDRESS', x_parameter_value ...
