Oracle XDF Utility to Migrate Database Objects

Oracle E Business Suite provides utilities like FNDLOAD,WFLOAD to migrate Application Objects from one instance to another.Similarly it provides XDF utility to migrate Database Objects.
XDF utility is a Java class ,but a wrapped version of the it is available to be executed as Perl script too.Let us take an example to understand the utility in a better manner.Firstly we will create a custom table in a custom schema ,then generate the XDF file ,and finally apply the script to recreate the objects.

1. Table Creation in Custom Schema:





2. Execute XDF’s FndXdfGen Java Class in Unix prompt to generate the XDF file of the Custom Table.The command will extract structure of the Table and its dependent objects like Index,Synonym,Constraints,Comments,Synonym and put them in an XDF file.

java oracle.apps.fnd.odf2.FndXdfGen apps_schema=apps apps_pwd= jdbc_protocol=thin jdbc_conn_string=host:port:SID object_name=XX_XDF_TEST xsl_directory=$FND_TOP/patch/115/xdf/xsl owner_app_shortname=XX xdf_filename=/home/user1/XX_XDF_TEST object_type=TABLE logfile=/home/user1/XX_XDF_TEST.log

3. Execute XDF’s FndXdfCmp Class un UNix prompt to create the database objects, here the database object is a Table and its related objects.

java oracle.apps.fnd.odf2.FndXdfCmp apps thin host:host:port:SID TABLE /home/user1/XX_XDF_TEST.xdf $FND_TOP/patch/115/xdf/xsl

Note : XDF utility will create a Select * View of the table under creation in custom schema and then create a synonym of the view in APPS schema.

4. The same objective can be achieved by using Perl script functions, which are nothing but a wrapper on the above Java classes.
Command to Download :
perl $FND_TOP/bin/ apps/


Command to Upload :
perl $FND_TOP/bin/ XX/ apps/


How to use Oracle v$ views in Shell Script

It is difficult to use v$ views in Shell script to fetch any Oracle Database internal data, due to the special character $ associated with the views.But it can be achieved by using an backspace.
Below example shows how the v$ views can be used to fetch the open cursors limit and current max cursors reached in the Oracle session.

#Variable declaration

echo “———Open Cursor Limit Check———————-” >> ${V_FILE_NAME}


V_HIGH_OC=$(echo $V_Q_OUTPUT | awk -F ‘;’ ‘{print $1}’)
echo ‘Max cursors opened so far : ‘$V_HIGH_OC >> ${V_FILE_NAME}

V_MAX_OC=$(echo $V_Q_OUTPUT | awk -F ‘;’ ‘{print $2}’)
echo ‘Max cursors allowed to be opened : ‘$V_MAX_OC >> ${V_FILE_NAME}

if [ $V_HIGH_OC == $V_MAX_OC ]
echo “Error : SQL Open Cursors maximum limit is reached” >> ${V_FILE_NAME}
echo “SQL Open Cursors has not reached max limit” >> ${V_FILE_NAME}
echo >> ${V_FILE_NAME}


Shell Script to Scan files for a text

The below shell script will be useful to scan a file for a specific text and write the content to a text/log file.The usecase here is to scan the Oracle EBS Concurrent Log file for Workflow Listener for any errors and extract the error lines, write them in a log file and mail them to the appropriate team to take any action.The script is ideal to be executed in Oracle EBS environment Unix Servers ,as some variables values are fetched from then environment.

V_CUR_DT_TIME=`date +”%Y%m%d%H%M%S”`

echo “Workflow Listener Monitor Log File ” > ${V_FILE_NAME}
echo “Instance Name : ${USID}” >> ${V_FILE_NAME}
echo “Scanning Script Run Time : $(date)” >> ${V_FILE_NAME}
echo >> ${V_FILE_NAME}

#Variable declaration

#SQL Query to fetch current hour of the script run
echo >> ${V_FILE_NAME}

# SQL Query to fetch the Workflow Listener Log file path and name

#Get line number in the file where the Current Hour appears for first time
V_ERR_LINE=$(awk -v x=”$V_CUR_DT” ‘$0~x {print NR;exit}’ ${V_LOG_FILE})

if [ -z “${V_ERR_LINE}” ]
echo “No log entries found to scan for errors. ” >> ${V_FILE_NAME}
V_ERR_CNT=$(tail -n +${V_ERR_LINE} ${V_LOG_FILE} | grep -ic ${V_SEARCH_TXT1})

#Check if search text exists and write in a log file
if [ “${V_ERR_CNT}” -eq 0 ] || [ -z “${V_ERR_CNT}” ]
echo “No errors found in Workflow Business Event Listener log file” >> ${V_FILE_NAME}
echo >> ${V_FILE_NAME}
echo “Extract of errors and exceptions logged in Workflow Listener Log file” >> ${V_FILE_NAME}
echo >> ${V_FILE_NAME}
tail -n +${V_ERR_LINE} ${V_LOG_FILE} | grep -i ${V_SEARCH_TXT1} >> ${V_FILE_NAME}
echo >> ${V_FILE_NAME}
echo “——————–End of File——————————–” >> ${V_FILE_NAME}

#Email the log file as attachment to recepients
(echo “Please find attached Workflow Business Event Listener error monitor log file for today’s run.Ignore this mail if the issues have been already fixed. – IT Support”;uuencode “${V_FILE_NAME}” “${V_FILE_NAME}”) | mailx -s “Workflow Listener Monitor Log : ${V_CUR_DT}” ${V_EMAIL_ID}


Oracle Open Cursor Check Queries

Query to check if Open Cursors has reached Max limit :
SELECT  max(a.value) as highest_open_cur, p.value as max_open_cur 
FROM v$sesstat a, v$statname b, v$parameter p 
WHERE  a.statistic# = b.statistic#  
and = ‘opened cursors current’ 
and ‘open_cursors’ 
group by p.value;
Query to get count and list of SQL Queries causing Open Cursors :
select  sid , sql_text, count(*) open_cursors,user_name
from v$open_cursor b
group by sid ,sql_text,user_name 
order by 3 desc;
Query to get list of Sessions(SID) with Open Cursors Count:
select a.value, s.username, s.sid, s.serial# 
from v$sesstat a, v$statname b, v$session s 
where a.statistic# = b.statistic#  
and s.sid=a.sid 
and = ‘opened cursors current’ 
and s.username is not null
order by 1 desc;

Nuts and Bolts

What are Bolts and Nuts?

Bolt is cylindrical piece of metal that fasten objects together. It is a piece of steel forged at one end to make hexagonal, square or round head and the stem fully or partially threaded at the other end. Nut is a hexagonal or square piece with a threaded hole at the center. Bolts and nuts can be zinc or cadmium plating to resist corrosion. Although a bolt has a head that is in general practice usually hexagonal, its head can be designed to have heads such as round, counter sink head square neck, oval, elliptic etc. Bolts are of various types such as tap, coupling, eye, lifting, square head, carriage, Uclosed anchor ring eye-ball. When used with a nut, a bolt forms a commonest and fastest way of having two or more parts joined temporarily or permanently. The nut, on the other hand, forms part of the screwed pair. It has an internal thread and because it act as a fastening in machine construction, is fixed. The nut then moves axially as it is rotated. Just as the bolts, there are different types of nuts. These include the square, wing, slotted ring, cap, hexagonal, castle, wing, flanged and knurled. Bolts and Nuts are used extensively in all industries either during manufacturing or maintenance of engineering products. They are universal industrial fasteners and their demand is expected to increase with the development of the manufacturing, maintenance and construction sector.

Market for Bolts and Nuts:

With the present pace of industrial development, there is a rising demand for bolts and nuts in the furniture making outfits, bed manufacturing, metal fabrication, motor vehicle and other automotive industrial sub-sectors, etc.  The manufacturing and the construction sector has been growing by more than 7% in the past few years while the service sector by more than 12%. Considering these factors demand for bolts and nuts is forecasted by applying an 8% annual growth rate. Although bolts and nuts are manufactured by few of the existing metal industries, the bulk of the demand is met by imports.

Manufacturing Process Description:

Bolts and Nuts are made up of automatic double-stroke cold heading machine, automatic horizontal slotting machine, automatic bold pointing machine, automatic nut-forming machine, automatic bold head trimming machine, automatic thread rolling machine, automatic heat treatment machine, automatic nut tapping machine, tumbling machine, and other accessories. The major raw materials needed by this industry are steel rods and pickling chemicals which are readily available in the local market.

The manufacturing of bolt process will be started by removing the rust formation using mechanical scraper. Then the wire coil is pickled in pickling tanks. The mild steel rods are fed in the header machine. Trimming of formed head and stem reduction take place on trimming machine. Then the blanks are loaded to the automatic thread rolling machine for threading to the required length and size. The bolts are further put into barrel and get polished. If required, they are plated for corrosion. Nuts are also manufactured in a similar fashion like bolts. Rust removing and pickling process will take place. Then drilling and cutting of blanks from hexagonal bars is performed on nut cutting machine. The blanks are put on the tapping machine and threaded through polishes and plated if required. Finally after inspection, it will be weighed and packed.


Castle Hill Storage

Worried about storing your belongings in Castle Hill. ? Let the storage houses help you:

Castle Hill, a suburb in Sydney, New South Wales, Hills District of Australia is home for around forty thousand people. Being close proximity to Sydney CBD makes it an attractive option for storage house businesses. Storage King, Hills Self-Storage, Kennards Self Storage, Rent a Space Self-Storage, Howards Storage World, National Storage are some of the famous professional self-storage houses in the area, which also has presence across Australia.

What Do The Storage Houses Actually Do?

Most of these service providers provide both short and long term storing options with offerings spanning across domestic and business storage, vehicle and climate controlled wine storage, records management, other services, including but not limited to packaging, transporting, insurance, trailer hires. These storing houses are highly secured with 24 hour CCTV surveillance along with PIN security controlled gates. Some of these service providers has mobile apps, which helps the customer in managing their account easily. They provide tailor made solution that meets the needs and also fits the budget of the customer, so that the customer pays only for the required space. They also provide a range of transporting supplies and services which helps in moving properties easily. All packing needs of a customer, whether it can be an interstate or overseas movement, decluttering the home before selling or storing the belongings temporarily in between switching homes, these packers will help you not to lose your calm during those difficult times.

Customers in Castle Hill looking to store their belongings, should do due diligence of the storage service providers, verify their past success stories, customer complaints if any, customer feedbacks, and pan Australian presence before choosing the service provider. Customers should avoid falling for glossy advertisements, discount traps and also consider the reputation of the service provider.



Fasteners – their Usage and Types:

Fasteners are one of the commonly used and widely available components to create temporary joints, a joint which can be removed or dismantled without destructing or damaging the joining components. They are used across all spheres of our daily life, i.e right from our regular household appliances to modern gadgets, and heavy machineries too. They are of many different like common stapler, nuts, bolts, nails, or screws. Most of the fasteners available in the market are designed for a specific application and so they must be used appropriately.

Some of the commonly used male fasteners in the industry are hex head, slotted head, flat (or countersunk) head, round head, socket head, button head and socket set screw, whereas the female fasteners are regular hexagonal nuts and nylon ring elastic stop nuts (lock nuts).It is highly critical to have good knowledge about the correct usage of fasteners, especially when in use for harsher conditions. If the connecting points are of acidic in nature or usage temperature is moisture in nature or frequent chemical changes, then it becomes more significant to choose the right fastener for such situations. The methods for applying the fasteners must be tailored and designed to exceed the maximum possible abuses it can face in due course of protecting the object it has been fixed to.

Manufacturing Process

Fasteners, especially like bolts and nuts are manufactured by traditional processes like forging and machining methodology. In order to manufacture nuts, a steel rod is fed to an automatic nut forging machine. Then the semi-finished nuts are passed through tapping machine to form the internal thread, which is followed by normalizing process to release the internal stress formed in the nuts. Similarly in making bolts, the steel rod is passed to the double stroke cold header machine followed by the machining of the bolt head to any shape desired for the bolt by using the bolt head trimmer.

Most of the commonly used fasteners are made from Carbon Steel, Alloy Steel, Stainless Steel, Titanium, and Aluminum. Fasteners made by different materials has different .For eg. Fasteners made by Aluminum is used to bear lighter loads, whereas the ones made by Titanium is used by aircraft manufacturers. Sometimes they are provided special coating by Cadmium, Zinc, Phosphate, Chromium, Silver, Black Oxidizing and Nickel to improve their performance.


Evolution of Fasteners

Going beyond the conventional methods, these days hybrid fasteners are widely used. They are manufactured by unconventional materials, combination of metal and injection molded plastic elements. Advantage of this technique is, it is less expensive, lighter in weight, easier to manipulate and install, than traditional mechanical fasteners. Since plastic is being used, so they also encourage color-coding, which can be used for identification purposes, parts matching or cosmetics too. Most of the recent innovations in fastening technology is due to the modern marketplace requirements for smaller and light packages, quicker and cost effective manner. The category of fasteners has expanded to specific functional performance. The best way to take full advantage of current and future fastening technology is for product designers to take supplier’s support at the component design level, as it can help in better research and launch better quality of fasteners in the market.

Attitude Vs Personality

In today’s fast paced environment and stressful conditions, our response mostly depends upon our personality and attitude. Personality, attitude and motivation are the major contributor of our workplace behavior.

Typically, personality is inherent in nature. It is believed to be imbibed in the DNA, but it can also be refined and developed as we learn. Personality exhibits nature of the person who he/she is. On the other hand, attitude is a complex system of thoughts and emotions, that can be changed by self-experience or knowledge. E.g, A person with a specific type of personality may be seen as strong and self-confident, but how he reacts to a situation depends largely on his attitude. Similarly a person who is raised by their parents with love, support and care will have entirely different attitude when comparing with someone who has been raised by abusive parents.

Personality can also be called as a set of psychological and behavioral characteristics that comprises the core character of an individual. Most of the times the core remains the same irrespective of the situations being faced. Attitude is the potential mental and physical capabilities of an individual. They can be either instinctive or gained over a long span of life.

Personalities remain stable most of the time and it is important because it means at different situations, either it can be at work or in personal life, we will not change the personality of the people we will come in touch with. We will try to remain as we are. But attitudes, on the other hand, are subject to change. We believe that our attitudes influences our behavior, so we want to change attitudes as per the situational demand.

Our attitude is impacted by the environment where we grow up and our individual experiences, which tends to build a favorable or unfavorable opinion towards people, environment and situations. Attitude is impacted by our personality and our value system also. People prefer to work and live with people who have a positive attitude towards life. If we feel we lack a positive attitude, then we can improve ourselves, by waking up with a hope and belief that the day is going to be great.

Airtel Broadband : The connection that should be

Writing this review after 2+ months of usage.

After relocating to bangalore from hyderabad, I was in the hunt for a decent broadband ISP.During my stay in Hyderabad, I used to use reliance netconnect+, which was not so good, but was just good enough to check emails, so this time I had decided to go for wired broadband+wifi combo.

Generally I do not like to keep all eggs in one basket.I was already using airtel postpaid connections.So I did not want to go to airtel broadband.Moreover I found airtel to be costlier than the rest.After due diligence and consulting my friends, I chose Tikona, but I had a very very bad cexperience from them, which I have already reviewed in my blog.

Once bitten, twice shy, so I struck off all other ISPs from my list and chose Airtel, unwillingly though.I logged a connection request in airtel’s online portal and within next two days documentation was completed.I was charged Rs 600/- for the installation charges, which included Rs100/- for affidavit too.I chose their free wifi router+4mbps+25GB plan.Within next 2 days, on a saturday their service engineer installed the connection within half an hour and activated my plan.

Since then it has been more than 2 months and I have hardly faced any connection problems.The speed has been consistently over 3.5 mbps.I do face some disconnect intermittently but it would be for few seconds only and I can very well live with it.

On an average I use internet for atleast 3 hours per day and overall I can say that I am very satisfied with the connection and performance has been above my expectation.I will recommend airtel.

Munnar Trip : Ok

By March 2014, it had been almost 4 months, i had not gone on any treks or traveled to a new place and my fingers were itching to click snaps.The traveler in me was feeling  uneasy and it was like living in a prison, at-least after my marriage in Feb 2014.Me and my wife had planned to go on a honeymoon trip to any hill station in North India in late February.But due to leave and finance crunch, we had to postpone for some other time.

Come March, at the end of the month there was a long weekend,so we planned to go to any near by hill station,probably a night’s travel from Bangalore.After some “due-diligence” we finalized to go to Munnar on a 3 day trip.As there are no direct trains to Munnar from Bangalore, so we ruled out the travel by train option.Meanwhile,almost all buses were full,but luckily SRS had not opened ticket bookings till 3 weeks before travel date.So finally booked to and fro travel in SRS.We chose Honeymoon cottage in The Wind,Munnar resort for stay and also chose to hire a two wheeler from Gokulam Bike Hire ,run by Sudheer.

We chose The Wind resort, as we wanted to stay atleast 10-15kms away from town to avoid the traffic,noise and also wanted some peace of mind.In all those aspects The Wind did fit our bill.You can read my review about the resort here.After reaching Munnar we hired an Activa from Sudheer ,he was very helpful and guided us also.I would surely recommend his services.

In Munnar , there are places to visit in all the 4 directions from the town.But in all these directions there is one thing that is common,Tea estates.You will find lots of lush green tea estates in any direction you go.Since our stay was in Chinnakanal,which is about 22Kms from Munnar town,we saw tea estates,lockheart gap apart from that we couldn’t find anything worth mentioning.The roads in all the directions are narrow and runs through ghats with lot of curves and sharp turns, so people planning to travel around in two wheelers must take caution.It becomes more difficult to ride after 6pm.

One of the disadvantage of staying in The Wind is,we have to come all the way upto Munnar town before heading to any other direction.Since we had come via Udumalaipet and Idukki so we planned not to cover any places in that route,as it was again full of tea estates and tiny waterfalls here and there.So, the next day we planned to cover Mettupatty(Maadupatty) dam route.We started of with flower garden,after reaching the town.We can surely give a miss, as i could hardly see anything worthwhile in the garden,apart from few bright coloured flowers.We resumed our travel towards the dam, on the way we could see lots of tea estates.

On reaching the dam we could see lot of crowd,people clicking and posing for pics.The dam looked like a bridge built across a lake and we couldn’t find anything amusing apart from the bridge.After clicking few snaps, we resumed towards Echo point,which is just like any other point in any hill station.As you shout,so it echoes.

By this time we had already lost interest in Munnar, so we traveled back the resort and on the way, we had lunch at Rapsy restaurant. After riding back to Chinnakanal there was around 2-3 hours left for sunset, so we traveled towards periyakannal and reached Anayirankal dam,which looks like a proper dam.After clicking few shots,we rode back to our resort.On the last day when we were on our way back, we visited Blossom hydel park,which was just like any other flower park.

Overall ,the munnar trip was slightly disappointing, probably we carried more expectations or we had traveled at the wrong season.There are hardly any interesting places to visit.No doubt we enjoyed the bike ride,pleasant climate in the evening, the lush green tea estates and resort’s location at the edge of cliff was an add advantage.We had some good time, but not a great one.

You can check my snaps here.


Tikona : Worst Customer Service

I am residing at Bangalore and i had bought a broadband connection from Tikona on 15-Feb-2014.I had subscribed ADBBM699 plan,Rs 699/- @2Mbps per month plan.I had to pay Rs 2950/- which included installation charges along with advance rental for 3 months.The installation was successful after some hiccups and I was able to use their internet services for just 45 mins on that day.

The very next day when i tried to connect to internet it failed showing message that “A network cable is unplugged”, whereas i had already plugged in the LAN cable to my laptop. On the same night i called their customer care and registered my complaint.I was told that an engineer would be visiting my home around 7pm on monday i.e 17-Feb-2014.On monday I waited till 08:30PM but no service engineer turned up and there was no call from customer care.I was disappointed ,so i called customer care again and enquired about the reason for not resolving my issue.In turn was told an engineer would call me in an hour and the issue would be resolved.But there was no response from Tikona for next 2 days.

It had been 5 days since installation and i was able to use their internet services for merely 45 mins only.Out of my frustration , i asked Customer care to close my subscription and refund my money as i don’t see any use of paying advance rental.Again on the same day i was requested by them to give one last chance before cancelling the connection. Accordingly, i agreed, only to see the same story is being repeated. I waited till friday i.e 21-Feb-2014, and finally asked them to cancel my subscription once forever.I was told that my subscription would be cancelled and the final settlement process would be done within the next 15 days.

On 27-Feb-2014 i received a bill for February.To my surprise i found that they had included March month’s rental also along with February’s rental and usage amount.I contact customer care to get the bill details clarified, but they had no answer.I had mailed to their appellete Mr.Jayakrishnan. But there was no response from his end too.

The story doesn’t end here.On 28-Feb-2014, i had received an email from Tikona, that my subscription has been terminated and i have to handover the modem and related components to their engineer, within 7 days from the day i received the mail.I tried calling the service engineer at the numbers as mentioned in the mail.But most of the time calls would not be attended or the number remained switched off.Atlast i could talk to Mr.Praveen for one last time and when i inquired him about the procedure he gave me another service engineer’s contact number which never worked.It always remained switched off.

On the whole i can say I had spent Rs 2950/- for using Tikona’s internet services for merely 45 mins only.I am frustrated, disappointed,and feel cheated by Tikona.They should better be renamed as CHEATONA.I have reached Akosha,an online consumer forum to help me in resolving my problems.Inspite of their repeated try still Tikona hasn’t responded.I did a big mistake by choosing Tikona.I hope other subscribers are not mistreated like me.

Update (29-May-2014):
Finally ,my 3 month long struggle against Tikona’s unethical practice of cheating customers ends.Today I received my refund and it was all due to help and guidance from Strangely, they don’t even have a courtsey to beg apologies for the way they have treated a customer.Never in my life i will choose Tikona, nor i will recommend.