How to get the DBC file for a particular instance
During OA Framework development we need to get the DBC file of the environment we want to work on.This file is located in $FND_TOP/secure for 11i and $FND_SECURE for R12…
Read MoreSQL Query for extracting the late fee data for customers in R12 Oracle Apps
SELECT aps.trx_number, aps.trx_date, cust_det.interest_rate, ROUND ( cust_det.interest_rate …
Read MoreScript for getting customer Bill to Contact in R12 Oracle Apps
FUNCTION xx_get_contact (pn_acc_number IN VARCHAR2,pn_site_use_id Number) RETURN VARCHAR2 AS v_contact VARCHAR2 (500); BEGIN SELECT DISTINCT SUBSTR (party.person_first_name, …
Read MoreScript for customers bill to email address in R12 Oracle Apps
FUNCTION xx_cust_contact_email (p_acc_id IN NUMBER,p_cust_account_site_id Number ) RETURN VARCHAR2 IS v_contact_email VARCHAR2 (1000); BEGIN SELECT DECODE (SUBSTR (cont_point.email_address, -1,…
Read MoreSGA Details – JROD COPY
/****************************************************************************************************** This section provides details from AP for NON-Employee related invoices. *******************************************************************************************************/ SELECT (SELECT period_name FROM gl_periods WHERE apd.accounting_date BETWEEN start_date…
Read MoreOpen Project with Terminated PMs or PDs
SELECT pou.NAME carrying_out_org_name ,ppa.NAME project_name ,ppa.segment1 project_num ,ppa.segment1 project_number –,TO_CHAR(ppa.completion_date, ‘DD-MON-YYYY’, ‘NLS_DATE_LANGUAGE = american’) completion_date –,ppa.description –,TO_CHAR(ppp.end_date_active, ‘DD-MON-YYYY’,…
Read MoreCapital project hours – includes PTO
Purpose of this report is to display Project billable hours for Internal ================================================= /* Formatted on 2018/07/30 15:40 (Formatter Plus v4.8.8) */ SELECT gl_period, expenditure_org, project_number, project_name, …
Read MorePDF Password Protection in BI Publisher
Go to File->Info->Properties>Advanced Settings and follow the Screen shot A and Screen shot b Screen shot A In the Custom Tab add one XDO as xdo-pdf-open-password and in the value filed type the…
Read MoreUSING APEX_ERROR NOTIFICATIONS TO MANAGE CUSTOM ERROR MESSAGES
Include User Notifications or Custom Messages and Error Messages in Oracle APEX’s default Success and Error Message style. Default Success message : Default Error message : Steps in APEX :…
Read MoreJQUERY AUTOCOMPLETE FOR TEXT FIELD ITEM IN ORACLE APEX
Process of enabling users to quickly find and select from a list of values as they type, searching and filtering without Native text with auto-complete in APEX. This process works…
Read More