FND_FILE.PUT_LINE CLOB file writing causes error.
Need to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than…
Read MoreOracle Data Dictionary Tables
USER_TABLES Lists each table that belongs to your Oracle user.USER_TAB_COMMENTS Shows comments on the tables and views.USER_TAB_COLUMNS Tells you the names, data types, default values, etc. of each column in…
Read MoreBulk Collect for Delete
CREATE OR REPLACE PROCEDURE BLK_CLCT_DELISL_LIMIT PLS_INTEGER := 20000; CURSOR C1ISSELECT row_idFROM s_invoice_itemWHERE person_id IN(SELECT b.row_idFROM disalloc A, S_CONTACT BWHERE A.PD_NEW_EYEE_ID = B.PERSON_UIDAND B.CON_CD = ‘Member’AND A.PD_DT_MODIFY BETWEEN ’01-JAN-2010′AND ’31-MAY-2010′); TYPE…
Read MoreRich text Editor using TinyMCE(Moxiecode Content Editor) in Oracle Apex 23.1
INTRODUCTION: TinyMCE is a web-based WYSIWYG (What You See Is What You Get) editor that allows users to create and edit HTML content in a browser. It is a popular…
Read MoreDISPLAYING LATITUDE AND LONGITUDE BY POINTING THE LOCATION
INTRODUCTION: Maps are introduced in oracle apex to show the exact locations and information in a simple way. In this blog, we are displaying the latitude and longitude by pointing…
Read MoreQuery to find the Legal Entity, Organization, Company Code in Oracle Apps EBS.
Intro:-This script will provide all related Bom Routing department details. Code:- SELECT xep.legal_entity_id “Legal Entity ID”, xep.name “Legal Entity”, hr_outl.name “Organization Name”, hr_outl.organization_id “Organization ID”, …
Read MoreQuery to find Form Personalization in Oracle apps
Intro:-This script will provide all related Form Personalization details. Code:- SELECT ffv.form_id “Form ID”, ffv.form_name “Form Name”, ffv.user_form_name “User Form Name”, ffv.description “Form Description”, …
Read MoreCustomer Contact Extraction Query in Fusion FSCM
Introduction: This SQL query is used to fetching the data of Customer contact details like Customer Name, Contact Name, Email Address Contact Number and Dunning Letters etc… In this…
Read MoreCustomer CIF Extraction Query in Fusion FSCM
Introduction: This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not. Cause of…
Read MoreQuery to get project and task details – Fusion
Query to get Projects and Tasks Details – Fusion SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DESCRIPTION ,PPA.START_DATE ,PPA.COMPLETION_DATE ,PPA.CLOSED_DATE ,PTV.TASK_NUMBER ,TO_CHAR(PTV.TASK_ID) TASK_ID ,TO_CHAR(PPA.CARRYING_OUT_ORGANIZATION_ID) ORGANIZATION_ID ,HRU.NAME ORGANIZATION_NAME ,PPT.PROJECT_TYPE PROJECT_TYPE ,PPA.GROUP_SPACE_TEMPLATE_NAME…
Read More