People and Culture Blog

Rich 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 More

DISPLAYING 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 More

Query 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 More

Query 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 More

Customer 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 More

Customer 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 More

Query 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

Queries to get Employee related information – Fusion

  Query to Fetch Employee’s Legal Employer SELECT papf.person_number,         hauft.NAME LegalEmployer FROM   HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft, per_all_assignments_m paam, per_all_people_f papf WHERE   haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID…

Read More

CVE-2023-34362 protection on GKE

A SQL injection vulnerability has been found in the Progress MOVEit Transfer web application and has been assigned CVE-2023-34362 (also known as MOVEit Transfer Critical SQL Injection Vulnerability). Fastly has…

Read More

Fastly – Robots.txt

Synthetic response in Fastly is a very fast and useful way to deliver static content on a webpage. This is useful for sitemaps, robots.txt and ssl verification files. 1. Instructions…

Read More