WIP Job Close via Apex Application
Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming the job status, and…
Read MoreFixing Incomplete AP Open Balance on the Oracle ECC Supplier Balance Dashboard
Introduction/Issue: Even though supplier setup in Oracle Payables was correct, the “Supplier Balance” dashboard on the Oracle Enterprise Command Center (ECC) was not showing the correct total AP open balance.…
Read MoreAdding Order Date Filter to the Order Management ECC Dashboard
Introduction / Issue Users of the Order Management – Enterprise Command Center dashboard needed a way to narrow down the Orders by Order Date directly from the dashboard’s guided discovery…
Read MoreOracle EBS OAF vs Forms Personalization
Oracle EBS OAF Personalization vs Forms Personalization – Understanding the Difference Introduction Oracle E-Business Suite (EBS) provides multiple ways to customize standard application behavior without modifying Oracle’s seeded code. Two…
Read MoreAPI to create party and link to the Supplier
Introduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
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 MoreFixing Stuck Trips When Delivery Is Closed but Trip Stop Interface Isn’t Triggered (Oracle WMS)
Introduction / Issue In Oracle Shipping Execution (WSH), it’s common to run into a situation where a delivery has been closed, but the associated trip remains open because the trip…
Read MoreExtracting Bank Detail Reports in Oracle Apps R12
Introduction In Oracle Applications R12, supplier bank account details are not stored in a single, easily queryable table. They’re spread across the Oracle Payments (IBY) schema and Accounts Payable (AP)…
Read MoreHow to Populate a Placeholder Column Using the Before Report Trigger in Oracle Reports
Blog Structure Introduction Oracle Reports provides Placeholder Columns to store values that are not directly retrieved from the SQL query. These values can be assigned dynamically using report triggers…
Read More