Blog / Category
API
20 articles in this category
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…
SharePoint Parsing Tool
Automating SharePoint Data Extraction with Playwright and Python The Problem: Vendor Checks Scattered Across SharePoint Accounts-payable teams often store vendo…
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 contr…
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 a…
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 cr…
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. Oracl…
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 endp…
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_m…
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_xou…
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),…
Oracle R12 Customer Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR…
Oracle R12 Customer Site Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR…
Script to delete the employee record using API in oracle
–Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); –Insert Data insert into papf_16082018 values (53687,’215677′); commi…
Dynamic Approver List for AME
Oracle has provided an API to get the dynamic list of approvers for AME. ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list. We need to pass the transaction ty…
How to programmatically close PO using PO_ACTIONS API
How to programmatically close PO using PO_ACTIONS API PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass…
Create Bulk GL Code Combinations Using API
DECLARE CURSOR c1 IS SELECT a.rowid row_id,a.* FROM temp_gl_code a WHERE process_flag= ‘N’; &n…
Create Responsibility API
A responsibility is an important configuration which allows the user to navigate to the various menus and form functions within that responsibility.Oracle API i…
Creating Lookup and Lookup Values through API
The custom lookup parameters can be passed to the below API’s to insert data into Oracle standard tables fnd_lookup_values and fnd_lookup_types  …
Oracle HRMS – Create Employee API
This blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do…
Create, Update Organization API
This blog describes the technical information required for creating Inventory organization and their classification using API.In order to create Inventory organ…