Archive

Author Archive

Data Matrix 2-D barcode with Underscore and TAB

June 17, 2015 Leave a comment

DataMatrix

Our corporate overlords have decided an underscore as the ideal separation character between our first and last name within our usernames for Oracle E-Business Application. And we have some pretty horrendous password requirements (Contains a capital letter, number, 8+ characters long). If you have used a handheld scanner like the Intermec CK71 before, you know how much of a pain it is to type in text, especially text with an underscore or capital letters.

I got pretty sick of signing into the handheld scanners, so I decided to make a barcode to log me in. None of the 1-D barcodes would work since they are either not dense enough, or are not compatible with special characters/keystrokes like the underscore or TAB.

Our scanners are pretty high tech and have a 2-D imager on them, so the Data Matrix was the next choice.

It was much more difficult to encode the 2-D barcode than a 1-D Code 3 of 9 barcode; here is how I did it.

Full Label ZPL

^XA
^FO100,100
^BXN,10,200
^FH_^FDED_5FHAYES_09Oracle123^FS
^XZ

Data Matrix Barcode

^BXN,10,200

Field Hexadecimal Indicator = _

^FH_

Hexadecimal for Underscore (_)

_5F

Hexadecimal for a TAB

_09

It is important to use the Field Separator (^FS) at the end of the encoded text to prevent your application from putting in a line feed or carriage return into the encoded text, which would then be sent to the printer. That line feed or carriage return would manifest itself as an unprintable character that would make your login sequence not function correctly.

When the scanner reads the text and puts int into the Telnet application for the username, it will seem like it puts the password into the field, but after the scanner reads the text a second time, it will correctly pass the password into the password field. Our scanner is set to send an enter command after a successful scan, so all it takes is the scan of one barcode to log into Oracle. What a huge improvement!

Happy Barcodeing!

Outlook 2010 PDF Handler

May 8, 2015 1 comment

For several months I have been getting the message in Outlook 2010 that there was no PDF Handler.  I decided to do something about it today. I tried for about an hour.  One of the steps I took was to “repair” Office.  That required me to restart my computer, something I seldom do because of  how long it takes to do so, even with a Core i7.  The repair didn’t solve anything.

One thing I read online was to go into Adobe Acrobat reader and make sure some check-box was unchecked.  When I opened it up from the start menu, it starting going through some finalizing installation steps.  That seemed strange since I have been opening PDFs for some time now. I guess opening it directly is slightly different than opening the program by double-clicking a PDF file.  I got to the check-box and it was already unchecked.

I opened Outlook again, and my PDF Handler worked!  Apparently all it took was opening Adobe Acrobat Reader XI from the start menu.  What a crazy simple fix!

Oracle Support Quality

March 25, 2015 Leave a comment

I have had an Oracle Service Request (SR) open for 3 years now. The request has to do with how slow several security based objects are to be displayed when a user is set up using Oracle’s newer RBAC (Role Base Access Control) security structure.  Right now we are working on is the list of concurrent requests.

The SR was originally opened as a severity 2.  About a year into the SR, one of my DBAs had some work to do on it and was getting poor response from Oracle support, so he raised the severity to 1.  It has been at severity 1 for about 2 years now.

I have gotten several patches from Oracle.  The first one we applied showed no change in performance at all.  When they released the second patch, I insisted they provide details of what the improvement was so I could confirm A) it actually did improve, and B) they have actually replicated the problem internally.  I didn’t want to waste our DBA team’s time applying an alpha stage patch that has been untested.

I never got the proof that the patch was tested.  I gave up and had the patch applied. The patch broke the security all together; a user would have no access to concurrent requests at all.  Yes it was fast, but it didn’t work.

A third patch was released; it fixed the security, so at least the user would get access, but the performance was 50% slower than an un-patched system.

For several months I have been asking for updates on the SR every week or so, and it get the standard “we are working on it” or “requested status from development” response.

I have poked the bear, per-say, this last week by asking for some manger interaction.  Take a look at the latest response I got from them:

3-year-sr3

Note in the title of the SR I mentioned “W/RBAC.”  The first question in this SR update is “Are you using RBAC model to define security?”  ARE YOU KIDDING ME?

Oracle WMS RUP 11 Included Patches

February 17, 2015 Leave a comment

Finding patches that are included as a part of Oracle WMS RUP 11 is not as simple as it could be, so here is a list:

Patch 20187263

Patch R12.WMS.B.delta.11: Logistics Consolidated RUP11 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1])

The following bugs are fixed by this patch:

Read more…

Poor general contractor: Design Build 4U Chicago

June 10, 2014 Leave a comment

I have been going though a renovation project for the past 1.5 years in Chicago IL.  The contractor, Design Build 4U Chicago, has been an absolute nightmare.  More details to come on that.

If you find this page looking for details on the following, please add yourself to this google group.

Contractor: Design Build 4U Chicago
Trade License Number: TGC028355
Owner: John Hochbaum
Vice President: Stephen M. Probst (Stephen Probst; Steve Probst)

John P. Hochbaum Jr.

1604440_10201680029298788_973371341_n

Stephen Probst

182747_105023836244399_1643857_n

Working Effectively with Customers on Oracle Service Requests

April 3, 2014 2 comments

Working with Oracle Support is frequently frustrating and difficult.  Very often Service Requests analysts post updates asking for customer’s to refer to an internal document, stating: “The following note can enhance your experience with Global Customer Services: Note: 166650.1 : Working Effectively With Support.”  At this point, I have determined I need to do something similar.

Here is my list to keep in mind to effectively work with customers:

  • Before asking a questions or asking for data, review entire SR and it’s attachments to make sure it has not already been provided. If another SR is referenced, please include that in your review.
  • Consult Oracle internal experts rather than asking customer how a module works.
  • Do not give statements that may be untrue or are assumptions.
  • Test all solutions in an internal, Oracle, instance before asking customer to try the solutions. Video evidence of testing may be requested.
  • Provide all files in an industry standard formats. Customers should not be required to download proprietary software or codecs.
  • Review all files before attaching
  • Video files must be understandable, and easy to follow.  A beginner should be able to replicate the same actions portrayed in the video.
  • Do not constantly indicate that an SR is not responded to within a certain period of time. The same courtesy will be given to you.
  • Development instances will not be cloned onto production.
  • An SR will not be opened per instance.
  • The solution “that is a limitation of the software” or “that is how it works” is not acceptable.
  • If documentation does not match the application’s functionality, only a “bug” will be a satisfactory solution.
  • If configuration requirements are missing from documentation, and assumed, it is inherently irreverent.  And any undesired functionality must be considered a bug.
  • Documents on My Oracle Support are not considered documentation unless referenced in the customers software version’s User Guide or Implementation Guide available at publication/release date.
  • It is Oracle support’s responsibility to coordinate between Oracle divisions/module development teams.
  • Analysts should not expect customer to have direct Unix level access to complete testing or diagnostic work.  SQL Plus is considered direct Unix access.
  • Any dates or times should be expressed in the customer’s time zone.
  • It is the responsibility of an Oracle Analyst to provide a sufficient hand-off of SRs to subsequent analysts.  Questions resulting from poor SR transitions may be responded to in a harsh manor.
  • Please honor the requested communications method listed on the SR. Any communication initiated that does not match the requested communications method may be treated as if it never happened, unless it is agreed that that method may be used by both parties.

All of these are based on actual experiences.

Oracle ER/Bug 16306627: WIP IS ISSUING ASSEMBLY PULL COMPONENTS WHEN SCRAP IS ENTERED

April 7, 2013 Leave a comment

The following is entered as an enhancement request at Oracle for their E-Business R12 product.  I have tried to convince Oracle to categorize this as a bug, but have not had any luck.  If you have encountered a similar situation, please log an SR and add yourself to this “ER” and request that it be changed to a bug.

We [Emerson] have an assembly with a BOM where a component is inherited from a phantom assembly into the main assembly as an assembly pull supply type component on operation SEQ 1. The final assembly’s routing begins with operation SEQ 400. When a job is made, the component gets tied to operation SEQ 400. When a WIP move is made to the scrap step of the first operation (400), the assembly pull component is taken out of inventory.

This functionality is described as correct as per WIP User guide.

Oracle® Work in Process User’s Guide Release 12 Part No. B31092-01

When you move assemblies into the Scrap intraoperation step of an operation that has assembly pull components assigned to it, the system backflushes these components and all assembly pull components at prior operations.

This functionality does not seem to be correct. If a component is “assembly pull”, a completion takes it out of inventory at the end of the job. This means the component is acting as assembly pull for a completion, but operation pull for scrap.

If the goal is to take out inventory of assembly pull components when an assembly is completed, than it should not be tied to an operation.

Read more…

Follow

Get every new post delivered to your Inbox.

Join 158 other followers