Working with time zones can be tricky—especially when Daylight Saving Time (DST) comes into play. This Oracle Integration recipe offers a ready-to-use solution to convert UTC into any local time…
Read MoreI have an integration with one or more invokes and I want to apply retry functionality to them, e.g. retry on failure up to 3 times etc. Now you could…
Read MoreIntroduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into Oracle.…
Read MoreWhy we need to do /Cause of the issue: When we are uploading the AP Invoice Refund data into Oracle. In the Payables Open Interface Import Program We are getting…
Read MoreIntroduction: This blog has the SQL query that retrieves the complete lot genealogy, detailing the full lifecycle of product creation. Cause of the issue: Business wants a report that contains…
Read MoreIntroduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details…
Read MoreAPI to Update Item Status in Oracle E-Business Suite Introduction In Oracle E-Business Suite (EBS), Item Status controls key aspects of how an item behaves across different modules such as…
Read MoreAPI to Update the Item Categories in Oracle EBS Introduction In Oracle E-Business Suite (EBS), item categories play a crucial role in organizing and classifying items for inventory, costing, and…
Read MoreDECLARE lc_uom VARCHAR2 (5); lc_cust_account_id NUMBER; lc_list_type_code VARCHAR2 (150); lc_list_line_type_code VARCHAR2 (150); lc_prod_attr_value VARCHAR2 (25); lc_segment_mapping_column VARCHAR2 (150); lc_prc_context_name VARCHAR2 (150); lc_prc_mapping_column VARCHAR2 (150); lc_prcing_context_name VARCHAR2 (150); lc_account_number VARCHAR2 (15);…
Read MoreSELECT SUM (target_qty) FROM (SELECT segment1, description, mtl.primary_uom_code, moqv.subinventory_code subinv, moqv.inventory_item_id item_id, SUM (transaction_quantity) target_qty FROM apps.mtl_onhand_qty_cost_v moqv, apps.mtl_system_items_vl mtl WHERE moqv.organization_id = :p_organization_id AND moqv.inventory_item_id = :p_inventory_item_id AND moqv.inventory_item_id…
Read More