Popular Posts

Tuesday, May 14, 2019

Query to get the concurrent request phase code and status code meaning

-->
In FND_CONCURRENT_REQUESTS TABLE we have status and phase codes and not meaning, so how can we get the actual meaning of status or phase if we would like to display the actual meaning full status in the forms or reports.

Below is the query


select (select meaning from fnd_lookups where lookup_type ='CP_PROCESS_STATUS_CODE' and LOOKUP_code=fcr.phase_code) phase_value
  ,(select meaning from fnd_lookups where lookup_type ='CP_STATUS_CODE' and LOOKUP_code=fcr.STATUS_code) phase_value
 from fnd_concurrent_requests fcr where fcr.request_id=89500591

Saturday, May 11, 2019

RAMADAN EVERYTHING ABOUT THE HOLY MONTH



                                    RAMADAN THE HOLY MONTH

RAMADAN , the meaning of this name is , the calendar ninth month  of the Islamic calendar .
There are many beliefs on this month . Ramadan is also called as the month of mercy where  ,Successor of the Prophet Muhammad in Ramadan was killed.
Another belief is the word Ramadan came from the word “Ramadhaa” which means “Intense heat of the sun” and it was named such because it burns the sins of the believers with righteous deeds.
Muslims are involved in this month with intense prayers,dawn to dusk fasting .
They fast the entire day beginning from sunrise and end the day fast with a sip of water and dates at sunset.



During this period, they do the five daily prayers; zakat, or almsgiving; and the hajj, the pilgrimage to Mecca.
The five prayers include Fazr where they read Quran in the morning at 5:00 A.M,then followed by Zohar Prayer at midnoon 1:30 P.M, and in the evening there will be Asar at 5:00 P.M. Finally they end the day with Maghrib Prayer at 7:00 P.M and then they have Iftar with all the family members and friends.
The month is also a time of community; it is the custom for Muslims to invite their near and dear, share their evening meal – iftar and recite special Tarawih prayers in congregation.
Nowadays, the community is not just Muslims , but all are being secular and all the religions are happy to participate the iftar parties and show human relations are more than anything else.
Ramadan month lasts 29 – 30 days and ends depending on the visual sightings of the crescent moon.

On the final day they see the Chaand or crescent mood and read Quran /Khudba.
They are decked up in  beautiful bright and vibrant colors and Men go to Mazjid, Women busy preparing delicious and scrumptious Biryani, Sheet Khurma and so many delicious and nutritious food. Women do prayers at home and wish each other as “Id Mubark”. 

The ultimate goal of Ramadan is to care, share and develop a closer relationship with Allah.

IPL 2019 WINNING TEAM


                                                  IPL 2019 WINNING TEAM PREDICTION

IPL Stands for Indian Premier League .

This IPL Season is very intense with strong battles between the teams and this season

its more interesting with power hitter players like Rusell who redefined power hitting.

Also there were many other players to look for during this IPL like Rashid Khan who won the game changer award.

Finally for Sunday 12th March match between CSK and MI, CSK should be considered the worthy team to win the IPL Trophy.


Captain cool DHONI being the captain of this team, it is blatant that CSK should and will  WIN the IPL Trophy.


Also to support DHONI are the experienced players like JADEJA, HARBAJHAN SINGH and many others.


They have a great team combination of good bowlers and batsmen and not to forget the team most important All rounders.

Players like IMRAN TAHIR and DEEPAK CHAHAR strengthened the bowling attack.

CSK's  bowling attack has 4 superb spinners which also counts for their win.


They have experienced Batsmen  like DJ BRAVO ,SURESH RAINA and SHANE WATSON.


They have Been into the Finals for record SIX times(2008, 10, 11, 12, 13, 15).
So Finally today's cup is worthy for  CHENNAI SUPER KINGS.

 

 

 

 How to direct the outputfile of the concurrent request to unix server path using XMLP Bursting  ORACLE APPS. Step 1: In the DATA XML defini...