OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to disable a package..

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to disable a package..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to disable a package.. [message #465775]

Thu, 15 July 2010 10:11

suman.g
Messages: 89
Registered: June 2009

Member

Hi All,

Please suggest me how to disable a package??
For some of my testing I need to disable the package and after the testing I need to enable again.

I tried with dropping this is package but my application is giving error. Means dropping package is not working.

Thanks in advance..

Warm Regards,
Soniya

Report message to a moderator

Re: How to disable a package.. [message #465777 is a reply to message #465775]

Thu, 15 July 2010 10:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please suggest me how to disable a package??
Exactly what does this mean?
What do you want/expect to occur when package is "disabled"?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to disable a package.. [message #465778 is a reply to message #465775]

Thu, 15 July 2010 10:15

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Please suggest me how to disable a package??

Disable for all or for some?
You can do nothing on a package when someoneelse is working with it.
Maybe you could try to remove execute privilege from all users but you.

Regards
Michel

Report message to a moderator

Re: How to disable a package.. [message #465781 is a reply to message #465778]

Thu, 15 July 2010 10:32

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

select  sid
  from  v$access
  where owner = <package-owner>
    and object = <package-name>
/

will give you list of sessions using the package (sessions that instantiated the package to be precise).

SY.

Report message to a moderator

Re: How to disable a package.. [message #465789 is a reply to message #465781]

Thu, 15 July 2010 10:51

suman.g
Messages: 89
Registered: June 2009

Member

Thank you all for your quick replies..

For one of my issue Oracle has suggested to disable package 'POR_CUSTOM_PKG' in cloned instance and test the issue.

Now I have to disable the package ..but I don't know how to go about this..

Report message to a moderator

Re: How to disable a package.. [message #465794 is a reply to message #465789]

Thu, 15 July 2010 10:55

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

To go about what?
And how did you "disable" the package?

Regards
Michel

Report message to a moderator

Re: How to disable a package.. [message #465799 is a reply to message #465794]

Thu, 15 July 2010 10:58

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

I believe the question is how to disable the package.

@suman - When you say oracle has suggested, do you mean oracle support?
What exactly did they say?

Report message to a moderator

Re: How to disable a package.. [message #465806 is a reply to message #465799]

Thu, 15 July 2010 11:16

suman.g
Messages: 89
Registered: June 2009

Member

Yes, this action plan was given in TAR.

First they asked below questions (with my answers)..

• For certain users? Maybe we can narrow it down somehow.
- No.

• Do they have personalization enabled on Non Catalog Request page or any of
the Requisition Checkout pages?
- Yes.

• Is the POR_CUSTOM_PKG enabled?.
- Yes.

Later they asked
update1 -'Do you get the same results when the personalizations are turned off and the POR_CUSTOM_PKG is disabled?'
update2 -'What happens when the POR_CUSTOM_PKG is disabled? Does it work properly?'

Now I have to peform to check above..

Report message to a moderator

Re: How to disable a package.. [message #465808 is a reply to message #465806]

Thu, 15 July 2010 11:26

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

I suggest you ask them what they mean because I know of no way of disabling packages.

Report message to a moderator

Re: How to disable a package.. [message #465809 is a reply to message #465808]

Thu, 15 July 2010 11:27

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

Also why did you answer yes to "Is the POR_CUSTOM_PKG enabled?."
What does enabled mean to you?

Report message to a moderator

Re: How to disable a package.. [message #465811 is a reply to message #465809]

Thu, 15 July 2010 11:32

suman.g
Messages: 89
Registered: June 2009

Member

I thought they want to know whether this package is 'VALID' or not..

Yes ok, I will ask Oracle only what does they mean by disabling by package.

Report message to a moderator

Re: How to disable a package.. [message #465815 is a reply to message #465811]

Thu, 15 July 2010 11:44

suman.g
Messages: 89
Registered: June 2009

Member

I have asked this in TAR itself.. will update you the same once I get any reply from them.

Thank you all for your quick & valuable replies. Smile

Smile

Report message to a moderator

Re: How to disable a package.. [message #465875 is a reply to message #465815]

Thu, 15 July 2010 20:48

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

@suman.g Can you please post the link where you got the reference to "Disable" The package!!

Report message to a moderator

Re: How to disable a package.. [message #465880 is a reply to message #465875]

Thu, 15 July 2010 22:01

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Yes ok, I will ask Oracle only what does they mean by disabling by package

Quote:

@suman.g Can you please post the link where you got the reference to "Disable" The package

Quote:

I have asked this in TAR itself.. will update you the same once I get any reply from them.

Thank you all for your quick & valuable replies.

@ rahul got it now?
let op comeup with reply

sriram Smile

Smile

Report message to a moderator

Re: How to disable a package.. [message #465886 is a reply to message #465880]

Thu, 15 July 2010 22:16

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Smile

Hmm ..I am Waiting...

Report message to a moderator

Re: How to disable a package.. [message #465888 is a reply to message #465886]

Thu, 15 July 2010 22:18

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://forums.oracle.com/forums/thread.jspa?threadID=1100371&tstart=75

The question asked here but not by suman.g it is soniya.g Wink

Wink

sriram

Report message to a moderator

Re: How to disable a package.. [message #465895 is a reply to message #465888]

Thu, 15 July 2010 22:35

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Tricky ..are they twin Sisters Very Happy

Very Happy

..even wording are same

Report message to a moderator

Re: How to disable a package.. [message #465911 is a reply to message #465895]

Fri, 16 July 2010 00:41

suman.g
Messages: 89
Registered: June 2009

Member

It's me only... Wink

Wink

But does name really matters..??

Report message to a moderator

Re: How to disable a package.. [message #465918 is a reply to message #465911]

Fri, 16 July 2010 01:10

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

suman.g wrote on Fri, 16 July 2010 00:41

It's me only...
But does name really matters..??

/forum/fa/449/0/

No ofcourse not

Report message to a moderator

Re: How to disable a package.. [message #473354 is a reply to message #465918]

Fri, 27 August 2010 08:54

suman.g
Messages: 89
Registered: June 2009

Member

Hi All,

FYI..

There is no such way to disable a packge.
To disable the package 'POR_CUSTOM_PKG', we need to set need to 'NO' the following profiles:

POR: Enable Req Distribution Customization
POR: Enable Req Header Customization
POR: Enable Req Line Customization

Report message to a moderator

Re: How to disable a package.. [message #473356 is a reply to message #473354]

Fri, 27 August 2010 09:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>There is no such way to disable a packge.
Is this statement or question?
EXACTLY what do you mean by "disable a package"?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to disable a package.. [message #473388 is a reply to message #473356]

Fri, 27 August 2010 14:02

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

Let me clarify things a bit. This is about Oracle eBS.
The package in question is used for customizing the application. You can put in code that will be called at certain points by the original application software. That way you do not have to change the original code, but you can still call your own custom code during processing.

By setting the profile options mentioned above, the custom code in the package will not be called by eBS anymore.
That is what is meant by 'disabling the package'.

Regards,

Arian

Report message to a moderator

Previous Topic:	Suggestions to resolve issue reg scheduling a pl/sql program
Next Topic:	GL date, 31-MAR-10, is not in an open or future-enterable period (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 16:47:14 CDT 2024