From: Steve_Deackoff@air-water.com (Steve Deackoff)
To: Multiple recipients of list
Subject: Re: DEBUG Facility OraApps 10.7 SysAdmin
I know this works for "Examine", you can set it at the User level so they are not prompted for the password. Note of caution:, it allows updates to values in the database bypassing Application Rules. It is like letting the developers at the SQL*Plus prompt.
This is a paste from the Documentation
Utilities: Diagnostics
This profile option tells you whether the diagnostic utility Examine is available without an ORACLE database password and controls whether Oracle error messages appear when profile SQL validation fails. You cannot change this profile option.
"Yes" means you can automatically use Examine when the choice is on the menu.
"No" means you must enter a password to use the Examine utility when it appears on the menu.
Users can see this profile option, but they cannot update it.
This profile option is visible and updatable at all four levels.
Level
Visible Allow UpdateSite
Yes YesApplication
Yes YesResponsibility
Yes YesUser
Yes YesThe internal name for this profile option is DIAGNOSTICS.
Regards,
Steve Deackoff
Concurrent Program - errors when run using CONCUB
Date: Mon, 30 Aug 1999 10:42:23 +0400
From: Srinivas Sreepada satncr@emirates.net.ae
To: OraApps-L@cpa.qc.ca
Subject: CONCSUB
Hi,
I am trying to submit a concurrent program from the O/S using the CONCSUB
function without success, following is the script used.
CONCSUB apps/apps\gl\"General Ledger Super User"\OPERATIONS\WAIT=Y
CONCURRENT\GLPPOS\"POSTING"
I am trying this out in Vision Demo for the GL Posting program, I donot get
any error message after i run this script i get back the prompt immediately
although i have given the wait option as 'Y'
Responsibility Name : General ledger Super User and User Name is Operations
What is that I am doing wrong ?
Thanks
Srinivas
Date: Mon, 30 Aug 1999 03:34:42 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: CONCSUB
You first need to have the request id of the posting from the CONCSUB
and then update the GL batch with a status of S that is to be posted.
It is a little tricky.
Basically, Submit the posting with a start date into the future. Then
capture the concurrent request from the posting. Now take that request
id and go to GL_JE_BATCHES and update the desired batch for posting.
###UNIX shell
echo Request the posting
set -A ret_value `CONCSUB \
$FCP_LOGIN \
'SQLGL' \
$resp_name \
$user_name \
WAIT=N \
CONCURRENT \
'SQLGL' \
'GLPPOS' \
START=$hold_date \
$sob_id \
'101' \
$post_id`
### get the request id out of the return string from the CONCSUB
command
post_req_id=${ret_value[2]}
###sqlplus
update gl_je_batches
set request_id=&&1,
posting_run_id=&&2,
status='S'
where je_batch_id = &&3;
update fnd_concurrent_requests
set requested_start_date = sysdate
where
request_id = &&1;
It would be possibl to do this in pl/sql and maybe someone will post
that idea.
Kevin
===
Kevin Gillins
Oracle Applications Consulting
WEB PAGE http://www.geocities.com/SiliconValley/4946
Passwords - changing
Date: Tue, 31 Aug 1999 11:14:18 +0800
From: Ravi Kumar Meda rkmeda@quark.com.sg
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: how to change the passwd's
can I have a method how to change the passwords's of the
applsys
apps
applsyspub schemas and also of the
sysadmin
Thanks in advance
Date: Tue, 31 Aug 1999 11:37:54 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
To: oraapps-l@cpa.qc.ca
Subject: Re: how to change the passwd's
Hey Ravi kumar !
Here is the detailed steps for changing Application Passwords
Changing Oracle Applications Passwords:
Sign on to Oracle Applications as the System Administrator.
WARNING:
Running the following steps out of order may lock
you out of Oracle Applications.
Attention: When changing the APPS password, ensure all
concurrent managers have been shut down first.
1. Log in to SYSADMIN and navihgte to the
screen ORACLE USERS ( Security-ORACLE- Register)
2. Enter the database Username and Change the password
3. Confirm the password and Save ( Action - Save)
4. Repeat the steps 2 and 3 in a loop.
The passwords for APPLSYS and APPS including MRC ( If u have
MRC) MUST BE same.
Step2 :
Then login to SQL plus using SYSTEM and chanage the passwords for USers
AGAIN)
SQL ALTER USER GL identified by New password
SQL ALTER USER APPS identified by new password
SQL COMMIT;
Try login to apps immediately to check the changes,
All the best !
Regards,
K Gopalakrishnan
Database Administrator
GE Medical Systems Limited,
X Ray (South Asia )
Date: Tue, 31 Aug 1999 08:35:11 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Presentation on how to change the passwd's
For the presentation please click here
Date: Tue, 31 Aug 1999 17:18:06 +0400
From: "Mehul Zaveri" mehulapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: how to change the passwd's
You can follow...
apps,applsys should have same pass (should be changed at same time)
When changing apps and applsys passwords, do not try to change any other
passwords unless logged out and log-in. Also make sure no users are
logged-in and concurrent manager should be down.
Goto sysadmin-security-oracle-register-execute-query
type new password for those users.
Assign these same passwords for the user from sqlplus too) You should get
this message anyway.
Keep log-in from other session as sysadmin, in case of problems this will
help.
HTH
Mehul Zaveri
Oracle DBA
EPPCO-DUBAI
Request Type change after submitting
Date: Wed, 1 Sep 1999 13:56:59 -0400
From: "=?ISO-8859-1?Q?Alain_Tr=E9panier?=" altrepan@agropur.com
To: "Oracle Applications Forum" OraApps-L@cpa.qc.ca
Subject: Request type in Concurent manager
We are working with version 10.7 CHUI. Is there a function to change the
request type of a request after we submit ?
My request is scheduled to run during the night but my user have an
emergency and require this report immediately.
Thank for your help.
Alain Trépanier
Management information system, project manager
(514) 392-6592 ext. 2560
Date: Wed, 1 Sep 1999 12:04:29 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Request type in Concurrent manager
The administrator can Navigate to Concurrent - Requests. Query up the
Request ID, or Pending, Or by use -- whatever makes sense. Select the
appropriate request and select Open. Make the necessary change to the =
""To
Start" time in the Dates zone.
HTH...
Karen Blackwell
DBA / System Administrator
RockShox, Inc
408.570.4912 tel
408.435.7468 fax
Date: Wed, 1 Sep 1999 16:05:11 -0400
From: John Sweeney jsweeney@goaa.org
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Cc: "'altrepan@agropur.com'" altrepan@agropur.com
Subject: Request type in Concurent manager
Not sure if this works exactly the same with your version of Oracle Apps.
We are running 10.7SC161.
Sign-on with System Admin responsibility and view the concurrent request
you want to run immediately. Open the concurrent request up so you
can see all the parameters (Program, Requestor, Phase, Status, Submitted
date, To Start date, etc.). Change the date/time in the To Start field to
the current time. Then save your change. The request should start immediately.
Date: Thu, 2 Sep 1999 10:12:10 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: Request type in Concurent manager
Going to "concurrent programs", you can then resubmit the program
immediately.
Conflict Resolution Manager
From: Venkatayogi, Swami [mailto:SVenkatayogi@comintertech.com]
Sent: Friday, August 27, 1999 7:12 AM
To: Multiple recipients of list
Subject: conflict resolution manager
We have a serious problem with our conflict resolution manager.
We need to run Pick Release and since it is incompatible with itself
we defibed a separate manager for the Pick Releases
and now we see they are queued up in the conflict resolution manager
and the CRM does not seem to clear them.They are being queued up since
morning . Could anyone please help us out on this issue since it's
production
issue and we have a TAR open with Oracle but with little help.
Any help regarding why CRM is not clearing out the requests ( It is active
and
running ) is greatly appreciated.
We are on Oracle 7.3.4.4 Apps 10.7 Char and HPUX 11.0
Thanks and regards,
Swamy Venkatayogi
DBA,Commercial Intertech.
From: Innamuri, Chakrapani [mailto:cinnamuri@btg.com]
Sent: Friday, August 27, 1999 7:30 AM
To: Multiple recipients of list
Subject: RE: conflict resolution manager
Hi,
Did you declare the Pick Release as "incompatible" with itself
in Define Conc. Programs screen. When once you do this, it should
take care by itself.
Otherwise,
Please check that and "hold" other requests for a while.
You may have to manually release the HOLD for each one of the requests
in queue for right now and finally after last one in the queue
everyting should be fine with the Incompatability rule you declare in
"Define conc. Programs "
If this Rule come by default, please let me know.
I am not aware of this as we are using only Oracle Financials.
Thanks,
-chakrapani
From: Vettraino, Dawn [SMTP:Dawn.Vettraino@ps.net]
Sent: Friday, August 27, 1999 4:58 PM
To: Nguyen, Hien; Whitefield, Margaret; 'cinnamuri@btg.com';
'SVenkatayogi@comintertech.com'
Subject: RE: conflict resolution manager
We have the same exact problem when the Picks amount over 1024 requests
left
over from the weekend.
We are running: Oracle 7.3.4.4, HPUX 10.2, Apps 10.7 char
We have worked with a really good oracle analyst and got a bug fix for
this
problem. Haven't tried it yet, but maybe you can get a fix too? The
oracle
analyst suggested another solution would be to not use the CRM by changing
the profile option Concurrent: Use ICM = Yes, so that it would force
using
the Internal manager to resolve conflicts instead of CRM. The analyst
name
is michael holmes -- mpholmes@us.oracle.com
Bug# 893856
Maybe this will help you out.
Dawn Vettraino
Perot Systems Corporation
Date: Thu, 2 Sep 1999 09:52:47 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
To: oraapps-l@cpa.qc.ca
Subject: conflict resolution manager
Thanks a lot for all your help .
We could finally get over this problem by doing quite a lot of things
actually.
We purged our fnd_concurrent_requests from 150000 to 40000 rows.(This was
suggested by Oracle Analyst)
We had to rebuild indexes on most of the FND tables.
We set the ICM to resolve the conflicts instead of conflict_resolution
manager ( Even our Oracle Analyst Zakir suggested this )
The most important thing was however to tune some of the shipping reports
that were taking
like 15 minutes to less than a minute and see that they complete faster
for the next one to be picked up.
Over the weekend we rebuilt all the indexes in the OE,INV,AP,AR,BOM and
other important schemas.
I am not sure which one was of big help but in this week till now things
seem to be going better.
Thanks again for your help.
Swamy Venkatayogi
DBA Commercial Intertech
Apps Logon - piggyback
Date: Fri, 03 Sep 1999 19:55:47 GMT
From: sinnott@ec.rockwell.com
To: OraApps-L@cpa.qc.ca
Subject: Apps Logon - Piggyback
I am trying to use the FND_USER table as a way of validating a user tor a
non-Oracle application.
The Apps logon form uses the FND_USER table to log a user into apps.
Is there an alternative way that I pass the user id and password to Oracle
through a stored procedure or a piggy back on the Apps Logon where I get a
true, false or responsibility list back depending on whether the user is
valid?
John Sinnott
630-227-8684
pager 630-298-3838
Date: Sat, 4 Sep 1999 09:12:40 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Apps Logon - Piggyback
Using the Oracle password encryption seems to be the obstacle here. You may
want to, however, look into creating a new table. The user information
could be updated by creating an insert/update trigger on FND_USER. The
password could be updated by the same triggger with some other 'known'
algorithm so that you would be able to decipher it and either permit or
refuse access. Please let me know if it works.
Regards
Date: Sat, 4 Sep 1999 06:56:58 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Apps Logon - Piggyback
You could register your application with AOL to use the security
offered. Once complete there you could then jump off to your custom
application.
Exiting out of Apps - abnormal
Date: Fri, 3 Sep 1999 14:59:14 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
To: "'Multiple recipients of list'" oraapps-l@cpa.qc.ca
Subject: Exiting out of applications
Hi All,
I am exiting out of applications when I try to query Tax Codes & Rates form
in AR Module.
Navigation pat: Navigate/setup/Tax/Codes. Did any body has this problem??
Any workarounds will be greatly appreciated.
We are on 10.7 NCA on HP UX -11.
TIA
-Harish
Concurrent Manager in Warning Status
Date: Wed, 8 Sep 1999 15:41:24 +0930
From: "Stuart, Robert" Robert.Stuart@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Concurrent Manager in Warning Status
Hi all,
Does anybody know how to make a customised shell script concurrent program
finish with a status of 'Warning' in the concurrent manager queue.
Thanks in advance.
Regards
Rob Stuart
CMG F2000 - DCI Team Leader
Phone: (02) 9688 9702
E-Mail: Robert.Stuart@boral.com.au mailto:robert.stuart@boral.com.au
Date: Wed, 8 Sep 1999 10:07:34 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Concurrent Manager in Warning Status
Rob,
The following instructions should do the job
exit 0 - Completed Normal
exit 1 - Completed Warning
exit 2 - Completed Error
Use the exit instruction wherever required in your shell script. I have
used exit to indicate error and normal completion, but try the one for
warning and let me know
AJ
Notifications at Signon to Apps
Date: Wed, 8 Sep 1999 16:21:49 +0100
From: alexandre.gravelin@degremont.com
To: oraapps-l@cpa.qc.ca
Subject: Notifications as start screen
We are in r11.0.3, and I would like to know if some of you have found a way to
have the Notifications screen automatically open when a user connects to the
application
This is particulary helpful for PO notifications, in order to inform directly
the user of his urgent tasks
It was possible in character mode, but I don't know how to do it in NCA
Thanks for your help
Alexandre GRAVELIN
Manufacturing consultant
FRANCE
fnd_request.submit_request generating request_id as zero
Date: Fri, 10 Sep 1999 14:59:15 -0500
From: "Mark Bohnenstingel" mark_bohnenstingel@starkey.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: AOL: Submit_Request
I have an update trigger on fnd_concurrent_requests to fire for a
specific program when the actual_completion_field is updated. Within
this trigger I am using the fnd_request.submit_request to submit another
program. My problem is that the request_id returned from submit_request
is zero. I have used this before without any problems in other
packages/procedures. I am starting to wonder if this may be a mutating
trigger type thing, although I am not receiving any error. Has anyone
encountered such problems?
Thanks
Mark Bohnenstingel
Starkey Laboratories, Inc.
Date: Sat, 11 Sep 1999 20:52:58 PDT
From: "Alok Chadda" alok_chadda@excite.com
To: mark_bohnenstingel@starkey.com
Cc: oraapps-l@cpa.qc.ca
Subject: RE:AOL: Submit_Request
Mark-
You can find steps to submit concurrent request on following site:
http://www.geocities.com/SiliconValley/Network/9828/
I have used them in the past to submit concurrent request from DB trigger.
HTH
Alok