Employee Absence History Query – Oracle EBS
The 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 MoreHow to delete the XML Publisher report templates and data definitions
XML 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 MoreHow to create Payroll Assignment Set using Oracle API
The 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 MoreHow to delete an element entries using Oracle API
There 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 MoreInventory Cycle Count Report
Introduction: 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 MoreAccount Alias Issue Using API
Introduction: 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 MoreGet Item Available to Transact Quantity
Introduction: 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 MoreExamples of Partition Methods and Keys for Oracle EBS Tables
This is not an exhaustive list, just an example of some of partitioning designs that may work well for some customers. There are many other examples that are not covered…
Read MoreWebAdi Download Is Failing Intermittently performance issue
The download of WEBADI is taking too long and has a Performance issue. It takes 1 minute to 8 minutes when users expect 8 seconds to 30 seconds. The user…
Read MoreUpgrade Excel To 2013 64-bit Error ‘The code in this project must be updated for use on 64 bit systems’ Uploading Data To WEBADI Template
After upgrading Microsoft Excel to version 2013 64bit, when uploading data to the template WEBADI, the template is blank. However when looking at the Excel Macro Information, the following Error…
Read More