Open GL periods in Oracle Apps 11i

By
Jan 23, 2012
No Comments

Quick and overly simple script to determine status of GL periods. The example looks for period names ending in ’11’ (ie, from 2011). SELECT gps.period_num, gps.period_name, gps.set_of_books_id, gsob.period_set_name, DECODE (gps.closing_status, ‘O’, ‘Open’, ‘C’, ‘Closed’, ‘F’, ‘Future’, ‘N’, ‘Never’) status FROM gl_period_statuses gps, gl_sets_of_books gsob where gps.period_name like ‘%11’ and gps.application_id = 101 and gsob.set_of_books_id = […]

Getting under the hood with DB2 for TSM Admins

By
Dec 21, 2011
No Comments

Over at the TSMADmin blog, Chad Small recently posted “DB2 Doesn’t Make a Difference.”  Chad was concerned that he was not seeing a performance boost in his database queries after upgrading from TSM 5.5 to 6.x. As you know, one of the biggest changes in TSM 6.x is that it is now backed by DB2. […]

WMS Health Check scripts for Oracle Apps 11i and R12

By
Aug 24, 2011
4 Comments

While poking around on the My Oracle Support site (formerly Metalink), I ran across a script called WMS_health_check.sql (document 1086783.1) that contains 30 queries to find certain kinds of data corruption in Oracle Apps.  Most of the checks are for WMS, but there are also several relating to Order Management, Shipping Execution, and Inventory/Purchasing/Receiving. Some of […]

Determine order number from delivery_detail_id in Oracle Apps 11i

By
Aug 24, 2011
No Comments

I recently needed to look up the order number associated with a delivery_detail_id, so that I could run diagnostics on the sales order.  Here’s a quick script that I whipped up to find the info: select unique wdd.source_header_number order_number, wdd.source_header_id, wdd.source_header_type_name order_type, wdd.source_line_id line_id, msi.segment1 item from wsh_delivery_details wdd, mtl_system_items_b msi where wdd.delivery_detail_id in ( […]

Check for failed concurrent requests in Oracle EBS 11i

By
Jun 30, 2011
No Comments

Just a quick SQL script that I wrote to check for concurrent requests that failed in the past 24 hours.  The script is for E-Business Suite 11.5.10.2; it may or may not work on other versions of Oracle Apps.