ls -l *.rdf | wc -l
Oracle Apps Blog
Monday, October 30, 2023
Tuesday, December 6, 2022
SQL Query to find spaces in a data column
select *from (select 'testname@email.com ,noname@gmail.com ' email from dual) where regexp_like(email,'(^ | $)')
Monday, January 31, 2022
How to search for a text from files in a directory on Linux
find -type f -name "*.xml" -exec grep -l 'searchtext' {} +
Use the above command to find all files (in this case xnl) containing specific text 'searchtext' on Linux
Thursday, April 9, 2020
How to test read/write permissions on UTL directory (in UNIX) from database or backend
Below is the sample script which can be run from TOAD/SQL*PLUS to test the read write permissions on UTL directory from database or backend
DECLARE
l_file utl_file.file_type;
BEGIN
l_file := utl_file.fopen( 'DBA_UTL_DIR_NAME', 'test_file_name.txt', 'W' );
utl_file.put_line( l_file, 'Here is sample text' );
utl_file.fclose( l_file );
END;
Direcory name (
DBA_UTL_DIR_NAME) should exists in DBA_DIRECTORIES table- Make sure that the UTL_FILE directory path exists in UNIX
Wednesday, February 12, 2020
About this Page Personalization Profile Option Values
Set the values of following profiles to enable Personalization Page link in OAF Pages
- FND: Personalization Region Link Enabled Yes
- Personalize Self-Service Defn Yes
- Disable Self-Service Personal No
Wednesday, May 15, 2019
Set FORMS_PATH in Oracle R12
When you face below errors while compiling the custom form:
identifier 'APP_WINDOW.CLOSE_FIRST_WINDOW' must be declared
Bad bind variable parameter.G_query_find
identifier 'APP_WINDOW.CLOSE_FIRST_WINDOW' must be declared
Bad bind variable parameter.G_query_find
Run the below command to set the FORMS_PATH:
export FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
Compile the form using the below command:
frmcmp_batch userid=apps/pwd module=$XX_TOP/forms/US/XXFORMfmb output_file=$XX_TOP/forms/US/XXFORM.fmx module_type=form batch=no compile_all=special
frmcmp_batch userid=apps/pwd module=$XX_TOP/forms/US/XXFORMfmb output_file=$XX_TOP/forms/US/XXFORM.fmx module_type=form batch=no compile_all=special
Thursday, February 7, 2019
Employee Supervisor Hierarchy Query Oracle R12
SELECT e.*
FROM (SELECT DISTINCT
papf.employee_number,
papf.full_name "EMPLOYEE_FULL_NAME",
papf1.employee_number "SUPERVISOR_EMP_NUMBER",
papf1.full_name "SUPERVISOR_FULL_NAME",
papf.person_id,
paaf.supervisor_id
FROM apps.per_all_people_f papf,
apps.per_all_assignments_f paaf,
apps.per_all_people_f papf1,
apps.per_person_types ppt
WHERE papf.person_id = paaf.person_id
AND papf1.person_id = paaf.supervisor_id
AND papf.business_group_id = paaf.business_group_id
AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
AND papf.effective_end_date
AND TRUNC (SYSDATE) BETWEEN papf1.effective_start_date
AND papf1.effective_end_date
AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND ppt.person_type_id = papf.person_type_id
AND ppt.user_person_type <> 'Ex-employee') e
CONNECT BY PRIOR person_id = supervisor_id
START WITH person_id = :Person_id ; -- List the person id to know who all report under him like Manager id or person id of VP
FROM (SELECT DISTINCT
papf.employee_number,
papf.full_name "EMPLOYEE_FULL_NAME",
papf1.employee_number "SUPERVISOR_EMP_NUMBER",
papf1.full_name "SUPERVISOR_FULL_NAME",
papf.person_id,
paaf.supervisor_id
FROM apps.per_all_people_f papf,
apps.per_all_assignments_f paaf,
apps.per_all_people_f papf1,
apps.per_person_types ppt
WHERE papf.person_id = paaf.person_id
AND papf1.person_id = paaf.supervisor_id
AND papf.business_group_id = paaf.business_group_id
AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
AND papf.effective_end_date
AND TRUNC (SYSDATE) BETWEEN papf1.effective_start_date
AND papf1.effective_end_date
AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND ppt.person_type_id = papf.person_type_id
AND ppt.user_person_type <> 'Ex-employee') e
CONNECT BY PRIOR person_id = supervisor_id
START WITH person_id = :Person_id ; -- List the person id to know who all report under him like Manager id or person id of VP
Subscribe to:
Posts (Atom)
Unix commands to get the count of files
ls -l *.rdf | wc -l
-
From Oracle R12.2.X release we can use the below Oracle recommended API/package to give grants on objects in APPS schema exec AD_ZD.GR...
-
SELECT DISTINCT user_concurrent_program_name, (SELECT MAX (actual_start_date) FROM APPS.FND_CONCU...
-
SELECT DISTINCT pv.segment1 vendor_number, pv.vendor_name, hps.party_site_name address_name, ...