CREATE OR REPLACE PACKAGE XX_CUST_CONT_PKG IS –================= — Global Variables –================= gn_request_id NUMBER := apps.fnd_global.conc_request_id; gn_prog_appl_id NUMBER := apps.fnd_global.prog_appl_id;…
Read MoreCREATE OR REPLACE FUNCTION CUST_EMAIL_FUNC (p_bill_to_contact_id IN NUMBER, p_flag VARCHAR2) RETURN VARCHAR2 IS V_email VARCHAR2(1000): = NULL; BEGIN IF p_flag = ‘PRI’ THEN select cont_point.email_address into V_email …
Read MoreSELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”, aerh.total “Amount”, aerh.default_currency_code “Currency”, (SELECT meaning FROM…
Read MoreSELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”, (SELECT …
Read MoreSELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_date)) days_old, …
Read Moreselect (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id order by creation_date …
Read MoreERROR : Error Description: IMPDP fails or terminate with following errors. ORA-39065: unexpected master process exception in SEND ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86ORA-06512: at…
Read MoreThe Oracle parameter PROCESSES has been exceeded as a result of multiple database instances connecting to the ASM instance. The default value (often 40) is insufficient to support more than…
Read MoreQuery: spool large_table_scans.txt –Find Large Table Scans set linesize 132 SELECT substr(table_owner,1,10) Owner, substr(table_name,1,15) Table_Name, size_kb, statement_count, reference_count, substr(executions,1,4) Exec, …
Read MoreHow to find database size? SQL> select sum(bytes)/1024/1024 from dba_data_files; (OR) SQL>select sum(result) from (…
Read More