Syntax to user oracle functions in BI Publisher
XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdofx:expression?> for extended…
Read MoreQuery to find responsibility from a form name
SELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, fnd_menu_entries MENU, fnd_responsibility RES, fnd_responsibility_tl RESTL WHERE FORMSTL.user_form_name LIKE ‘%Workbench%’ AND FORMS.form_id = FORMSTL.form_id AND FUNC.form_id = FORMS.form_id…
Read MoreBI Publisher If then Else Statement
Conditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if statement to define a simple condition; for example, if…
Read MoreCreate Journal on a Spreadsheet Fusion
Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read MorePayment process request technical details
Overview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process…
Read MoreScript to delete concurrent program and the xml templates and data definitions
Begin fnd_program.delete_program(‘program short name’,’applicaton shot name’); fnd_program.delete_executable(‘program short name’,’applicaton shot name’); commit; End; Example: If you have a concurrent Progam called “Employee Details Report” with the short name EMPDTLSREP and…
Read MoreConcurrent 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…
Read MoreQuery 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 ,…
Read MoreQuery 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>’);
Read MoreQuery 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%’;
Read More