Venky DevMastery

HCM<-->ADP Integration Process  Automatic Data Processing(AD). It is a SaaS Cloud third party application Automating Job creation in Oracle HCM Cloud using external CSV data. Step1: Extraction & Delta Capture I initiate the process using an HCM Extract configured with 'Changes Only' logic. In a mature environment, we don't send the entire workforce; we capture 'Life Events'—new hires, terminations, and attribute changes (like bank accounts or salary). I set the delivery to WebCenter Content (UCM) in XML format to maintain data structure for the middleware. Step 2: OIC Orchestration & Secure Retrieval The OIC scheduled flow triggers and invokes the HCM Cloud Adapter to run the extract.  Once the job completes, OIC retrieves the document from UCM using the Get Document operation. To ensure security, the data is processed entirely within the OIC memory layer, and we use CSF keys for all connection credentials." Step 3: Data Transformation & Busin...

Click here for the more information: Clik Here

PSUEDO Column: Level and Connect By Clause Q: How to Implement Loop in Oracle SQL? > "LEVEL" is a System Variable (PSUEDO Column) > By default LEVEL initialized with 1 > By default LEVEL incremented by 1 Ex: Initially 1 1+1=2 2+1=3 ....etc. SELECT LEVEL FROM DUAL CONNECT BY LEVEL

ROWNUM and ROWID Psuedo Columns usage in Oracle SQL Importance of Psuedo Columns Frequently used Psuedo Columns in Oracle SQL: 1.ROWID 2.ROWNUM 3.CURRVAL 4.NEXTVAL 5.LEVEL CONNECT BY Q:How to display rowids for any table in Oracle SQL? SELECT ROWID,EMPNO,ENAME,SAL FROM EMP; ROWID is a physical address in DB. It is used to delete duplicate records. It contains 18-Digits(alpha-numeric.)-Base-64 String Example :- CREATE TABLE EMP77 ( ENO NUMBER(4), ENAME VARCHAR2(50), SAL NUMBER(10, 2) ); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (101, 'ARJUN', 55000); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (102, 'BEATRICE', 62000); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (103, 'CHENG', 48500); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (104, 'DAHLIA', 71000); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (105, 'ELIAS', 53000); INSERT INTO EMP77 (ENO, ENAME, SAL) VALUES (101, 'ARJUN', 55000); E...

ABOUT SEQUENCES in Oracle SQL Definitions:- A Sequence is a DB object created to generate sequence numbers(integers) automatically. It's primary use to create auto-increment values for Surrogate Keys or Pimary Key Columns without manual intervention. Syntax: CREATE SEQUENCE [START WITH ] [INCREMENT BY ] [MAXVALUE ] [MINVALUE ] [CYCLE/NOCYCLE] [CACHE ]; OR CREATE SEQUENCE [START WITH n] [INCREMENT BY n] [MAXVALUE n | NOMAXVALUE] [MINVALUE n | NOMINVALUE] [CYCLE | NOCYCLE] [CACHE n | NOCACHE] [ORDER | NOORDER]; Example 1 :- CREATE SEQUENCE S1 START WITH 1 INCREMENT BY 1 MAXVALUE 5; using sequence :- -------------------------- CREATE TABLE STUDENT ( SID NUMBER(2), SNAME VARCHAR2(10) ); INSERT INTO STUDENT VALUES(S1.NEXTVAL , 'A'); INSERT INTO STUDENT VALUES(S1.NEXTVAL , 'B'); INSERT INTO STUDENT VALUES(S1.NEXTVAL , 'C'); INSERT INTO STUDENT VALUES...