Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...

One of the possible reason to fail is if the Length of the Goal Name is more than 255 Characters. Try to  reduce the Goal Name length to bel...

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...

If there is a routerFlow in the page, the $page.currentFlow variable can be used to retrieve the id of this flow. $page.currentFlow :- The i...

To access some of the current page's metadata, such as ID and title , there is a built-in variable named currentPage on the application ...

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...

SELECT gjh.accrual_rev_flag accrual_rev_flag       ,gjh.accrual_rev_period_name accrual_rev_period_name   ,gjh.creation_date journal_creat...

SELECT papf.person_number       ,ppnfv.display_name person_display_name   ,paam.assignment_name   ,hl.meaning AS representative_type  ...

SELECT (SELECT DISTINCT person_number           FROM per_all_people_f per          WHERE per.person_id = aor.person_id        ) person_numbe...

Query: SELECT *    FROM fnd_lookup_values_vl flv  WHERE lookup_type = 'POS_BUSINESS_CLASSIFICATIONS'    AND flv.enabled_flag='Y...

SELECT aca.check_number       ,aia.invoice_id   ,aia.invoice_num   ,aia.invoice_amount   ,distribution_line_number   ,aida.accrual_p...

SELECT party.party_name Borrower_Name       ,org.name operating_unit   ,loan.loan_number   ,contact_person.party_name contact_person_nam...

SELECT TRUNC(SYSDATE - e.start_date) "No. of Days"       ,papf.person_number employee_number   ,hzp.person_first_name emp_first_...

SELECT er.expense_report_id       ,er.expense_report_num       ,er.expense_report_total       ,er.reimbursement_currency_code       ,er.pers...

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...

SELECT papf.person_number       ,pastt.user_status assignment_status   FROM per_all_people_f papf       ,per_all_assignments_m paam   ,per...

SELECT peef.*    FROM per_all_people_f papf       ,pay_element_entries_f peef   ,pay_element_types_f pet  WHERE peef.element_type_id = pet...

SELECT petf.element_type_id       ,pettl.element_name       ,petf.processing_type Recurring_NonRecurring       ,petf.effective_start_date   ...

SELECT prft.name "ratename"       ,pg.name "gradename"       ,prvf.minimum       ,prvf.maximum       ,prvf.mid_value    ...

SELECT aps.vendor_name       ,aps.exclude_freight_from_discount vend_excd   ,apss.vendor_site_code   ,apss.exclude_freight_from_discount...

SELECT zj.tax       ,zj.tax_jurisdiction_code   ,hzg.geography_element2_code state_code   ,hzg.geography_element3_code county_code   ,...

SELECT hca.account_number       ,hca.account_name       ,hcs_ship.site_use_code       ,hl_ship.address1       ,hl_ship.state       ,hl_ship....

SELECT fu.user_name       ,fcpt.user_concurrent_program_name   ,fcpt.description   ,fcp.concurrent_program_name   ,fcr.request_id   ...

SELECT lookup_code       ,meaning    FROM fnd_lookups   WHERE lookup_type = 'CP_STATUS_CODE' ORDER BY lookup_code

SELECT frt.responsibility_name       ,frg.request_group_name   ,frgu.request_unit_type   ,frgu.request_unit_id   ,fcpt.user_request_se...

SELECT frt.responsibility_name       ,frg.request_group_name   ,frgu.request_unit_type   ,frgu.request_unit_id   ,fcpt.user_concurrent...

SELECT fcr.request_id       ,fcr.argument_text       ,fcr.phase_code   ,fcr.status_code   ,fcr.oracle_process_id   ,fcr.os_process_id ...

SELECT fcr.request_id       ,fcr.oracle_process_id   ,fcr.os_process_id   ,fcp.user_concurrent_program_name   ,fu.user_name   ,fcr.s...

SELECT a.request_id request_id       ,a.phase_code   ,a.status_code       ,actual_start_date       ,actual_completion_date       ,c.concur...

SELECT fcr.oracle_session_id o_sid       ,ROUND (( ( NVL (fcr.actual_completion_date, SYSDATE)- fcr.actual_start_date)* 60* 24),2) runtime_m...

SELECT fcr.oracle_session_id       ,fcr.request_id rqst_id       ,fcr.requested_by rqst_by       ,fu.user_name       ,fr.responsibility_name...

SELECT 'Request id: '||request_id        ,'Trace id: '||oracle_Process_id   ,'Trace Flag: '||req.enable_trace   ...

SELECT req.request_id       ,req.logfile_node_name node       ,req.oracle_Process_id       ,req.enable_trace       ,dest.VALUE||'/'|...

SELECT q.concurrent_queue_id       ,q.concurrent_queue_name   ,q.user_concurrent_queue_name   ,q.target_node   ,q.max_processes   ,q...

SELECT DISTINCT frt.responsibility_name ,frg.request_group_name ,frgu.request_unit_type ,frgu.request_unit_id ,fcpt.user_conc...

SELECT aif.invoice_id               ,ailf.invoice_line_id   ,aif.invoice_num   ,air.reject_lookup_code   ,aif.invoice_amount ...

SELECT            DISTINCT rsl.to_subinventory            ,rts.invoice_status_code    ,phs.org_id    ,phs.segment1 po_number  ...

SELECT DISTINCT apss.pay_on_code por_supp_site                ,pha.pay_on_code por_po            FROM ap_suppliers aps        ,ap_supplie...

SELECT MTL_SYSTEM_ITEMS_B.LAST_UPDATE_DATE       ,MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY   ,MTL_SYSTEM_ITEMS_B.CREATION_DATE   ,MTL_SYSTEM_I...

SELECT JEL.JE_HEADER_ID       ,JEL.JE_LINE_NUM   ,JEL.LAST_UPDATE_DATE       ,JEL.LAST_UPDATED_BY   ,JEL.LEDGER_ID   ,JEL.CODE_COMBINA...