How to enable debug log in Oracle apps EBS
--Run the below query before running test case and note down the sequence number
SELECT MAX(LOG_SEQUENCE) before_seq
FROM FND_LOG_MESSAGES;
--Run your test case
--Run the below query after running ...Application Object Library
36 posts
How to add AME role and responsibility to user
How to add AME role and responsibility to user in oracle appsAdd AME responsibilityAME setup in oracle apps r12AME workflow in oracle appsapproval management engine in oracle apps r12AME setup in oracle appsAME responsibility role attached to userhow do I add roles to AMEthere are no valid navigation AME Errororacle add ame responsibility to user […]
Oracle form attached to which responsibility
SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name
FROM fnd_form_functions_vl fff, fnd_form ff
WHERE fff.form_id = ff.form_id
and form_name='OEXOEORD'SQL query to get MIME type for file extension
SELECT :file_extension file_extension,
DECODE (
:file_extension,
'.aac', 'audio/aac',
'.abw', 'application/x-abiword',
'.arc', 'application/octet-stream'...Query to get concurrent program and executable details
SELECT fcpt.user_concurrent_program_name,
fcp.concurrent_program_name,
fat.application_name,
fet.executable_name,
fate.application_name exe_application,
flv.meaning ...Query to get responsibility level profile option values
--Add new subqueries for your profile options
SELECT resp_list.resp_name,
g.responsibility_name,
h.application_name,
g.responsibility_key,
i.request_group_name,
...Query to validate migration of XML/BI Publisher Template and Data Definition
SELECT xt_list.*, xdo_db.*
FROM (SELECT XDDV.data_source_code "Data Definition Code",
XDDV.data_source_name "Data Definition",
XDDV.description "Data Definit...Query to get details of XML/BI Publisher Template and Data Definition
SELECT XDDV.data_source_code "Data Definition Code",
XDDV.data_source_name "Data Definition",
XDDV.description "Data Definition Description",
XTB.template_code "T...Query to get Site level and Organization level Profile Option Value
--Site level profile option value
SELECT USER_PROFILE_OPTION_NAME, fpov.profile_option_value
FROM fnd_profile_option_values fpov, fnd_profile_options_vl fpo
WHERE fpov.profile_option_id(+...PL-SQL code to reset application user password
PL-SQL code to reset application user passwordOracle apps Reset application user password from backend For more reusable queries, click https://lightseagreen-goldfish-206721.hostingersite.com/category/technologyblog/oracle/
PL-SQL Procedure to send email with attachment
CREATE OR REPLACE PROCEDURE XXSEND_EMAIL (p_filename1 IN VARCHAR2,
v_subjectline IN VARCHAR2,
o_errbuf...PL-SQL to delete Concurrent Program and Executable
PL-SQL to delete Concurrent Program and ExecutableHow to delete Concurrent Program and Executable in Oracle Apps EBSDelete concurrent program Example: