API

Creating Workers Oracle Fusion HCM API

Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction / Issue Onboarding…

Read More

SharePoint Parsing Tool

Automating SharePoint Data Extraction with Playwright and Python The Problem: Vendor Checks Scattered Across SharePoint Accounts-payable teams often store vendor data in several places. Vendors, accounts, GL codes, and vendor…

Read More

How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman

How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman Introduction / Issue In Oracle Fusion Applications, every user’s access is controlled by the…

Read More

Seeing Inside the Black Box: Building a Visualizer for RAG Chunks

Introduction / Issue  Anyone who has worked with a Retrieval-Augmented Generation (RAG) pipeline has run into the same frustrating moment: the model returns an answer, and somewhere behind it a…

Read More

script to create safety stock in oracle apps r12

Introduction/ Issue:  This code will help us to Create the safety stock in oracle inventory. Why we need to do / Cause of the issue: When business requires to create safety stock…

Read More

Creating API using ORDS Rest full services

Introduction: In modern web applications, RESTful APIs play a crucial role in enabling seamless communication between systems, applications, and services. Oracle REST Data Services (ORDS) allows developers to expose database…

Read More

Reading Outlook Emails with Microsoft Graph API using OAuth 2.0 Authentication

Introduction: – The Microsoft Graph API provides a powerful way to interact with a wide range of Microsoft 365 services, including Outlook, using a unified endpoint. By leveraging OAuth 2.0…

Read More

ITEM Category creation in EBS using API. 

Introduction:  This API will create Item categories in EBS.    SET SERVEROUTPUT ON;   DECLARE    v_return_status  VARCHAR2(1)   := NULL;    v_msg_count      NUMBER        := 0;    v_msg_data       VARCHAR2(2000);    v_errorcode      VARCHAR2(1000); …

Read More

Query to update payment terms for supplier site

Using Below script we can update payment terms for suppliers.       DECLARE      p_customer_profile_rec         hz_customer_profile_v2pub.customer_profile_rec_type;      xin_xout_object_version_number NUMBER;      x_return_status                VARCHAR2(2000);      x_msg_count                    NUMBER;      x_msg_data                     VARCHAR2(2000);     …

Read More

Oracle R12 Customer TaxPayer ID Update API

/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status VARCHAR2(1), message VARCHAR2(1000)); / set serveroutput on;…

Read More