Custom Zoom in 10.7 NCA not working
Date: Thu, 22 Jul 1999 11:46:03 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: Zooms
Hello
I am having trouble with a custom zoom in 10.7 NCA
I have added the code to the custom library but when I navigate the form the
Zoom is not enabled. Can you tell if there is anything wrong with the code?
Thanks
function zoom_available return boolean is
form_name varchar2(30) := NAME_IN('system.current_form');
block_name varchar2(30) := NAME_IN('system.cursor_block');
begin
if (form_name = 'MRPSCPWB' AND block_name = 'MRP_ORDERS') THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
end zoom_available;
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 = 'ZOOM') then
if (form_name = 'MRPSCPWB' and block_name = 'MRP_ORDERS') THEN
FND_FUNCTION.EXECUTE(FUNCTION_NAME = 'WIP_WIPDJMDF_SIMULATE',
OPEN_FLAG = 'Y',
SESSION_FLAG = 'Y');
END IF;
ELSE null;
END IF;
end event;
Beth Carver
Date: Thu, 22 Jul 1999 16:52:05 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: Re: Zooms
This is just the guess. Did you compile the Custom Library? The other thing
is you have to make sure you are using right function name. I just did this
functionality for my current client.
Let me know if I can help you in this.
Good luck.
Executing Browser query from Concurrent Manager
Date: Thu, 22 Jul 1999 13:31:19 EDT
From: DIGIACKG@aol.com
Subject: Executing Browser From Concurrent Manager
Currently using Browser 2.0, might be upgrading to 3.0 shortly.
Would like to execute Brower queries from Concurrent Manager and direct
output to a Unix directory.
Can this be done w/ v2.0 or 3.0 ?
Any tips appreciated.
Thanks,
Kevin
Folders in 10.7 SC
Date: Sat, 24 Jul 1999 21:19:23 -0700
From: Faun deHenry faun@sancity.com
Subject: RE: Folders in 10.7SC
Application Gurus:
Has anyone out there worked with folders in 10.7SC?
A client is experiencing difficulties with getting folders to work
properly. In addition, there seems to be some question about how folders
are actually supposed to work.
It seems that the default folder "hangs" the application any time a user
tries to perform a query or a sort (Show Order By).
Does anyone have any ideas?
Thanks!
Faun deHenry
Director
San City Productions, Inc.
800.966.0169
Linking Concurrent Manager to the Concurrent Request it ran
Date: Mon, 26 Jul 1999 14:59:48 -0400
From: Jeffrey Beckstrom JBECKSTROM@gcrta.org
To: OraApps-DBA@cpa.qc.ca, OraApps-L@cpa.qc.ca, oranca-l@doug.org,
Subject: which concurrent manager ran a request
I am reviewing the number of concurrent managers we have running and would
like to know if it is possible to determine which concurrent managers ran a
request, i.e. inventory, standard, etc.
Jeffrey Beckstrom
Database Administrator
Information Systems
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
Date: Tue, 27 Jul 1999 00:17:52 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
Subject: Re: which concurrent manager ran a request
hi jeffery, i cant remeber but i think if u use the system adminsitrator
responsibility, and navigate to the concurent manager menu and query to
see all the managers that r running , u can select from the tab the
processes for each by selecting a particular manager, hope that helps
Naqi
Date: Tue, 27 Jul 1999 00:20:21 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
Subject: Re: which concurrent manager ran a request
jeferry , sorry i meant u can select the tab for requests qhich tells u
the requests hadled by each manger not processes.
Naqi
How to get Conc Req. ID and Apps User Name within a PL/SQL stored procedure
Date: Tue, 27 Jul 1999 10:21:58 +0530
From: NripendraS@NIIT.com
Subject: PL/SQL Stored Procedure (concurrent program)
URGENT :
I have a concurrent program that I have made using PL/SQL Stored
Procedure.
Now I want to get an output report for the program.
As u know the file has to be created in a particular directory with name
as Apps User Name.Request ID
My problem is :
How to access concurrent request id and apps user name within a PL/SQL
stored procedure ?
Hope to get a solution from u guys.
Thanks in advance,
Date: Tue, 27 Jul 1999 08:50:34 +0200
From: Zaman Joan ZamanJ@mail.europcar.com
Subject: RE: PL/SQL Stored Procedure (concurrent program)
fnd_profile.get_value(profile option) will give you the user name. The
specific user profile you will have to check.
When you launch the concurrent program from within pl/sql you get a
request id.
Hope this helps.
Joan Zaman.
Date: Tue, 27 Jul 1999 08:31:17 +0100
From: "Mahendra, Anil" Anil.Mahendra@ncp.co.uk
Subject: RE: PL/SQL Stored Procedure (concurrent program)
Try the following sql:
select substr (outfile_name, 1, instr (outfile_name, '/', -1)-1) path,
substr (outfile_name, instr (outfile_name, '/', -1)+1) outfile
from fnd_concurrent_requests
where request_id = fnd_global.conc_request_id;
fnd_global.conc_request_id returns the concurrent request id.
Have a look at your fnd_concurrent_requests table owned by APPLSYS.
Regards
AJM
Date: Tue, 27 Jul 1999 17:10:23 +0530
From: NripendraS@NIIT.com
Subject: PL/SQL Stored Procedure (concurrent program)
Thanks All U guys. It has really worked.
Nripendra
Date: Tue, 27 Jul 1999 09:39:40 PDT
From: "Murali Parthasarathy" mparthas15@hotmail.com
Subject: Re: PL/SQL Stored Procedure (concurrent program)
Hi,
We had a similar request where a reports generated by a report set
had to be copied to a different directory. We did the following.
We called the concurrent program from a another program. Let us say
PROG.sql is the program which call the program CONC1.
Register PROG as concurrent program with execution type as
Procedure
Use the Function FND_SUBMIT.... . This returns a request id.
There is another fnd_status function which accepts the request id and
gives back the completion status. If the Request has completed
successufully. Submit another concurrent request( from the PROG program
using the FND_SUBMIT ) with execution type as HOST to navigate to
$APPLCSF/$APPLOUT , to find the Report File. We have done this and it works fine.
Hope this helps
Date: Tue, 27 Jul 1999 17:16:43 +0530
From: Susan susan_jackson@mail.usa.com
Subject: Re: PL/SQL Stored Procedure (concurrent program)
Hi NripendraS
I am a bit curious as to what was the process
really about. Could you send the process from
creating the procedure to running the report.
I being a novice and am deeply interested to
learn the same.
Regds
Susan
Submitting multiple Requests
Date: Tue, 27 Jul 1999 16:34:08 -0400 (EDT)
From: Leanne Andre CMCILMA@NJTRANSIT.STATE.NJ.US
Subject: AP: Report Submission
Hello everyone,
My client would like the Payables Approval process to run automatically for
"All" invoices twice a day (say at 11:00 am and 3:00 pm). The options
available for resubmitting jobs on the Submit Requests form does not appear
to
allow you to specify two different times daily to run a specific job. So, I
thought the easiest way to meet this requirement would be to set up TWO
Payables Approvals jobs -- one to run at 11:00 am everyday and the other to
run
at 3:00 pm everyday.
Does anybody see any problems with this? Is there an easier and/or better
way
using standard functionality? We are on 10.7 NCA.
Thanks in advance,
Leanne
Date: Tue, 27 Jul 1999 13:48:33 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: Report Submission
This is exactly how we are running multiple processes in a given day. We
have not had any problems with this practice. We are also on 10.7NCA,
7.3.3.6. The only "concern" might be that the process completes in the time
allotted between runs. (Although I am sure it won't run that long.)
Hope this helps.
Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax
Date: Tue, 27 Jul 1999 13:37:35 -0700
From: Satish Reddy SReddy@zilog.com
Subject: RE: Report Submission
another way is ---U can use periodic alerts to run concurrent programs
User authentication
Date: Wed, 28 Jul 1999 02:17:45 PDT
From: "simon daniel" ora_apps@hotmail.com
Subject: user authentication!! (urgent)
Hi ,
I am working on a custom web development . i would like to know which
package in the database has the user authentication and responsibility check
up code.basically i am asking the user to enter his apps. account in the web
form and then would like to validate his account.
Appreciate all help..
Thanks
Simon
If no specific Form name is given in a Custom.pll
Date: Wed, 28 Jul 1999 13:20:18 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
Subject: GEN: Custom.pll
If you do not specify a form name in the custom.pll does the code fire for
every form?
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
Date: Wed, 28 Jul 1999 15:44:43 -0400
From: "Robin Easterlin" rce@oew-online.com
Subject: RE: GEN: Custom.pll
You must explicitly state the form name in the custom.pll for the zoom to
work. If anyone knows otherwise, please reply.
Robin
Date: Wed, 28 Jul 1999 17:32:23 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
Subject: RE: GEN: Custom.pll
Does it have to be a zoom?
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rfsuny.org
Date: Thu, 29 Jul 1999 11:17:27 -0400
From: "Hanke, Brent M." Brent.Hanke@alcoa.com
Subject: RE: GEN: Custom.pll
No. Custom.pll can be used for other things as well (in addition to zoom.)
Brent Hanke
From: Messick Charles J TSgt AFPC/DPDIAC
[mailto:Charles.Messick@afpc.randolph.af.mil]
Sent: Thursday, July 29, 1999 8:43 AM
To: 'bartolmi@rfsuny.org'; 'rce@oew-online.com'
Subject: RE: GEN: Custom.pll
It does not *have* to be a zoom. If you expect the zoom to work then you
must supply the form function to zoom to, otherwise you get an ugly error
message. As an answer to your *exact* question...you do not *have* to
specify the form name in custom for anything. Although, why you would want
to do this is beyond me. Generally, every form calls the custom library
from a predetermined set of triggers. Whatever you have within the event
procedure is what will be executed. Thus, if you wanted to reset a global
variable whenever When-New-Form-Instance fired you would code it in the
event procedure within custom. Don't forget to check the event name or your
code will fire for every call to custom. To restrict it to a form and the
event, supply the form name and the event name.
I hope that answers your question. My apologies, I am unable to send to the
Apps Forum from this address so if you wish to share this info with the
world.... ;-)
TSgt CJ Messick
HQ Air Force Personnel Center
cj.messick@afpc.randolph.af.mil
The opinions expressed are those of the individual and do not represent an
official position of the United States Air Force.
Reading applptch.txt file
Date: Thu, 29 Jul 1999 11:19:11 -0400
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
Subject: reading applptch.txt file
How does one interpret the applptch.txt file. I'm particularly interested in
the 'executed the following actions' section.
What are the columns displayed? I.E. ----
sql ar patchsc/107/sql ARCUTILS.pls none none none package &phase=pls
A lot I can guess and feel comfortable, but what are the 'NONE's
representing?
Identify Concurrent Request against a given Oracle SID
Date: Thu, 29 Jul 1999 14:43:54 -0400
From: Jeffrey Beckstrom JBECKSTROM@gcrta.org
Subject: identify concurrent request given an Oracle sid
I am looking for information on what tables to use to identify a running
concurrent request given that I know it's Oracle sid.
Jeffrey Beckstrom
Database Administrator
Information Systems
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
Date: Thu, 29 Jul 1999 15:38:56 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: identify concurrent request given an Oracle sid
Hi,
Try this: click here for the sql
Date: Thu, 29 Jul 1999 15:14:19 -0400 FND_REQUEST.SUBMIT_REQUEST gives error :FND CONC-Illegal printer spec
Date: 29 Jul 99 14:57:48 EDT
Date: Thu, 29 Jul 1999 14:38:30 CDT
Date: Thu, 29 Jul 1999 15:51:00 -0500
Date: 29 Jul 99 14:13:19 MDT Request running since 21st July
Date: Thu, 29 Jul 1999 13:25:04 -0700
Date: Thu, 29 Jul 1999 16:31:50 -0400
Date: Fri, 30 Jul 1999 08:24:45 -0400
Date: Fri, 30 Jul 1999 14:07:40 +0100
Date: Mon, 2 Aug 1999 11:09:34 +0700 Unable to kill a process. Working on Rel 11.0.1 with MRC
Date: Thu, 29 Jul 1999 18:57:38 -0400
Date: Fri, 30 Jul 1999 10:44:15 +0530
Date: Fri, 30 Jul 1999 12:43:40 +0700
Date: Fri, 30 Jul 1999 19:19:20 +0300
Date: Fri, 30 Jul 1999 15:42:33 -0400
Date: Mon, 02 Aug 1999 16:25:02 +0700 Identifying Concurrernt Program
Date: Fri, 30 Jul 1999 07:26:17 -0400 View reports from Concurrent Manager
Date: Mon, 02 Aug 1999 16:00:24 CDT
From: "Jacques, Pascale (SSC)" pjacques@ssc.knightridder.com
To: "'oraapps-dba@cpa.qc.ca'"
Subject: RE: identify concurrent request given an Oracle sid
Select Request_Id Request, User_name Who, s.sid,s.serial#, p.pid,
p.spid OS,
concurrent_program_name Program,
To_Char(Actual_Start_Date, 'MM-DD HH24:MI') Started
from apps.Fnd_Concurrent_Queues Fcq, apps.Fnd_Concurrent_Requests Fcr,
apps.Fnd_Concurrent_Programs Fcp, v$session s, v$process p,
apps.Fnd_User Fu, apps.Fnd_Concurrent_Processes Fpro
where
Phase_Code = 'R' And
fpro.session_id = s.audsid and
s.sid = &sid
s.paddr = p.addr and
Fcr.Controlling_Manager = Concurrent_Process_Id And
(Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id And
Fcq.Application_Id = Fpro.Queue_Application_Id ) And
(Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id And
Fcr.Program_Application_Id = Fcp.Application_Id ) And
Fcr.Requested_By = User_Id
From: SUNIL SHARMA sunil-k-sharma@usa.net
Subject: FND_REQUEST.SUBMIT_REQUEST
Hi all,
i am tring to submit a request through FND_REQUEST.SUBMIT_REQUEST.
but i am getting this error and request id is 0
out put of the pl*sql
The request id returned is 0
:MESSAGE
--------------------------------------------------
FND CONC-Illegal printer spec
my pl*sql is this
pls help me to short out this problem.
TIA
sunil
From: "Prodipto Mitra" pamitra@hotmail.com
Subject: Re: FND_REQUEST.SUBMIT_REQUEST
Hi,
Is 'Landscape - 180 Columns' a valid style associated with the printer
is_hp??
Does this job get submitted without this printer statement i.e. w/o printing
to any specific printer??
Some concurrent programs have printers defined at the conc prog level itself
which cannot be changed. Is this the case??
-Prodipto
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: FND_REQUEST.SUBMIT_REQUEST
Landscape - 180 columns is usually referred to as Landwide.
From: vv vv venvivek@usa.net
Subject: Re: [FND_REQUEST.SUBMIT_REQUEST ]
Hi Sunil.
Add chr(0) as ur last parameter. suppose U have 3 more parameter more tha=
n the
normal then out of 100 arguments give the 4th argument as chr(0).
i.e. arg1,arg2,arg3,chr(0),null,null,.....null(arg 100);
I think this will help U.
If U have further questions please mail me @ dear_breeze@yahoo.com
With regards.
Love,
Vivek.
From: Andy Baliton abaliton@us.salterlabs.com
Subject: Request since July 21st
Hi everyone!
Can anyone tell me how I can Cancel a Request that have been running
since July 21? I tried canceling the request and a not will show saying
"Request 107018 can no longer be cancelled. The Concurrent Manager
process that was running this request has exited abnormally. The ICM
will mark this request as completed with error.". Still stays a status
of Normal and in Running phase.
Thank you in advance.
Andy
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Request since July 21st
Hi,
Update the phase_code and status_code to 'C' and 'D'
for that request and this should solve the problem.
-chakrapani
From: Sherry Barham RAL shbarham@gpi.coop.com
Subject: Re: Request since July 21st
Hi Andy -
Try this:
As APPS, log onto your database and execute the following SQL statement:
update fnd_concurrent_requests
set phase_code='C', status_code = 'E'
where request_id = your_request_id;
commit;
The processes will show up as complete with error through the concurrent
request form.
Hope this helps.
Sherry Barham
General Parts, Inc.
From: Graham Duggan gjduggan@mail.com
Subject: RE: Request since July 21st
It has been a while since I have seen this issue but I believe it is a know
problem in Rel 10 fixed by the following patch.
442824 Server Code error in afpesa.lpc which ignored failed status of host
programs.
Graham.
From: "Bambang Sugijono" bsugijon@sampoerna.co.id
Subject: Re: Request since July 21st
Hi Andy,
You can delete file request 107018 in $APPL_TOP/common/log/l107018.req and
$APPL_TOP/common/out/userid.107018
And delete record with request 107018 in table FND_CONCURRENT_REQUEST
I hope this can help you.
Regards,
Bambang Sugijono
From: Ortega Genaro-FGO005 Genaro.Ortega@motorola.com
Subject: URGENT.......
Hi Gurus:
I have the Release 11.0.1 with MRC option. My problem is that one
process is running in the database and i don't find any way to kill it.
We try to see the SID and serial number to do an alter system kill
session but the serail numbers is incremented and I can't use this
alternative.
Any of you know other way to kill it.
I appreciate all yours response because we are in the month end
process.
Thanks.
Genaro Ortega Grado
Software and Support Engineer.
Motorola de Mexico, S.A.
Personal Communication Sector
Phone (5214) 39-3101 Fax (5214) 39-3199
From: "manoj_bhatnagar/Polaris"@polaris.co.in
Subject: Re: URGENT.......
Hi
If you want to kill any Oracle Application process then
1. Go to System Administration- Concurrent- Requests.
2. Query all the records by pressing the F8 key.
3. Select the request yu want to cancel and press the CANCEL REQUEST button.
If you want to find out the Session Id of a particular Session of the Oracle
Application then
1. Go to Help- Tools- Examine.
2. Select the block as $PROFILES$ and field as SESSION_ID.
3. Note this ID and go to SQL* PLUS.
4. Select the records from V$SESSION where the COLUMN AUDSID is equal to the
session id
you noted in the Oracle Applications.
5. Use ALTER SYSTEM KILL SESSION to kill that request.
Hope this helps.
Manoj Bhatnagar
Associate Consultant-Technical
Polaris Software Lab Ltd.
Noida, India.
From: Argon Usman argon@newmail.net
Subject: Re: URGENT.......
I strongly suggest you to upgrade to 11.0.3 unless you really want to
enjoy your relationship with Oracle Customer Support for the next 2-3
months for MRC problems.
And just a kind reminder, you are suppose to register to MRC Team, and I
think they would suggest you to use 11.0.3
Regards,
Argon I. Usman
Consultant
From: Dina Rotem dinar@rafael.co.il
To: Argon Usman argon@newmail.net, Ora OraApps-L@cpa.qc.ca
Subject: GL: What is the MRC team?
Argon
Could you please explain what is the MRC team
Dina
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
Subject: RE: What is the MRC team?
If you are using / implementing MRC, you need to call/email Oracle and
register
your installation so they 'approve' you.
This is mostly for support issues.
You could get some more information from Oracle (Metalink)
or from the following address:
MRCINFO@us.oracle.com
Fausto Cavazos
Motorola PCS
Fausto.Cavazos@Motorola.com
From: Argon Usman argon@newmail.net
Subject: Re: What is the MRC team?
Usually Oracle Support will forward any error problem regarding MRC to
MRC Team.
I think this because MRC is the new development that might have tons of
bugs.
You need an approval from the Team before you can install MRC on your
applications.
Regards,
From: "Bob Delaney" rdelaney@prodigy.net
Subject: Multi-Org: Concurrent Program Identification
My client is in process of implementing multi-org for AR. A number of
people will be supporting both organizations and will be assigned multiple
AR responsibilities. During preliminary testing they noticed that they
could not differentiate concurrent processes that were submitted under the
different AR responsibilities from the View Concurrent Request form. For
reports, they would have to open the report to see the org name in the
heading. For other concurrent programs, like Autoinvoice or GL Transfer,
org name may or may not be included in the report (I haven't had time to
verify).
They would like me to clone a number of concurrent programs to include an
org name abbreviation into the concurrent program name so it would be
visible from the view request form. Although this appears to be feasible, I
would like to see how other companies have addressed this situation.
Thanks in advance,
Bob Delaney
ISS, Inc
From: "S Tamane" stamane@hotmail.com
Subject: Can not viwe reports from concurrent manager
Hi All,
I have applied patch # 660484 (for ADI) and ever since I can publish reports
from ADI but, I can not view reports from concurrent manager.
I get the following error message,
"function ncrorou return error 1003 the application process may have exited
abnormal"
Has anyone encountered this problem ??
I have relinked FNDFS, FNDWRR.exe, F45WEBM, copied over F45WEBM from
ORACLE_HOME/bin into FND_TOP/bin. Nothing has resolved this issue.
Please mail me directly at stamane@hotmail.com, if there is anything that I
may have missed. Thanks in advance.
We are on Rel. 11.0.2 on Solaris, d/b - 8.0.4.2.2
Sameer..