Yearly Archives: 2021

Concurrent program assigned responsibilities

SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND frgu.request_unit_id = fcp.concurrent_program_id AND frg.request_group_id = frgu.request_group_id AND…

Query to list concurrent program name with Parameters

SELECT fcpl.user_concurrent_program_name , fcp.concurrent_program_name , par.column_seq_num , par.end_user_column_name , par.form_left_prompt prompt , par.enabled_flag , par.required_flag , par.display_flag , par.flex_value_set_id , ffvs.flex_value_set_name , flv.meaning default_type , par.DEFAULT_VALUE FROM fnd_concurrent_programs fcp ,…

Query To Find Dependent Objects Of An Invalid Object

SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘<INVALID_OBJECT_NAME>’);

Query to Check locks on a table

Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;

GL Batches Query

SELECT jb.NAME, gh.period_name, gh.je_source, gh.je_category, gh.currency_code, gc.concatenated_segments, gl.entered_cr, gl.entered_dr, gl.accounted_cr, gl.accounted_dr FROM gl_je_batches jb, gl_je_headers gh, gl_je_lines gl, gl_code_combinations_kfv gc WHERE jb.je_batch_id = gh.je_batch_id AND gh.je_header_id = gl.je_header_id AND gl.code_combination_id…

Deleting Journal from GL responsibility

Creation of new tax category for India

unable to apply/unapply any receipt applications with the receipt.

User was unable to apply/unapply any receipt applications with this receipt.we had applied this data fix in Test Instance and the issue has been fixed.

Support date for Oracle WebLogic Server versions

The following table provides the date each version was released and its end of Grace Period. These are dependent on a Patch Set released in order for the Grace Period…

OID EMAGENT not started once after Daylight Savings

Once after Daylight saving happened, Some of the IAM & IDM management service was down. So we thought of bouncing the complete SSO services. While starting IDM services EMAGENT was…