ATS Apex application with Ollama hosted in Cloud Fare
Introduction/ Issue: This is a walkthrough of the mini project that was built end to end in Oracle APEX – an ATS Resume Builder. It takes a user through…
Read Morescript 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 create safety stock…
Read MoreUpdate Order Type in Customer Standard in Oracle Apps
DECLARE l_init_msg_list VARCHAR2 (2000) := fnd_api.g_true; l_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type; l_object_version_number NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); l_order_type_id NUMBER; CURSOR order_type_update_cur IS SELECT xotu.*,hcas.cust_acct_site_id,hcsu.object_version_number FROM XXXX_STG xotu,apps.hz_cust_acct_sites_all hcas,apps.hz_cust_site_uses_all hcsu…
Read MoreQuery to derive Item Cost
SELECT cict.item_number, cict.description, msi.item_type, cict.PLANNING_MAKE_BUY_CODE, mis.inventory_item_status_code_tl AS item_status, sum(cdcv.item_cost)item_cost FROM apps.cst_item_cost_type_v cict, apps.cst_cost_types cct, apps.cst_detail_cost_view cdcv, apps.mtl_system_items_b msi, apps.mtl_item_status mis WHERE cict.inventory_item_id = cdcv.inventory_item_id AND cict.organization_id = cdcv.organization_id AND cict.cost_type_id…
Read MoreImplementing Automatic Retries for LLM Applications
Introduction/ Issue: When building LLM applications, we usually focus on prompts, agents, and workflows. However, one challenge that often gets overlooked is handling temporary API failures. Even if our code…
Read MoreEnable a Button Based on Checkbox Selection in an Oracle APEX Classic Report
Introduction: In Oracle APEX applications, it is common to perform actions such as Approve, Delete, Issue, or Submit only after the user selects one or more records from a Classic Report.…
Read MoreReusable Structured Output Fixer for LangChain Using Pydantic
Introduction/ Issue: One of the biggest challenges when working with Large Language Models (LLMs) is obtaining reliable structured output. Even if you explicitly ask an LLM to return JSON, the…
Read MoreInteractive Reports Just Got Smarter: APEX 26.1 Edition
Introduction/ Issue: Interactive Reports (IR) are one of the most commonly used components in Oracle APEX applications, giving users an easy way to search, filter, sort, and export data.…
Read MoreHandling Unsaved Interactive Grid Changes Before Model Navigation in Oracle Apex
Introduction Interactive Grids (IG) are one of the most powerful components in Oracle APEX, allowing users to edit multiple records in a spreadsheet like interface. However, a common business challenge arises…
Read MoreOracle APEX 26.1: Build Smarter Apps with Trigger Actions
Introduction/ Issue: In Oracle APEX 26.1, buttons, menu entries, and cards can now perform useful actions without relying on custom JavaScript or complex Dynamic Actions. With the new Trigger…
Read More