2012年10月2日 星期二

[EBS] ORA-20001: FND-ORG_ID PROFILE CANNOT READ

今天測試環境崩潰了,還好是測試環境:

clip_image001

原來已經有一堆受害者了,而且造成錯誤的原因竟然這麼簡單,只要把Profile「MO: Operating Unit」site level的值給清掉。

解決方法:

Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit has been detected in FND_GLOBAL.INITIALIZE.

Solution

Following are steps to change the profile option from backend:

1. Get the Profile option ID using the following query:

SQL> Select PROFILE_OPTION_ID,PROFILE_OPTION_NAME from fnd_profile_options

where PROFILE_OPTION_NAME ='ORG_ID';

2. Run the following procedure which changes the profile option:

DECLARE

stat boolean;

BEGIN

dbms_output.disable;

dbms_output.enable(100000);

stat := FND_PROFILE.SAVE('ORG_ID',<enter the Profile ID from above query>, 'SITE');

IF stat THEN

dbms_output.put_line( 'Stat = TRUE - profile updated' );

ELSE

dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );

END IF;

commit;

END;

3) Restart the apache server

13 則留言:

匿名 提到...

Hi to every single one, it's in fact a pleasant for me to visit this web page, it includes useful Information.
Feel free to surf my homepage - topografía

匿名 提到...

Hi to every single one, it's in fact a pleasant for me to visit this web page, it includes useful Information.
Also see my web site > topografía

匿名 提到...

Magnificent goods from you, man. I've understand your stuff previous to and you are just too great. I really like what you have acquired here, really like what you are stating and the way in which you say it. You make it entertaining and you still care for to keep it wise. I can't wait to read much more
from you. This is actually a wonderful site.
My weblog : Instalación geotermia en Madrid

匿名 提到...

Hello, Neat post. There is a problem along with your site in web explorer, could check this?
IE still is the marketplace leader and a large
component to other folks will leave out your wonderful
writing because of this problem.
My blog - Hainan Airlines

匿名 提到...

Deciding to buy online can result in a huge cost savings while
providing you the best options for your hair care needs today.
Before you go for them, try products at Keranique
for hair care. A well groomed woman will look to her hair and makeup first and a poll of 3,000 females
across the UK revealed that about 44% feel attractive if they are having a good hair day, this compares to 16% who felt pleased with their appearance
if good teeth gave them that winning smile.

Here is my web blog ... hair products

匿名 提到...

Make sure you only use clean balls for playing on indoor simulator.
All of these issues add to the interest that can be produced about a site and this works for spots in this place and
any place in the world. This game by Hexacto is simple, straightforward, and fun.

Flight - simulator flight simulation
features highly detailed time of day modeling and can track the current computer clock time
in order to correctly place the sun, moon, stars, etc.
This game allows players to take on a whole different side of themselves and express their wild
side, or even the business man lurking in each of us.

匿名 提到...

One part compost to two or three parts potting soil would be a sufficient combination.
Use the cultivator to make holes in the soil and turn it up
just a little between the rows. Without fertilizing additives
(natural or chemical), plants will be stunted and unhealthy.



My homepage; molten

匿名 提到...

Greetings! Quick question that's entirely off

topic. Do you know how to make your site mobile friendly? My blog looks weird when

viewing from my iphone 4. I'm trying to find a theme or plugin that


might be able to resolve this issue. If you have any suggestions, please share.



Thank you!

Look into my site - aixam crevillente

匿名 提到...

F*ckin’ awesome things here. I’m very satisfied to


see your post. Thanks a lot and i am taking a look

forward to touch you. Will you please drop me a e-mail?


Have a look at my site; wiki.ivy-tech.it

匿名 提到...

Together with almost everything that

appears to be developing throughout this particular area, your points
of view are quite exciting. Even so, I appologize,
because I do not give credence to your

whole strategy, all be it stimulating none the

less. It looks to us that your comments

are not entirely validated and in

reality you are generally your self not even entirely convinced
of the argument. In any

event I did enjoy looking at it.

my website: ozark golf courses

匿名 提到...

Hello! I know this is kind of off topic

but I was wondering which blog platform are you using for this site?
I'm getting tired of

Wordpress because I've had problems with hackers and I'm looking at alternatives for another platform. I

would be fantastic if you could point me in the direction of a good platform.

Also visit my homepage :: HTTP://cendari.Fefonlus.it/wiki/core/index.php?title=User:DoreathaCox1976

匿名 提到...

Hello there! I could have sworn I've been to this website

before but after checking through some of the post I realized it's new to me.

Anyways, I'm definitely delighted I found it and I'll be
bookmarking and checking back

frequently!

My web blog :: ssi living abroad

匿名 提到...

I feel this is one of the such a lot significant

information for me. And i am satisfied studying your article.
But want

to remark on some normal things, The

site taste is wonderful, the articles is in point of fact nice : D.
Just right task, cheers

Have a look at my blog post - verizon Buying online