▼
Saturday, February 1, 2025

Query to get the Concurrent Program along with Value Set details

›
SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...
Monday, January 27, 2025

Query to get Unposted Journals in Oracle APPS R12

›
SELECT gjh.accrual_rev_flag accrual_rev_flag       ,gjh.accrual_rev_period_name accrual_rev_period_name   ,gjh.creation_date journal_creat...
Sunday, January 26, 2025

Query to get Employee Responsibility details in Oracle Fusion

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

Employee assigned Responsibilities in Oracle Fusion

›
SELECT (SELECT DISTINCT person_number           FROM per_all_people_f per          WHERE per.person_id = aor.person_id        ) person_numbe...
Thursday, January 23, 2025

Business Classification in Oracle Supplier R12 - POS_BUSINESS_CLASSIFICATIONS

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

SQL Query To Get Invoice Validation And Accounting Status For The Given Check Number (Doc ID 2975480.1)

›
SELECT aca.check_number       ,aia.invoice_id   ,aia.invoice_num   ,aia.invoice_amount   ,distribution_line_number   ,aida.accrual_p...
Friday, January 17, 2025

How To Populate the Phone Number Field in Oracle Loans? (Doc ID 2990762.1)

›
SELECT party.party_name Borrower_Name       ,org.name operating_unit   ,loan.loan_number   ,contact_person.party_name contact_person_nam...
Thursday, January 16, 2025

Query for Outstanding Card Transactions Report (Doc ID 2755945.1) in Fusion Expenses

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

Query to get the Approver Details for Expense Report (Doc ID 2279634.1) in Oracle Fusion

›
SELECT er.expense_report_id       ,er.expense_report_num       ,er.expense_report_total       ,er.reimbursement_currency_code       ,er.pers...
Wednesday, January 8, 2025

Query to get Parent and Child Accounts in Oracle APPS R12

›
SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...
Friday, January 3, 2025

Query to get Employee Assignment Status in Oracle Fusion

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

Query to get Element Entry details in Oracle Fusion HCM

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

Mandatory Input value for HCM Elements in Oracle Fusion

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

Query to get Grade Rate details in Oracle ERP

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

Exclude Freight from Discount(Supplier) in Oracle APPS R12

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

SQL query to get list of Jurisdictions for which Tax Rates has been defined in Oracle APPS R12

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

Query to get Customer Address that doesn't have Geography Reference in Oracle APPS R12

›
SELECT hca.account_number       ,hca.account_name       ,hcs_ship.site_use_code       ,hl_ship.address1       ,hl_ship.state       ,hl_ship....
Thursday, January 2, 2025

Query to get Errored or Warning Concurrent Program Request details in R12

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

fnd_concurrent_requests.status_code in Oracle APPS R12(CP_STATUS_CODE)

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

SQL Query to find Request Set details in R12

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

SQL Query to check Concurrent Program details in R12

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

SQL Query to check Concurrent Requests SID & OS Process Details for given Request ID in R12

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

SQL Query to Check Currently Running Concurrent Requests in Oracle APPS R12

›
SELECT fcr.request_id       ,fcr.oracle_process_id   ,fcr.os_process_id   ,fcp.user_concurrent_program_name   ,fu.user_name   ,fcr.s...
Wednesday, January 1, 2025

Query to get History of Concurrent Requests which are errored out in Oracle APPS R12

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

Query to get the Running History of Concurrent Programs in Oracle APPS R12

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

Query to get Long Running Concurrent Programs in R12

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

Query to get Trace file Including SID in Oracle APPS R12

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

SQL to find out the Raw Trace Name and Location for the Concurrent Program

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

Query to get Concurrent Manager Status in R12

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

SQL Query to get the Responsibility/Request Group attached for a given Concurrent Program

›
SELECT DISTINCT frt.responsibility_name ,frg.request_group_name ,frgu.request_unit_type ,frgu.request_unit_id ,fcpt.user_conc...
Monday, December 30, 2024

Query to get failed records in Invoices Interface in Oracle APPS R12

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

Query to get GRN Details in Oracle APPS R12

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

Query to get POR is Enabled at Supplier Site and PO Level in Oracle APPS R12

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

Query to get Inventory Item details in R12

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

Query to get GL Journal Details in R12

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

Query to get Sales Invoice(Receivables) Details in R12

›
SELECT RA_CUST_TRX_TYPES_ALL.TYPE,        RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID,        RA_CUSTOMER_TRX_LINES_ALL.LAST_UPDATE_DATE,...