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 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 MoreIntroduction: This Post illustrates the steps required to Fetch Item with BOM Details. Script to Fetch the Item with BOM Details SELECT msi.segment1 item, msi.description item_description, msi.organization_id, msi.primary_unit_of_measure primary_uom, msi.item_type,…
Read Morereceivables_party_site_details_along_with_location This script useful to extract all the AR party site details with location and account details as well as address details that will deliver invoice payment to customer
Read Moremeta_data_po_deatils_on_specific_dates This script is useful to get all the details of purchase order with requisition details item details item category along with buyer details on specific dates
Read Moreap_invoice_post_register_details_of_specific_org This script is useful to provide details of AP invoice post register details along with PO number check number and check date accounting details invoice details
Read Moreapi_events api_events This is useful script while doing period close on every month basis. Some time there will be no relation will generate between AR invoice and Subledger . In…
Read More