The below sample query can be used to extract the objectives , competencies for an employee in Oracle EBS PMS Query: KRA Report (Objectives & Competencies) for an person id,…
Read MoreThe below sample query can be used to extract the employee absence history in Oracle EBS. Query: Absence history for an person id, if person id is not given on…
Read MoreXML Publisher report data definitions and data template definitions codes names are unique in nature, if you want to delete the defined templates and definitions you can use the below…
Read MoreThe sample script is used to create an assignment set using an API. You can create an assignment from the assignment set creation window in Oracle but you will not…
Read MoreThere are scenarios where we are need to delete the element entries created. Here is sample script which can be used to delete(i.e purge, Date track delete mode as ‘ZAP’)…
Read MoreIntroduction: This Post illustrates the steps required to fetch the Inventory Cycle Count Report. Script to fetch the Inventory Cycle Count Details SELECT TO_CHAR (cce.creation_date, ‘DD-MON-YYYY’) creation_date, mp.organization_code org, cch.cycle_count_header_name…
Read MoreIntroduction: This Post illustrates the steps required to Process the Account alias issue Using API. Script DECLARE l_transaction_interface_id NUMBER; l_trx_type_id NUMBER; l_lot_control_code VARCHAR2 (500); l_serial_number_control_code VARCHAR2 (500); l_return_status VARCHAR2 (10);…
Read MoreIntroduction: This Post illustrates the steps required to get the Item Available to Transact Quantity in Inventory using API. Script FUNCTION xx_item_availble_to_transact ( p_inventory_item_id NUMBER, p_organization_id NUMBER, p_subinventory_code VARCHAR2, p_locater…
Read MoreIntroduction: This Post illustrates the steps required to update the Item Status using API. Script to Update the Item Status DECLARE p_item_number VARCHAR2 (300); p_organization_id NUMBER; p_inventory_item_id NUMBER; p_org_id NUMBER;…
Read MoreIntroduction: This Post illustrates the steps required to Send the Email in Autonomous Data Warehouse. Script to Send Email CREATE OR REPLACE PROCEDURE xx_sample_send_mail ( p_to IN VARCHAR2, p_from IN…
Read More