Posts

Fault Handler in Oracle Integration Cloud

-
Image
   Fault handling in Oracle Integration Cloud (OIC) Fault handling in Oracle Integration Cloud (OIC) is an essential mechanism for managing errors that occur during integration execution. It is like fixing a problem when it happens so it doesn't go ignored. Purpose  Instead of allowing an integration to fail silently,  fault handling logic executes recovery actions or notifies the appropriate persons.  Common techniques include: Email Notifications: Sending email about error codes, messages, and details to business or support teams for rectification. Audit Tables: Dumping error records and instance IDs into custom tables (such as ATP or DBAS) for periodic review and tracking. Generic Error Handlers: Building a single, reusable REST API integration for error handling that can be invoked by multiple other integrations to save time and avoid repetitive tasks. Bulk Record Handling: For high-volume data loads (like FBDI), failed records can be stored in a file and em...
Post a Comment
Read more

HDL Process in Oracle HCM Fusion

-
Image
  HDL-Human Capitable Data Loader HSDL HCM Integration Specialist Recent logs Stage tables are temporary tables. after we move the data to base tables then we will delete the data in staging area We need to understand the Workforce Structure flow: Locations Refresh All Objects before we download template What is the extension of data file? .DAT The file name should be same name as the template name. UI navigation Myclient Groups--->Workforce Structures-->Create Location Approval Groups or Flow Tools-->Transaction Console By pass the approval flow
Post a Comment
Read more

HCM Cloud to ADP Integration process in Oracle Integration Cloud

-
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...
Post a Comment
Read more

Trading Community Architecture (TCA) in Oracle Fusion

-
Click here for the more information: Clik Here
Post a Comment
Read more

PSUEDO Column :Level and Connect By Clause in Oracle SQL

-
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
Post a Comment
Read more

ROWNUM and ROWID Psuedo Columns usage in Oracle SQL

-
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...
Post a Comment
Read more

Sequences in Oracle SQL

-
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...
Post a Comment
Read more