DOTS IN FLEXFIELD

We have new implementation of 11.5.10, I found an interesting thing about how not to use the dots as separator in the flexfield's, not much information about this was found on web.
Here comes the scenario, assuming that you are loading it into a single segment,
Say your flexfield looks something like this XX.YYY.ZZZ.2008
and with a condition that not all the parts of it are mandatory, so it could as well looks like

CASE1 XX..ZZZ.

CASE2 XX.YYY...

CASE1 it does not work, it does create an item though but you would never be able to create catalog elements for the same.
XX..ZZZ.. Is loaded in the mtl_system_items_b for column segment1 as XX..ZZZ (Observe the missing dot at the end

CASE2 XX.YYY...(observe it ends with 3 dots)
This item would be loaded as XX.YYY.

The case where you have dot in front won't help either.

Its definitely not advisable to use dots in the flexfield and loading into a single segment. The fix provided by oracle is use either '/' or a '-'.

We were using the dot as separator from past few days and ran into many problems and have now changed them to '-' and it fixed everything.

QOTD

"Light travels faster than sound. This is why some people appear bright until you hear them speak." :)

Disclaimer

Nobody Really cares if you are miserable, So you might as well be happy

Women Purohits

Read here

http://outlookindia.com/full.asp?fodname=20080121&fname=
Women+priests+%28F%29&sid=1

Not a bad idea for people who are planning on marriages.....
Nothing good/bad or traditions its the attitude we/u carry.... rest all works....

Person of the Year : A Must Read

Valdamir Putin is the Person of the Year 2007... a very good one about him

http://www.time.com/time/specials/2007/personoftheyear/
article/1,28804,1690753_1690757_1690766,00.html

A Putin joke: Putin and Bush are fishing on the Volga River. After half an hour Bush complains, "Vladimir, I'm getting bitten like crazy by mosquitoes, but I haven't seen a single one bothering you." Putin: "They know better than that."

Shraddhanjali…

It is with immense grief and sadness that we announce the untimely deaths of two of our friends and colleagues; Kiran Kumar Allam and Chandrasekhar Reddy Komma.

We are outraged by the blatant violence that has brought an end to such precious lives and condemn it. As expatriates, we know how friends become family in this land away from home. And it is this family that we turn to in our hour of need.

We would take this opportunity to thank the community, faculty and students who attended the memorial service and acted as a show of strength for the families of Chandrashekhar and Kiran. Many offers of help were made and we hope we will be able to assist the families both financially and emotionally.

As part of our small but significant Indian community here in the USA, we ask you to extend your heartfelt support to the bereaved families of these two young men in these trying times. As a first step, LSU has established a support fund for the families of the victims. We urge you to donate generously. Those wishing to donate to the "Komma & Allam Support Fund" can do so online by visiting https://www.lsufoundation.org and scrolling down For the Benefit of:" select "Komma and Allam Support Fund." or send checks, made payable to LSU Foundation, to 3838 West Lakeshore Drive, Baton Rouge, LA 70808.

We would appreciate it if this information could be communicated across the country and that the Indian community in the US would stand as a united front with the families.

If you wish to support the families by way of donating services, please let us know. Our contact information is listed on the website. Or you can email us at isa@lsu.edu.

LSU vs Auburn 2007

What a finish.....LSU Tigers quarterback Matt Flynn throws the ball .... perfectly catched by Demetrius Byrd for a 22 yard touch down with just a second left...LSU comebacks in line for the SEC west championship