INTRODUCTION This blog explains how we cancel approved requisition in oracle apps PROCEDURE CANCEL_REQUISITION (P_BATCH_RUN_ID IN NUMBER,P_REQUISITION_NO IN VARCHAR) AS X_REQ_CONTROL_ERROR_RC VARCHAR2(500); LN_USER_ID NUMBER; …
Read MoreINTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…
Read MoreINTRODUCTION This blog explains how we validate Bill to customer in oracle apps –****************************************************** — Bill To Customer Address Validation –****************************************************** BEGIN SELECT hcas.cust_acct_site_id –hcsu.site_use_id …
Read MoreThe Apex is now allowing the user to login with a Google account. This Social Sign-In feature is introduced in Apex 18.1 version. Using the social Sign-In feature user can…
Read MoreRecommended way to download latest templates from Fusion Application before using and loading the dat files in HCM. For Steps download and follow the below document. template-file-for-business-object
Read MoreHCM Data Loader Error Analysis Report The HCM Data Loader Error Analysis Report is a diagnostic test. It provides technical information that can help to resolve data-loading errors. Run this…
Read MoreThings to remember before loading Grade.dat file 1. SourceSystemOwner should be defined in Oracle fusion Application System 2. Effective Start Date and Set Code are Mandatory. 3. Always pass the…
Read MoreEmployees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read More1. Overview This document talks about how to Display User Rating Icons Dynamically in Oracle APEX Report. 2. Technologies and Tools Used The following technologies has been used to achieve…
Read More1. Overview This document talks about how to do Dynamic Image Carousel Slider in Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve the…
Read More