Transferring Menus from one instance to another
Date: Tue, 17 Aug 1999 12:12:24 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Transferring menus from one instance to another instacne.
Hi,
This might be very OLD and boring question.
I would like to know if we can transfer menus from ONE instacne to ANOTHER.
Please let me know if somebody has already worked on this or not.
I saw couple of scripts on archive, but they are related to UPGRADE but not
about TRANSFER.....
Thanks,
-chakrapani
Date: Tue, 17 Aug 1999 13:06:35 -0400
From: ERIC.KEEN@bge.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Transferring menus from one instance to another instacne
Yes you can...
Source Instance:
----------------
FNDSLOAD APPS/PASS 0 Y FND my_menu_file.slt DOWNLOAD MY_MENU
Destination Instance:
---------------------
FNDSLOAD APPS/PASS 0 Y FND my_menu_file.slt INSERT
I like using INSERT rather than UPLOAD because it is not destructive
on existing items. Be sure to check the log files.
Date: Tue, 17 Aug 1999 14:20:25 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Transferring menus from one instance to another instacne
Hi,
Thanks for the reponse. Is there any SQL you found on Search engine ?
If so, please let me know.
Thanks,
-chakrapani
Date: Tue, 17 Aug 1999 21:34:00 -0400
From: "Chadda, Alok" achadda@kpmg.com
To: "'cinnamuri@btg.com'" cinnamuri@btg.com
Cc: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Transferring menus from one instance to another instacne
Chakrapani
There is one SQL script available on my Oracle Application site. Test it in
a test enviornment before you use it in production.
http://www.geocities.com/SiliconValley/Network/9828/index.html
HTH
Alok
From: Uptmore, Chris
Sent: Tuesday, August 17, 1999 7:50 PM
To: 'oraapps-l@cpa.qc.ca'
Subject: RE: Transferring menus from one instance to another instance
I put some SQL scripts out there a year or so ago I used when upgrading
from 10.5 to 10.7 (FNDSLOAD wasn't working or something...). You're just
selecting/inserting values from/into a couple of tables - I did it with a
database link...
It's no big deal and un-supported because you are doing SQL*Plus with FND
tables. It is probably one of the simpler things to figure out in the
Oracle Apps Data Model (especially using the scripts).
Use of FNDSLOAD is "supported" if you are worried...
FYI,
Chris
Date: Fri, 20 Aug 1999 14:35:36 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Script to transfer Menus, REsp.s from ONE instacne to ANOTHER
All,
We are upgrading from 11.0.28 to 11.0.3 and I used folllowing scripts to
transfer menus from
CRP ( a development instace ) instacne to the brand new Blank copy of 11.0.3
intance.
Everything went fine when I checked from Define Menus screen.
All the details were looking fine.
I also transferred Resp.s in the same way as shown here.
After doing all this , I assigned one resp. to SYSADMIN and entered into the
new resp.
But I am getting FRM-40375: PRE-FORM trigger raised unhandled exception
error NO_DATA_FOUND
for some menu items.
PLEASE LET ME KNOW WHAT MIGHT BE THE PROBLEM.
I checked ENter Menus screen and Enter Resp.s screen in both CRP and the
OTHER instance.
Everything was looking fine.
+++++++++++++++++++++++++++++++++++++++++++
For the scripts please click here
Security on NCA - How to allow Read only access to users
Date: Tue, 17 Aug 1999 10:14:24 -0400
From: ddicondina@SUNGARDRS.COM
To: oraapps-l@cpa.qc.ca
Subject: NCA Security
Hello,
We are currently migrating from 10.7 Character to 10.7 NCA, running the
Database Server and Forms Server on one Sun Solaris 2.6 box with 7.3.4. We
use AP, AR and GL and I am in the process of setting up new
responsibilities. I have a dilemma in the fact that, in Character, you had
forms that gave users read-only capability for invoices, receipts,
accounts, and customers. My question is how do I give users read-only
access to this same information? I called oracle and the analyst began
reading out of a book about function security. I do not believe this
problem pertains to function exlusions. Is there a way to set-up a
responsibility as view-only? Am I making any sense?
Let me know your thoughts,
Dominic DiCondina
SunGard Recovery Services Inc.
610-341-8016
Date: Tue, 17 Aug 1999 08:18:06 -0700
From: Todd Manley tmanley@zilog.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: NCA Security
Dominic-
One simple way of doing this is to work with the specific functions.
Determine what function your users will need for view only, then copy the
function and set the parameter to 'QUERY_ONLY=YES'. Then create a new menu
with the changed functions and you'll now have the ability to give users the
same access, but they'll only be able to query information. If they try to
update something in the form there will be a message displayed in the
toolbar saying that they are not able to update information.
But beware, there are some Oracle forms that don't always work with the
query parameter. I know of several in OE, so it would be good to test out
any new functionality before you roll it out to your user community.
-Thanks, Todd
Todd Manley
ZiLOG
408.558.8962
tmanley@zilog.com
Date: Tue, 17 Aug 1999 17:29:48 +0200
From: "Sjoquist, Randy (AFIS)" Randy.Sjoquist@fao.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: NCA Security
Hi Dominic,
Create responsibilities with menus set up with view access, ie what the
Oracle analyst was trying to say is use the function field to limit the
access to view only. It does not require coding, just selection from a pick
list.
Inquiry is available for everything you illustrated below.
Between reviewing existing menu's and and the help of the system admin book,
you should be in good shape.
Good luck.
Randy
Date: Wed, 18 Aug 1999 10:25:46 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: NCA Security
I am not sure about your particular screens, however, we have the same stuff
for the Requisition Summary & Po summary screen. We are still in the
prototype mode but I have used function security to achieve the same thing.
Rgds,
Kermiz.
Date: Wed, 18 Aug 1999 12:00:43 -0700 (PDT)
From: impact impact impact599@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: NCA Security
Hi!!!
We have attained the same thru Function Security too. There is one more
method, make a new form function, just copy the original one and in the
Parameters field, say QUERY-ONLY=YES. This will make the specified form
as Query only. We have implemeted the Orders Form (OEXOEMOE) in this
way and it Works. I have also used function security in Customers
forms, where u can exclude a particular function and it will give u the
desired functionality, disabling some buttons on tthe form. See if it
works for u.
With Regards,
Alok Shivpuri (IMPACT 5 Group).
Date: Thu, 19 Aug 1999 13:23:28 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: NCA Security
Alok,
If you created a new function, I guess you would have to give it the same
name as the Oracle function? My understanding is that the forms are coded to
call that particular function. If you gave it your own name, the form would
not know about it?
Assuming the SAME name, the problems I see in doing this:
- You really have to make sure that you want to change it for every other
call to that function i.e. you have to be sure what other forms are calling
it & that is what you want it to do.
- Would this not cause a problem at upgrade time?
Any thoughts?
Kermiz.
Date: Thu, 19 Aug 1999 14:44:14 CDT
From: "Suneel Kalavala" sk_kalavala@hotmail.com
To: ddicondina@SUNGARDRS.COM
Cc: oraapps-l@cpa.qc.ca
Subject: NCA Security
Hi ,
The best way to do this is through creation of a new function.
First go to the Define functions screen and query up the form
that you want to be made query only.
Then duplicate this record and change the name of the function
(you can just append _QO) and also the User function name(just append "View"
in the front of the name). Then in the parameters append
QUERY_ONLY='YES'. Once this is done attach this function to the
appropriate menu.
Suneel Kumar(kalavala_sk@hotmail.com)
Concurrent Manager causing lot of internal errors - ORA-00600
Date: Wed, 18 Aug 1999 14:59:22 +0100
From: rchalton@dunnes-stores.ie
To: oraapps-l@cpa.qc.ca
Subject: GEN: Concurrent Manager - HELP!
We are running Release 11 on Windows NT. On our development machine a
concurrent program caused loads of internal errors to occur:
ORA-00600: internal error code, arguments: [plio.c: client p], [2], [], [],
[], [], [], []
The application hung and I was unable to access the database via SQL*Plus
either.
Tried to shutdown the concurrent manager, but after one hour of waiting
decision made to shut down the server and restart.
After shutdown and restarting the NT server and starting the application
database and services, cannot get into the application and cannot access
the database via SQL*Plus. On checking the logs I see that the concurrent
program has restarted and causing the same internal errors.
Does anyone know how this can be cancelled - bearing in mind I cannot get
into the application, nor can I use SQL*Plus.
Any help greatly appreciated.
Rob
Date: Wed, 18 Aug 1999 10:16:03 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Concurrent Manager - HELP!
Hi,
Check your TRACE files and find out where it is giving the exact problem.
You may find the SQL that is causing these problems.
Try to take decision based on this SQL.
There are several causes for ORA-600 error. Otherwise search on Metalink.
You can find atleast one of them being 100% matching with your problem.
What is the exact release no. 11.0.28 or 11.0.3 ?
All the best.
-chakrapani
Date: Wed, 18 Aug 1999 07:25:00 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Concurrent Manager - HELP!
I am on Unix platform and am not familiar with NT, but can you see the
process at the o/s level? Can you "kill" the process for the concurrent
program which is giving you grief?
Have you contacted Oracle Support. Here is the explanation for the ORA
error:
// *Cause: This is the generic internal error number for Oracle program
// exceptions. This indicates that a process has encountered an
// exceptional condition.
// *Action: Report as a bug - the first argument is the internal error
number
HTH
Date: Wed, 18 Aug 1999 10:31:38 -0400
From: "Stephen J. Farley" sfarley@us.redwoodsw.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Concurrent Manager - HELP!
There are over 30 solutions for robust scheduling solutions that could
assist you.
Call or email and we could discuss.
Stephen J. Farley
Regional Sales Manager
Redwood America Inc.
610.722.5185 p
610.722.5186 f
sfarley@us.redwoodsw.com
Date: Wed, 18 Aug 1999 16:16:09 +0100
From: rchalton@dunnes-stores.ie
To: oraapps-l@cpa.qc.ca
Subject: Re: GEN: Concurrent Manager - HELP!
Thanks to all for advice. The problem is now solved.
For anyone who is interested this is the action I took:
Start up an NT cmd box
set ORACLE_SID=DEV2
svrmgr30
connect internal
....password...
shutdown abort
I then select the Services icon and closed down the concurrent manager
services.
Then returning to my cmd box (still running svrmgr30) and:
startup
shutdown immediate
startup
exit
From my client I started the application (without concurrent manager being
started) and cancelled my job.
I then restarted the concurrent manager services and everything is back to
normal.
And of course I'll correct my code!
Thanks again.
Rob
Date: Wed, 18 Aug 1999 14:13:22 -0500
From: "Uptmore, Chris" uptmorec@kci1.com
To: oraapps-l@cpa.qc.ca
Subject: Re: GEN: Concurrent Manager - HELP!
Our last ORA-00600 was solved by the DBA going to the Oracle RDBMS Support
group (as opposed to the AOL group) with the RDBMS alert log. It was the
second time we found a problem related to RDBMS version 7.3.4.2, with the
solution being, "upgrade to 7.3.4.3 (now 7.3.4.4)".
Rob says this is Rel 11, and I'm not sure if that means RDBMS V7 or V8, but
I thought this might help...
FYI,
Chris
How to remove Folder in a screen
Date: Thu, 19 Aug 1999 11:12:51 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: How to remove a folder
How do I remove a folder in any screen ?
Excuse me as I never worked on FOLDERS.
Thanks,
-chakrapani
Date: Thu, 19 Aug 1999 17:30:45 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: How to remove a folder
Hi
For some folders, you could delete using:
FOLDER menu delete
I am remebering I tryed to delete a folder without success, and the =
only way
was to go in the SysAdmin responsability and administer folder.
It works
richard
Access restricted to Org specific data in Custom Form
Date: Thu, 19 Aug 1999 15:52:11 PDT
From: "Anil Kumar" anilk_p@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Restricted access to organization specific data in a Custom Form.
Hi all,
I've a custom form developed, that is based on a custom table and is part of
customization of Oracle HR. Now the custom table has data for all the
organizations that we have. And the same table/form will be used in all the
organizations/sites. I want to restrict the acces to the users depending on
the organization they belong to. I mean to say that the guy in one
organization should not be able to see data of another organization related
data. For example as we select the organization before we do anything in
Oracle Inventory like performing transactions etc. Can anybody help me in
this regard.
thankq 2 u all.
-AK
Date: Fri, 20 Aug 1999 09:58:21 +1000
From: Bijan Sarkar BijanS@ResMed.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Restricted access to organization specific data in a Custom F
Hi Anil
I did the following in one of my recent FORM:
Step-1
Create a base table text item organization_id in the master block.
Step-2
Use a 'PRE-QUERY' trigger in the master block with the following code
begin
:masterblock.organization_id:=fnd_profile.VALUE('SO_ORGANIZATION_ID');
end;
You can use fnd_profile.GET as well. Please refer Oracle Applications,
Coding Standard for further details.
Note: -- SO_ORGANIZATION_ID or MFG_ORGANIGATION_ID returns Inventory
Org ID and
ORG_ID returns Operating unit Org ID. So use the appropriate
one.
Regards
-Bijan SARKAR
Cross Module Fuctionality between OE and Inv and OE and AR
Date: Fri, 20 Aug 1999 17:21:44 +0930
From: "Flanagan , Norah" Norah.Flanagan@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Cross Module Fuctionality between OE and Inventory and OE and AR
Guys,
I've created a menu linking OE superuser menu and an Inventory superuser
menu. However when Orders,Returns is selected from the inventory
responsibility an error message is displayed. APP-18021 : you are not
authorized to view or enter Orders or Returns. Contact you System
Administrator. The Inventory responsibility is using the Standard - order
Inventory data group. I have checked Application, Installation information
and both Inventory and Order Entry are installed. I tried setting both up
as shared but had no luck. Please can anyone help ?
Thanks, Norah
Queue width change and shut down individual Concurrent Manager
Date: Fri, 20 Aug 1999 08:25:39 -0700
From: "McClung, Ed D." EDMCCLUNG@ESCOCORP.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Concurrent Manager Question
Hi there,
Couple of Concurrent Manager Question PLEASE, if so any examples on
how:
1. Can only a individual Concurrent Manager be shut down through a script.
2. Can the width of a queue be changed through a script.
thanks in advance for any help or advice,,,
Ed McClung
Database Administrator
ESCO Corporation
(503) 778-6275
(503) 778-6754 (Fax)
edmcclung@escocorp.com
http://www.escocorp.com
Concurrent Request - Update of As Of Date and Setting up of
Date: Fri, 20 Aug 1999 15:47:53 -0700
From: "Ismert, Michael K." mismert@ecs-its.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Setting up Concurrent Requests
I have a quick question:
If I setup a concurrent request to resubmit daily, and then enter an As Of
Date as part of the report parameters, does that date get updated. I'm
using 10.7G.
Thanks,
Michael
Date: Mon, 23 Aug 1999 08:08:50 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Setting up Concurrent Requests
No. Dates used in resubmittals or request sets do not get updated in 10.7SC.
Oracle is aware of the problem, but they have chosen to leave it alone in
10.7 and fix in future releases. I have not heard if it is actually fixed in
Rel 11.
Logo image for splash screen - change
Date: Sun, 22 Aug 1999 16:07:43 +0400
From: IjlalR@mashreqbank.com
To: oraapps-l@cpa.qc.ca
Subject: GEN: Splash screen logo
Hi,
I have a simple question: Where is the logo image file (used for the splash
screen) stored on the server? We would like to put our own logo instead of
Oracle's but can't locate the file. I am aware that this question has been
posted on this list before but we searched for logo.tif, as well as logo.gif
and even Applscore but did not get the file we were searching for. We are on
R11.0.2.
Thanks in advance,
Ijlal
Date: Sun, 22 Aug 1999 20:49:49 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Splash screen logo
Ijlal,
Is the $FND_TOP/media/logo.gif file not the one you want ??
Date: Mon, 23 Aug 1999 15:28:47 -0600
From: "Rosy Virani" Rosy.Virani@CRHA-Health.Ab.Ca
To: oraapps-l@cpa.qc.ca
Subject: RE: Splash screen logo
It is under $OA_MEDIA.
Rosy.