Archive

Author Archive

Failed Project: 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…

Fixed: Adding an Asset Group (Oracle EAM)

December 6, 2012 Leave a comment

I have been testing Oracle Enterprise Asset Management (EAM) at work to check if it can replace one of our legacy systems.  When testing I came across an error that took me days to solve.  I finally found the problem!

Conditions

  • Oracle Enterprise Asset Management (EAM) in Oracle E-Business suite R12
  • Adding a new Asset Group

Symptoms

  • Receive error on save
Insert Procedure Failed with the following error message: 12746302

Problem

  • Oracle was creating a new item based on the @Asset Group template
  • Profile option INV: Default Primary Unit of Measure was set to NULL

Solution

  1. Add a UOM of EA (Each) to the @Asset Group item template
  2. [or] Add EA (Each) as the value for the profile option  INV: Default Primary Unit of Measure

For business reasons, we cannot have a default UOM, so we will likely choose option 1.

BI Publisher Provides Our Organization Extreme Agility

September 25, 2012 Leave a comment

A year and a half ago, our company embarked on a project to run Oracle E-business R12. Part of that process included a manufacturing migration from our legacy systems, and the other part included a migration of financial modules from Oracle 11i.  Included in the 11i financial modules was Accounts Payable, thus our Payment process needed to be migrated to R12.  One of my responsibilities was to create the payment output for the R12 system.  Payments in Oracle R12 are rendered with BI Publisher, an Oracle tool I became very skilled with while working on the AP project.  Although limited, BI Publisher has to be one of the most powerful technologies Oracle provides and has allowed our IT organization to become more agile.

From what I heard, it took the previous business analyst two years to get a check printed in the 11i production system, starting at the beginning of that project.  The R12 Payment processing seemed like a daunting task.  But I was up for the challenge and eager to enhance my skill set.

Within the first day of working on the payment output, I was able to get a check printed out of our test system.  Two weeks later I had a check ready to send to our bank for validation.

Although my manager was impressed, he still had some doubts. I have a feeling he was thinking around the lines of, “this is too good to be true; how can someone get a check ready for approval so fast, when took so long previously?” Whatever his thinking was, the bank validation had the ability to halt my swift progress right in its tracks.

Read more…

Fixed: Oracle BI Publisher Template XLF Translation File Upload Error

July 3, 2012 Leave a comment

I have been working on BI Publisher templates and the XLF Language Translations at work. I found a nice bug where a user uploads a XLF template translation and Oracle gives an Error that does not match the actual problem that caused the error.

Conditions

  • Oracle BI Publisher or XML Publisher module in Oracle E-Business suite R12
  • XLF Template Language Translation files

Symptoms

  • BI Publisher gives error as seen below
  • Unable to upload XLF Translation file
The uploaded translation file is invalid. It should specify a valid target language and territory. Please verify that the file is in the correct format.

Problem

  • Original Oracle Translation file exported specifying UTF-8 encoding
  • Edited translation files actually use ISO-8859-1 encoding

Solution

  • Change XLF Specified Encoding from utf-8 to ISO-8859-1

Bridget Butler; Property Manager at Kass Management

May 28, 2012 1 comment

I usually don’t rant about things like this on my Blog, but after my most recent Condominium Board meeting, I feel the need to warn other buildings of the advice they may receive from their Building Managers.  I own a condo in a building managed by Kass Management.  Our Property Manager, Bridget Butler, is one of the most ignorant people I have ever met.  I have caught her falsifying information multiple times. Here are a few examples:

  • There are fire doors in our hallway that are not able to close automatically due to the high carpet.  I notified Bridget of the issue and got no response.  I finally convinced the condo board to press the matter.  Bridget Butler came to the next board meeting and reported that she had talked to an Inspector, and that the inspector said “due to the building’s design, fire doors were not necessarily.” This was is in the board meeting minutes, approved by our board.  Since no inspector visited the building, I filed a 311 complaint. According to the city website, we now have building violations against our building for the exact problem I asked Bridget to get fixed.  Minutes prior to the next board meeting I checked and the doors were not fixed.  At the meeting, Bridget Butler said that our violations were closed.  How can they be closed when the problem mentioned in the violations are not fixed?? This is fully documented and I may seek legal action.
  • I was trying to get our board to approve a cost reduction project to insulate our hot water tanks.  Bridget Butler claimed our tanks were “not designed to be insulated” and “they are only warm to the touch.”  The manufacturer sells prefabricated insulation cabinets.  I measured the surface area of the tanks at 126, and 127 degrees with an infrared thermometer; that is hot enough to cause 3rd degree burns.
  • Bridget Butler states that Certificates of Operation for elevators , or copies of, do not have to be placed within the elevator.  State laws say otherwise.  After one year of asking for the certificate of operation to be placed in the elevator, nothing was being done. I finally called the city of Chicago and found out our elevator had not been inspected since 2007.  Isn’t it the management companies responsibility to get that done?  I also blame my condo board for not pressing the matter, but it is not ultimately their responsibility.

The biggest problem with this situation is that our Condominium Board tends to trust Bridget Butler because she is in a position of authority.  In that manner, Bridget’s ignorance is transferred to our Condo Board; safety issues tend to get dismissed until fines by the city of Chicago are threatened.  It should not have to get that far.

I admit I am not the most politically skilled individual.  That is my biggest weakness by far.  But that doesn’t mean I don’t do the research to find the facts and get things done the right way, every time.

With that said, in conjunction with Bridget’s authoritative position, my week political skills are likely why my Condo Board sides on Bridget’s advice rather than my own.  However, when it comes to safety, there is no room for politics, and I astonished that Bridget Butler has gotten this far with her career given her extreme ignorance.  I decided to post this to warn other condominium associations to be wary of Bridget’s advice.

</End Rant>

Follow

Get every new post delivered to your Inbox.

Join 134 other followers