Security Rules - thru Custome Library
De: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]De la part de Rajesh
Gupta
Date: vendredi 19 mars 1999 02:22
Objet: Enabling security rules for query dynamically in forms.
Hi,
I need to enable security rules for inquiry of records in AP, AR
modules. One way to do it is setting option
QUERY_SECURITY=>'Y' in
FND_KEY_FLEX.UPDATE_DEFINITION.
Can this be done dynamically in CUSTOM library? If so how?
(Modifications to the actual form is not desired).
We are using Oracle Apps 10.7 NCA.
Thanks
Rajesh Gupta
Date: Fri, 19 Mar 1999 11:26:50 +0100 Concurrent Requests - Cannot view
Date: Thu, 25 Mar 1999 09:47:21 -0500
Date: 25 Mar 99 09:19:28 CST Concurrent Manager scripts
Date: Thu, 25 Mar 1999 17:31:38 -0500 Setup - Online Help
Date: Fri, 26 Mar 1999 09:08:24 -050O Setup for Custom Developed Form
Shamica Wakade wrote:
Date: Mon, 05 Apr 1999 10:38:12 -0500 Cancel Utility
Date: Tue, 30 Mar 1999 09:18:14 -0600 (CST)
Well, let's see. You *COULD* write a shell script that will cancel a print
job (pass the unix job number to it) and register it as a concurrent request. Debug in Ora Apps
From: Sawant, Shrikant (CRD, TCS) [mailto:sawant@crd.ge.com]
Date: Tue, 30 Mar 1999 14:46:02 -0800
Date: Wed, 31 Mar 1999 08:57:54 -0500 Blocking Access During Close
From: rob merryman [SMTP:rob_merryman@hotmail.com]
Date: Wed, 31 Mar 1999 19:39:18 +0530
Date: Wed, 31 Mar 1999 15:27:29 +0100 (BST)
Date: Wed, 31 Mar 1999 08:25:39 -0600
Date: Wed, 31 Mar 1999 09:46:20 -0600 Customizing GUI toolbar
Date: 10 Mar 99 11:03:31c
Date: Wed, 10 Mar 1999 11:26:59 -0500 (EST) Blind Queries
From: psawyer@Baxglobal.com [mailto:psawyer@Baxglobal.com]
Date: Mon, 5 Apr 1999 08:13:04 -0700
Date: Thu, 17 Jun 1999 08:47:23 -0400
Date: Thu, 17 Jun 1999 09:39:30 -0500 Patches applied to Database
From: Haseeb, Mohamed [mailto:Mohamed.Haseeb@Jacobs.com]
Date: Fri, 16 Apr 1999 08:16:46 -0400 Table Lock
At 05:21 16/04/99 -0400, Rudy Wahab wrote:
Date: Fri, 16 Apr 1999 08:25:05 +0000 Table owner
From: Jagannathan, Ravi [SMTP:RJagannathan@prcnet.com]
Date: Tue, 20 Apr 1999 17:38:27 -0400 Documentation for customization
From: CFowler@littonapd.com [mailto:CFowler@littonapd.com]
Date: Wed, 21 Apr 1999 10:06:00 -0700
Rama,
Date: Wed, 21 Apr 1999 15:35:47 -0700
Date: Wed, 21 Apr 1999 16:42:01 -0700 (PDT)
From: "Blaise Rempteaux"
Subject: RE: Enabling security rules for query dynamically in forms.
Message-ID: <000101be71f2$fffdccc0$ba02d180@f8889155.auchan.com>
You can modify the package custom from the custom.pll library
package body custom is
procedure event(event_name varchar2) is
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
begin
if (event_name = 'WHEN-NEW-FORM-INSTANCE') then
if (form_name = 'FORM1' ) then
FND_KEY_FLEX.UPDATE_DEFINITION( BLOCK=>'BLOCK_NAME1',
FIELD=>'CONCATENATED_SEGMENT_ITEM_NAME1',
QUERY_SECURITY=>'Y');
elsif form_name = 'FORM2' ) then
FND_KEY_FLEX.UPDATE_DEFINITION( BLOCK=>'BLOCK_NAME2',
FIELD=>'CONCATENATED_SEGMENT_ITEM_NAME2',
QUERY_SECURITY=>'Y');
end if;
end if;
end event;
end custom;
For eacg form you want to modify, you must know the name of the form, the
name of the block
that contains your flexfield and the name of the field that contains the
concatenated segment
value plus delimiters.
Regards
Blaise Rempteaux
Cap Gemini France.
From: "Phillips, Brant"
Cc: "Nelappana, George P."
Subject: Cannot View Concurrent Request Files and Log Files
Our current DEVELOPMENT configuration is such:
We are running Oracle Applications 11.0.2 on RDBMS 8.0.4.3.
Our Database tier (admin server and Concurrent processing server) is on the
same physical hardware. This hardware/os is HP-UX (11.0).
The Application Tier (forms server and web server) is on NT 4.0.
THE PROBLEM is that we are UNABLE to view Concurrent Request LOG and OUT
files from the concurrent processing node.
Does anyone have a similar 11.0 setup (UNIX backend server with an NT
mid-tier), and may be able to shed some light on how to fix this problem.
We do have our PRODUCTION 10.7nca configuration that is similar and IT
WORKS. Are we missing a setup that is new for 11.0?
By the way, we also have another 11.0 configuration with all TIERS (database
and application) on HP and IT WORKS. The problem seems to be the HP-NT
combination.
PLEASE HELP.
---------------------------------------------
Brant Phillips
Sr. Programmer/Analyst
Bell+Howell Mail and Messaging Technologies
4401 Silicon Drive
Building 675
Durham, NC 27709-4986
E-Mail: phillib@mps.bellhowell.com
From: Mani Kumar Manda
Subject: Re: [Cannot View Concurrent Request Files and Log Files]
Hi Phillips,
We had a similar problem couple of weeks ago. We got
this problem after we applied, tech1102 patch.
We have Applications Release 11.02 on RDBMS 8.0.5. We
installed both database and application tiers on Sun
Solaris platform.
Here is what we did to fix this problem.
1) Make a note of all printer drivers that you use
2) For every printer driver you use,
Query it in 'Printer Driver' form
Remove '-c' option from arguments field
Hope this helps,
Mani Kumar Manda
Rhapsody Technologies, Inc.
Phone: 630-717-1809
From: "Deepak Bhatnagar" deepak.bhatnagar@haworthinc.com
Subject: Need Concurrent Manager Scripts supplied by VALTEK
Hello Everyone
I need Concurrent Manager Scripts supplied by VALTEK, which does the
following functions.
*The UNIX Box is down * The Database is down
* A File System is more than 95% full * A Printers is down
* There are more that 10 jobs in a Printer Queue
* The Concurrent Manager is down * The Listener is down
* The Webserver Listener is down
* There are more than 10 jobs pending in the Concurrent Manager
* A Concurrent Manager request runs longer than 20 minutes
* The UNIX Load Average is greater than 5
I will really appreciate, if anybody could tell me how to get this
VALTEK.tar file from ftp site/internet?
Thanks in advance.
Best Regards
Deepak Bhatnagar
Oracle Consulting
Phone: (616)393-1550
Pager: (616)-390-3900
Email: Deepak.Bhatnagar@Haworthinc.com
From: dcusack@nyiso.com
Subject: AOL: Help Files
I was searching through the archives the other day and found a question
concerning the setup of the online help; however, I can't seem to locate
that archive again so I am sending the inquiry to the whole list. I am getting
the same "The server had an internal error and could not process the
request"
message when we click on some of the lower levels of the online help. We
are a Digital Unix 4.0D with Apps 11.0.2 just installed. Our webserver
version is 3.0.2. The funny thing is that the help works for a day or so,
then fails. If I recycle the web listener, it seems to work for a bit,
then fails.
I was wondering if the person that was having that same problem ever got a
resolution.
Thanks for any help in advance,
Deirdre Cusack
New York Power Pool
Hello All,
1. I have developed a form for Oracle Apps , now my requirement is ,
a) Which User is currently logged on,
b) Which Responsibility it is being used from.
How do I go about doing that ?
2. In System Admin GUI under
Security / User / Monitor form there is no data being queried
currently.
Any reasons for this ?
Also the columns in PID and SPID in FND_LOGINS are null why ?
Thanks in Advance.
Shamica.
From: "Rajesh Kadam" RKADAM1@email.mot.com
Subject: Re: AOL / SYS Admin Question !!!!
To answer your questions :
1. U can use the FND_GLOBAL package to get this information
a. Use the USER_NAME function of the package
b. Use the RESP_NAME function of the package.
2. The User Monitor form may not show any information if u have
disabled Sign-On Audit. Under System Profiles, check the profile option
"Sign-on:Audit Level". Even if u set this at the USER level, the PID and
SPID columns in FND_LOGINS should be populated.
Regards,
Rajesh Kadam
Oracle Field Support
From: "James J. Morrow" jmorrow@csac.com
Cc: jmorrow@csac.com
Subject: Re: SYSADMIN: Cancel Utility
All:
We have a problem whereby a concurrent job needs to be cancelled after it
has completed successfully in Oracle and is now in the unix print queue. We
converted from 10.5 to 10.7 just recently. Under 10.5 all jobs were owned
by the initiator/user under 10.7 the jobs are all owned by applmgr.
How have other organizations handled the cancelling of jobs under 10.7? We
do not want to have the users cancel their own jobs yet do not want to give
out the applmgr password.
Any help would be appreciated.
Curtis Sullivan
Aspect Telecommunications
IT Applications
The problem with that solution is that it requires the user to know which
print job is his/hers. (Actually, this would be fine... it is typically
reported in the concurrent request log) Although it would require a little
"training" to get the user to look at it.
This way, the user could submit the job through the concurrent manager (so
it would run as "applmgr", the user that actually owns the print job).
The particularly hard part is parsing the unix command line in a shell
script to handle parameters passed by the concurrent manager.
-- James
----------------------------------------------------------------------------
James J. Morrow ------- E-Mail: jmorrow@csac.com
Systems Consultant-----------------USSnail: 6380 LBJ Freeway #181
Computer Systems Authority---------------- Dallas, Texas 75240
Dallas, Texas------------------------------(972) 960-0180 x244
Sent: Tuesday, March 30, 1999 1:10 PM
Subject: Help on using DEBUG in Oracle Apps.
Hi ,
Could anybody throw some light on the usage of Debug from the Oracle
Applications -> Help -> Tools
menu. I cannot check it on (check mark before it - assuming it is a toggle
menu item like Trace). Are
there any profile options that have to be set?
If this thing does not work then is there anyone out there who has been
successful in using the Forms
debug mode (by regenerating the form with the debug mode checked on). I
tried doing that too and did
not meet with success.
Thanks,
Shrikant Sawant
From: Brenda Finley
Subject: RE: Help on using DEBUG in Oracle Apps.
the only way I've been able to use debug in the forms (v10.7 16.1SC) is to
put the following at the end of the command line (target) of the shortcut:
debug_messages=Yes
here's an example of ours:
C:\ORAWIN\BIN\AIAP45.EXE C:\APPS10\FND75\FORMS\US\FNDSCSGN
APPLSYSPUB/PUB@ocm FNDNAM=APPS debug_messages=YES
hope this helps!
*********************************************************************
Brenda Finley----------------- [Mailto:bfinley@standard.com]
Data Analyst IV, Business Technical Services
Standard Insurance Company
1100 SW Sixth Avenue, P3B
Portland, OR 97204
*********************************************************************
From: "Pat Fedorowicz" Pat_Fedorowicz@norstanconsult.com
Subject: RE: Help on using DEBUG in Oracle Apps.
That works, but the downside is all installed apps are now being traced
which could significantly affect processing. Virtually all the apps have a
debug profile option enabling you to select the appropriate app to track.
The option is available at any level. There are also other debug options
usually available when interfacing with other apps. For instance, sign in
AP, go to the profile window, and query for %Debug%. The query returns
about 8 or 9 debug values.
Pat Fedorowicz
Senior Consultant
Norstan Consulting
Sent: Wednesday, March 31, 1999 6:16 PM
Subject: Blocking Access During Close
Hi All,
My corporate GL group is looking for an efficient way to prevent people
not in the corporate GL group from running processes/reports during the
close process. We're looking for a one step process to block access to
run processes before the close and the same simple step after the close.
I'd appreciate comments on your experience or any ideas.
Thanks.
From: amareesh amareesha@sohm.soft.net
Subject: RE: Blocking Access During Close
You could probably terminate the internal concurrent manager. This will
kill all the pending processes. Then when you want to run the closing
process, activate the internal concurrent manager and immediately run the
closing process.
The other way is to exclude the Request menu from all the responsibilities
which I think would be a very tedious job.
Bye
From: Stephen Grant - Sun Scotland Stephen.Grant@uk.sun.com
Subject: RE: Blocking Access During Close
Hi there,
If like us, you want to keep one queue active for period close reports, etc, try
setting min_processes 0 on fnd_concurrent_queue_size for all the queues you
want closed. Then validate your conc manager status.
cheers,
Steve
From: "Krzes, Joe" JKrzes@smith.com
Subject: RE: Blocking Access During Close
We did this once by putting an expiration date on the menu or was it
responsibilities and deleting the expiration to let users gain access again.
This also allowed them to access their non-gl responsibilities.
From: "Rajesh Kadam" RKADAM1@email.mot.com
Subject: Re: Blocking Access During Close
The easiest way for this would be to check the "Run Alone" flag in the
concurrent program definition of your "closing process". This
will prevent any other requests in the same logical database from running
when the closing process is running and gives an exclusive
control to the closing process.
Hope this helps!
Regards,
Rajesh Kadam
Oracle Field Support
From:"Palanisamy, Logo" LPalanisamy@fpc.fujitsu.com
Subject:Customizing GUI toolbar : 10.7 SC
Hello All,
I would like to add an icon for 'Help | View My requests" function to the
standard 10.7 SC GUI toolbar. This way users don't have to first click the
"Help" pull-down menu and then choose "View my requests". Just a click on
the icon will do.
Is it possible to customize the Oracle Apps tool bar? If yes, how.
Would appreciate your input. Thanks in advance.
Cheers,
Logo Palanisamy
From: "Wahed Ali" WALI@ca.oracle.com
Subject: Re: Customizing GUI toolbar : 10.7 SC
Hi,
Try to copy the Logic available from Help View help my requests
menu item to the new ICON (BUTTON) in WBP trigger. If you are on UNIX,
don't generate at your local machine. Just Save the changes in Local
machine and generate at UNIX.
Cheers,
______________________________________________________________________
Wahed Ali Mohammed
Staff Consultant,
Oracle Canada IT,
110 Matheson Blvd. West,
Mississauga, Ontario, Phone: 905 890 0800 - 6360
Canada L5R 3P4. wali@ca.oracle.com
_____________________________________________________________
Sent: Monday, April 05, 1999 6:12 AM
Subject: Blind Queries
Is there a way to stop the users from running a blind query? i.e. hitting
the
F8 key by mistake.
From: CFowler@littonapd.com
Subject: RE: Blind Queries
Yes there is a way to stop/kill blind queries. We are 10.7 16.1SC. You
will need to modify your oracle.ini file. Go to the [net23] section and add
the following line of text after the last line in the [net23] section:
YIELD=YES
Example:
[net23]
LOCAL=prod
REPLICATE_GROUPS=netora,resource,help,ping,sample,cfg23
REPLICATE_BIN=sns, dummy_sns
REPLICATE_VARIABLES=prd_path
PRD_PATH=C:\ORACLNT\NETWORK\CFG
YIELD=yes
Restart your Oracle session in order to use ctrlC to interrupt queries.
This change needs to be done on each PC.
I hope this helps...
From: ddisalvo@hearstsc.com
Subject: RE: Blind Query Cancel Key Sequence
I can't get this to work, is it only for the character based version??? We are
on 10.7 GUI....Dom
From: "Cochran, John" John.Cochran@photomask.com
Subject: RE: Blind Query Cancel Key Sequence
With 11.0.x and I believe 10.7 NCA, if you apply Developer 2000 rel 1.6.1
patchset 6 (and IO patches), a new feature is included which allows you to
cancel long queries. You can even set the time until the cancel query dialog
box pops up.
I have tested it here and it works fine. A little quirky, but it works.
-John
John Cochran
Solutions Architect - Information Technology
DuPont Photomasks, Inc.
(512) 310-6384
Sent: Thursday, April 15, 1999 5:56 PM
Subject: Patches
Hi,
How do we find out the patches that are applied to the database?
We have two instances where the setups are almost identical but we
cannot
create basic invoice in one of the instances. The forms version on both
the
instances are the same.
There may be some database patches that are different. Any scripts to
find
out the database patch versions?
The error in trying to create a manual invoice is (naviagation:
transactions
- transactions)
is FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01400
ORA-01400: cannot insert NULL into
("AR"."RA_CUSTOMER_TRX_LINES_ALL"."EXTENDED_AMOUNT")
ORA-06512: at "APPS.ARP_INSERT_LINE_COVER", line 675
ORA-06512: at line 1
Regards.
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: Patches
In $APPL_TOP there is a file called applptch.txt which should have a log
of all application patches.
Hi all,
My consultant run the mtl_system_items_interface but terminated
the concurrent job halfway. Now the table has been locked. Any idea to
remove this lock. Thanks
regards,
*******************************************************************************
Rudy Wahab Phone: 07-454 2111 ext 211/313/218
System Analyst email: rudy@fcm.ed.fujitsu.co.jp
Information Services Section
Fujitsu Components (M) Sdn. Bhd.
Batu Pahat, Johor.
Malaysia
*******************************************************************************
From: Arvind Gidwani agidwani@cisco.com
Subject: Re: removing table lock
Rudy :
Login as sys or system in your database.
select * from dba_dml_locks where name 'MTL_SYSTEM_ITEMS_INTERFACE';
this will tell you which sessions are holding a lock on this table.
Once you get these sid's all ypu have to do is
kill the sid's
select sid,serial# from v$session where sid in
(select * from dba_dml_locks where name 'MTL_SYSTEM_ITEMS_INTERFACE')
alter system kill session 'sid,serial#';
and once the session has been killed all the locks will be released
Arvind
Sr Database Administrator
Cisco Systems Inc.,
170 West Tasman Drive
San Jose, CA 95134
Email : agidwani@cisco.com
Ph : (408)-527-1360
Fax : (408)-526-6368
Sent: Tuesday, April 20, 1999 4:20 PM
Subject: Reg: Table owner
Hi all,
May be a simple one still I need a help; I wanted to know who is the owner
for a table e.g AR is owner for RA_CUSTOMERS.
Can any one help me how to query this as APPS user?
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: RE: Table owner
Hi
Type as
select object_name,owner from all_objects where object_type
'TABLE'
HTH
Ravindra Yerraguntla
Consultant
(770) 338 3659 (W)
Pager:404-278-5886
G1447c@email.mot.com
ravindray@hotmail.com
Sent: Wednesday, April 21, 1999 6:34 AM
Subject: Question on Documentation of Customizations
Hi All,
I am hoping that someone will be able to shed some light/insight on this.
We were able to stay "vanilla" for almost two years. We are just now
getting into customizations for Oracle applications. We have ALRT, AP, AR,
BOM, CAP, CST, ENG, FA, GL, INV, MRP, OE, PA, PO, QA, SERVICE, WIP
applications installed. Currently we have 7 different "mega" or "cum"
patches in-house that are being tested in our only "vanilla" instance so I
am trying to get a handle on this. Before any these "cum" or even one-off
patches get moved forward they all need to be looked at to see if and how
they might affect any customizations that have been done.
I was wondering how other companies are keeping track of any customizations
that they have done?? We have created a "custom" application to register
all custom reports, etc. We have set up separate directories to keep the
custom software files separate from the vanilla software. I am more
concerned as to how to document the customizations so that when new patches
come in, which they will as we all know, it will make it a little easier
(hopefully) as to how to identify what objects, etc. need to be looked at to
see if the customization will be affected by the new patch(es). The types
of customizations that we have are forms, database triggers, etc. After
finding any patches that affect a customization then the customization will
need to be retrofitted to take in account the changes made by the patch(es).
We are currently on 7 3.3.4 10.7 16.1SC Sun Solaris 2.5.1, soon to migrate
to 7.3.4 10.7 16.1SC IBM AIX 4.3.2.
Any ideas or thoughts would be greatly appreciated!
Thanks in advance...
Candace
From: Rama Krishna Rama.Krishna@hds.com
Subject: RE: Question on Documentation of Customizations
Here are some suggestions:
1. Create a custom application and register , which
you have already done.
2. Create a custom user for the custom application
at the database level and create all objects
under this custom schema and then create the
synonyms for these objects in APPS account.
3. Maintain seperate directories at the OS level for
all the custom scripts. The directories may include
among others , bin, srw,sql,forms etc..
4. Make it a standard for all the customizations that you
prefix the letters "XX" to the names of the objects
as Oracle has supposedly stated they are not going
to use up these letters for any of their future
development. In other words, you would NOT, any time
in the future, have a table name called XX_???????.
5. If you doing customizations to the Forms 4.5 , the
best bet would be to make use of custom libraries.
6. Last, but not the least, maintain log/data of all the
customizations you are doing.
There may be some other suggestions from our friends on this
list.
Rama Krishna
Applications Consultant
Fortuna Technologies
Sunnyvale,CA
Thank you for the information. We have pretty much have done what you
suggested in items 1-5. It is item 6 that I am still having some problems
with. What types of information have you included in the documentation of
the customizations?? I am trying to come up with something that will be
detailed enough, but yet not so much detail that it takes forever to
document. Any help/information would be greatly appreciated.
Thanks again...
Candace
From: Rama Krishna Rama.Krishna@hds.com
Subject: RE: Question on Documentation of Customizations
Hi Candace,
The decision is certainly tough. There is no best documentation
method. It all depends on what is the level of customization that
is being attempted for each of the "GAPS" and depending on that
you need to have the documentation in a database and the database
should be accessible to all the IT. But, any good documentation
should have the following among others in ONE document instead
spreading it into multiple documents ( This happens in Oracle's
AIM documentation - and the documentation effort is phenomenal
in this method).
-- Brief overview of the GAP.
-- The reason for this gap and why it is not addressed thru
business reengineering.
-- Various alternatives listed and discussed for their +s & -s
-- Finalization of a method and the reasons thereof
-- Very high level design of the method.
-- Pseudo code for the programs.
-- Sample log information of the program when run.
-- Names of the files and their locations on the OS
-- Execution methodology.
-- Possible error occurences and their information
-- Troubleshooting for the all the instance of the errors.
-- Testing methodology
-- Open issues.
Not to overemphasize any code that is developed for customizations
should have been commented "sufficiently" so that any day some
other programmer can understand and take up from there. Finally,
whenever the systems are being upgraded, a fresh look at the
customization already made has to be taken to see whether or not
the customized functionality is available in the latest realeases
of the applications.
I hope this somewhat helps you. And as you have said this
documentation effort should not exceed the original program
development effort then it is not cost-effective.
Rama Krishna
Applications Consultant
Fortuna Technologies
Sunnyvale,CA
From: siddhartha nandi sid_nandi@yahoo.com
Subject: RE: Question on Documentation of Customizations
Hi Candace,
I agree with the methodology that Rama has suggested, we probably
naming them differently. Our custom development standard has the
following phases:
1. Development Requirement Specification.
2. Development Work Plan.
3. Development Design Specification.
4. Development Programming Solution.
5. Development Test Plan.
6. Development Implementation Plan.
7. Development Support Plan.
If you need further clarification, pl. let me know.
Sid.