Code Review Tools
Code Review plays a essential role in the Software development Life cycle This Result in Higher quality code and avoid the cost and time which we suppose to spend after…
Read MoreCustomer Contact Creation Email Creation and assignment API
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 MoreFunction to Get Customer's Contact Primary and Secondary Email Addresses
CREATE 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 MoreScript to extract Expenses SLA Details
SELECT 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 MoreScript for getting PO SLA Details
SELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”, (SELECT …
Read MoreAP Web Report Workflow Status
SELECT ‘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 MoreScript to extract Goods Received Date for Suppliers along with Invoice and PO Information
select (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 MoreEXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033
ERROR : 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 MoreASM – ORA-00020: maximum number of processes
The 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 to check Table Full Scan
Query: 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 More