How to Analyze Long running UBE’s
Source: Oracle UBE Performance Webcast Example Issue UBE runs for three days and never finishes. Need a valid profile to answer the question WHERE IS THE CODE/SYSTEM SPENDING ITS TIME? …
Change FileNames in Table Conversion or Business View in UBE
Many a times we need to change the Business view of a Report/UBE, which requires re-validating the event rules code. Worse, if you had to change the input file name in …
Calculate Begin and End Dates for Month/Year
Calculate the Begin and End dates from a given Period/Year combination or to calculate the month’s begin and end dates from a given date. Like if you are given Period=3, Year=9, the Begin and End dates will be 03/01/2009 and 03/30/2009 respectively. Similarly if you were given a date say – 2/17/2009, the return Begin & End dates will be 02/01/2009 and 02/28/2009.
Convert UTC Time Format to Local Date and Time format
UTC stands for Universal Time Coordinate and is a long integer containing the elapsed minutes since Midnight on January 1, 1970 in Greenwich, England. Lets try some ER which would help converting timezones, from and to. Similarly use UTC time zone and its format effectively for Multi-Location Projects/softwares.