Open GL periods in Oracle Apps 11i
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 = ...
Easy thumbnails of PDFs on OS X
I recently needed to create some thumbnails, using the first page of a fairly large number of PDFs. I was pleasantly surprised to learn that OS X has a handy command-line utility that can be easily scripted to do this. Here’s the one-liner I used to accomplish the task: for file in `echo *.pdf`; do ...
Queries to verify Oracle configuration
I wrote up this fairly basic cheat sheet for myself several years ago. At the time, I was not very familiar with the Oracle database, and was working with a DBA whom we suspected was not setting things up correctly or even consistently. So, I put together a set of queries to verify basic parameters ...
Disabling caching on a primary stgpool and deleting the volumes in TSM
I recently needed to shrink a primary stgpool with devclass DISK on a TSM 5.5 server in order to free up space. Since the stgpool had a device class of DISK and caching was enabled, I wasn’t able to directly shrink the stgpool by moving the data within volumes and then deleting the empty volumes. ...
Using SQL*Loader to get around ORA-01795
So one of your higher-ups just sent you an Excel spreadsheet with tens of thousands of items, and he or she wants you to query Oracle and get the results right away to resolve the crisis of the day. Unfortunately, trying to query against this huge list of values gets you this fun error: ORA-01795: ...
WMS Health Check scripts for Oracle Apps 11i and R12
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
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 ( ...
What does “down” mean?
Various meanings for ‘down’ that I have seen over the years: An email to someone at another company bounced back. Someone forgot his or her password and/or password. A mobile user has poor wireless and/or mobile broadband connectivity. “I’m at the airport…” A mobile user was sitting at home during a power outage. Wish I ...
TSM 6.2 shut down, ADM6017E in db2diag.log
This morning, I noticed that one of my TSM 6.2 servers had stopped running over night. No DB2 processes or dsmserv were running. I checked the TSM logs, but only found errors from the dsmadmc client: 08/11/11 09:08:52 ANS5216E Could not establish a TCP/IP connection with address ‘TSM1.LANIGERA.COM:1500′. The TCP/IP error is ‘Connection refused’ (errno ...
Recent Comments