ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
SYSTEM ADMINISTRATION

Coordination Checkbox

Date: Wed, 7 Jul 1999 19:35:37 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
Subject: NCA: DEFERRED/IMMEDIATE checkbox

All -

New to 10.7 NCA forms, getting familiar with the look, feel, performance, navigation. Came across a checkbox on some forms that we can't find an explanation for. Example: Onhand Quantities form in Inventory, upper right corner. It has no boilerplate text label, but it is checked by default. If you uncheck it, you see DEFERRED in the Toolbar status line, checking it again returns IMMEDIATE to the status line. Anyone know anything about this? Thanks!

Steve McElhinny Steve.McElhinny@alcoa.com

Date: Thu, 08 Jul 1999 08:20:33 -0700
From: Janet Elmore elmore1@llnl.gov
Subject: Re: NCA: DEFERRED/IMMEDIATE checkbox

Steve,

I don't have access to the particular form you are referring to, but it sounds like the "Coordination Checkbox" they talked about in class. See page 7-6 of the Oracle Applications Developer's Guide.

If that is what your referring to, it is used in multi-block forms.

"When a detail block is in a different window than its master, and each window is non-modal, then the detail block must provide a mechanism for the user to toggle between immediate and deferred coordination. This allows a user to keep a block visible, but control the performance cost of coordinating detail records when the master record is changed."

Although it may help performance to have it unchecked in some cases, it is more confusing as the master and detail records won't be in sync. Therefore, we have trained our users to leave it checked.

Hope this helps. Janet Elmore Lawrence Livermore Nat'l Lab.

Changing field properties in a Form

Date: Thu, 8 Jul 1999 18:34:15 -0400
From: "Sabrina Diaz, TRI" SDiaz@tricom.com.do
Subject: SYS: Changing field properties in Ora Apps form

Is there an easy way to change the property of a field in any Oracle Financials form ? I believe, that I have read something about changing for example a field to be required or not in a form w/o using Oracle Forms.

Any Help will be appreciated,
Sabrina

Menu Subfunction as primary Navigation path

Date: Fri, 9 Jul 1999 09:12:32 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: System Administration: Menu SubFunction Question

SysAdmin Gurus: Hoping someone can help.

I am trying to take a menu subfunction, specifically the Items: Organization Assignment subfunction and make it into a primary navigation path. So far, I have been unsuccessful...When I make this selection a primary path, I actually navigate to Item Cost Updates instead of the Org Assignment Window.

Is there a way I can do this? I need users to be able to assign and update items in the orgs themselves; however, I do not want them to be able to access any of the item attributes at the Master Level.

Any assistance would be greatly appreciated.
Thanks
Dawn Elise Downey
Senior Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Pager: 888-692-1071

Responsibility - in Concurrent Program

Date: Fri, 9 Jul 1999 07:19:36 -0700 (PDT)
From: chris johnson ora_us@yahoo.com
Subject: Concurrent program.....

Hello:

Is it possible to grab the name of the responsibility (you log into) from the profile (just as we can for set of books) to supply as a parameter for a report at runtime. If not where is the name of the responsibility available.

All comments are greatly appreciated

Date: Fri, 9 Jul 1999 10:45:13 -0400
From: "Kamdar, Rita R, CFCTR" rkamdar@att.com
Subject: RE: Concurrent program.....

Chris,

Here is the sql, you can use during conc. prog's parameter definition to get the responsibility name.

select responsibility_name from fnd_responsibility fr
where fr.application_id = :$PROFILES$.RESP_APPL_ID and
fr.responsibility_id = :$PROFILES$.RESP_ID

Rita.

Date: Fri, 9 Jul 1999 13:04:50 -0700 (PDT)
From: chris johnson ora_us@yahoo.com
Subject: RE: Concurrent program.....

Thanks a lot for ur response. I was just wondering if there was a list of all the values that we could get from $PROFILES$ at run time like

$PROFILES$.GL_SET_OF_BKS_ID and
$PROFILES$.RESP_APPL_ID etc

Thanks in advance.. Chris

Date: Sun, 11 Jul 1999 07:44:42 -0700 (PDT)
From: bill billvenella@yahoo.com
Subject: RE: Concurrent program.....

I just learned something incredibly exciting. We are using AppWorx. It has a way of pulling all that information over for each conc prog. with all of it's inputs and parameters. We started doing customization by coding for conc. prog. That is long and the wrong way to do this now that I understand this. We can dynamically pull information from sql to input into these progs. This will eliminate some of the coding that we are doing today. My manager also sees a benefit that this will get us from 10.7char to rel 11.0 much quicker because all scheduling is centralized.

This is something that everyone should have, take a look: http://www.appworx.com/

fnd_global.apps_initialize and fnd_request.submit_request

Date: Fri, 9 Jul 1999 14:35:35 -0500
From: Shane Bentz SBentz@IVCF.ORG
Subject: AOL: fnd_global.apps_initialize and fnd_request.submit_request

I recently started subscribing to this list, so forgive me if you've gone over this. I searched through the archives and didn't find anything that directly answers my question.

I am attempting to use the fnd_request.submit_request function from within the 'BeforeReport' trigger of a Reports 2.5 report which also runs in the ConcMgr. It is constantly returning zero as the request_id and the request_id sequence jumps skips one so I know that at least some of the code of fnd_request.submit_request is running. Even though this report is running in the ConcMgr, I am attempting to use the fnd_global.apps_initialize procedure before the submit_request call. I see from the archives that many of you have suggested using the initialize procedure to fool the ConcMgr.

Finally... here's my question. I see that your suggestions of using the initialize procedure require pulling the USER_ID, RESP_ID, and RESP_APPL_ID values from the database with hard-coded values of the responsibility name and user name. I can't imagine that's what we were all taught in our college programming classes. I'm wondering where I might be able to get these three pieces of information without having to hard-code anything into the reports/SQL/etc. Thanx!

Shane.
Shane Bentz
Business Systems Developer
InterVarsity Christian Fellowship/USA
6400 Schroeder Road
Madison, Wisconsin 53711
( 608 ) 274 4823 x326
sbentz@ivcf.org
http://www.ivcf.org

Date: Fri, 09 Jul 1999 15:56:33 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: Re: AOL: fnd_global.apps_initialize and

Hi,

It is always better to initialize with the User id and Responsibility Id so that the Concurrent Program will be run under that user name. So If some body wants to view that Report output , they can log-in as that user and can view it.There won't be problems with the file permissions....

Date: Tue, 13 Jul 1999 10:03:51 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
Subject: Re: AOL: fnd_request.submit_request failure...

Shane, I do this all the time and you are correct --
hardcoding is bad form.

1st.
As the first parameter in your concurrent program enter a parameter of "Request ID" 7/Number; Displayed=No; Required=Yes;
Token=P_CONC_REQUEST_ID (use this spelling exactly)

2nd.
Add a user paramenter of P_CONC_REQUEST_ID to your report. (Number, init value of zero)

3rd.
Run as the first line in your before report trigger the command "srw.user_exit("FND SRWINIT');"

4rd.
Run a query to pull the application_id, responsibility_id, user_id, and user name from FND_CONCURRENT_REQUESTS and FND_USER using the request id in the parameter :P_CONC_REQUEST_ID.

5th.
Initialize the session by calling the global.initialize routine.
Alternately, run these commands to init your session:
FND_PROFILE.PUT('USERNAME', Usr_Name);
FND_PROFILE.PUT('RESP_ID', Resp_ID);
FND_PROFILE.PUT('RESP_APPL_ID', Resp_App_ID);
FND_PROFILE.PUT('USER_ID', Usr_ID);

When the report is submitted by the concurrent manager, SRWINIT populates P_CONC_REQUEST_ID with for the job. This is documented somewhere in the Application Object Library books.

When you call SUBMIT_REQUEST, your new job will be submitted under the same user and responsibility that submitted the original request.

Good luck Andy Schindler NRC, Inc.

Profile for organization name

Date: Tue, 13 Jul 1999 09:09:54 +0800
From: Mohan_Rajaganapathy@notes.seagate.com
To: oraapps-l@cpa.qc.ca
Subject: Getting the organization name

Hai everybody,

I have a small query in Oracle Apps.There is profile in Oracle Purchasing called MFG_ORGANIZATION_ID ( User Profile Name : PO: MFG Organization ID) which can be used to get the organization id.I wanted to know if you have a profile which can give me the organization code.

Thanks in advance for any help
Mohan

Date: Mon, 12 Jul 1999 21:26:44 -0400
From: "Suresh Pillaipakkam Bagukkudumbi" sureshpb@hotmail.com
Subject: RE: Getting the organization name

use hr_organizations table to get the desired info.

Concurrent requests - cleaning up

Date: Thu, 15 Jul 1999 12:15:49 PDT
From: "J P Bhamu" jpbhamu@hotmail.com
Subject: cleaning up concurrent requests..

Hi All,
I want to clean up my concurrent requests from the GUI(10.7 NCA) but not sure what effects it will cause. To be specific I want to know whether we will be able to see the old payroll runs (we are having HRMS) after we clean up the concurrent requests.

Any response will be greatly appreciated.. thanks

Date: Thu, 15 Jul 1999 13:05:08 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: cleaning up concurrent requests..

I assume you are referring to using the concurrent process of 'Purge Concurrent Requests' to perform this task. At any rate -- basically what happens is the $APPLCSF /out and /log directories are purged based on the criteria you have provided. (We purge out 5 days.)

No actual "data" is purged from the system. So - if you are concerned about saving your payroll "reports" you could possibly move them to another directory.

Hope this helps to clear it up a little.
Karen Blackwell
DBA / SA
RockShox, Inc.

Date: Fri, 16 Jul 1999 09:52:43 -0500
From: Mike Dennis mdennis@mdp.com
Subject: Re: cleaning up concurrent requests..

We had this same concern when we ran 1099's. We wanted to maintain the history of the reports (1099 tape, payment reports, 1099 forms). We opened the reports (our implementation uses Windows wordpad) and we saved the output to a text file on a directory on a shared network drive that only our payables staff has access to (also made a copy for our directories, just in case they accidently deleted the file or modified it). I don't know if this will work for you, but this has been very useful for us since we can use Find functionality in Wordpad to find a specific supplier, fed ID, or dollar amount. True, if we need to reprint, the page breaks aren't in the exact place, but we use much more for reference and query rather than for reprints.

CUSTOM.pll: ZOOM

Date: Fri, 16 Jul 1999 10:09:27 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: CUSTOM.pll: ZOOM - URGENT

Hi All,

My client wants to have Zoom button from AP Invoice Screen to PO Header screen. I modified Custom.pll Library , i.e. ,
1. I have enabled Zoom button in Zoom_available function.
2. I have written code in EVENT procedure to call Po form using FND_FUNCTION.EXECUTE procedure.

Once I press ZOOM button in AP INvoice screen , I get message:

'Function i currently not available.'

I have done this before in my previous project. I don't have clue why it's giving this message and not opening the called screeen now.

Any help on this would be highly appreciated.
Thanks.

Date: Fri, 16 Jul 1999 12:19:04 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: CUSTOM.pll: ZOOM - URGENT

You have not setup the subfunction security for the PO header form under the AP user's menu. Discuss this issue with your system administrator.

Date: Fri, 16 Jul 1999 10:25:45 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: RE: CUSTOM.pll: ZOOM - URGENT

Hi Earnie,

Thanks for your prompt reply. I am getting same error for even custom form which I have created. I have tried this functionality with custom form before. and it worked fine. Can you elaborate 'SETUP the SUBFUNCTION SECUTIRY' ? As my System administator is not knowing what he need to do.

Thanks.

Date: Fri, 16 Jul 1999 13:05:25 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: CUSTOM.pll: ZOOM - URGENT

The error message you are receiving is issued by function / sub-function security. There is a very good explanation of function security found in the Oracle System Administrator's Guide in Chapter 2, beginning with the section "Overview of Function Security". I suggest that he obtain and read this basic documentation for performing the System Administrator's job. It can be found in PDF format on the documentation CD which shipped with the Apps.

Concurrent Req. - scheduling

Date: Sat, 17 Jul 1999 14:03:35 +1000
From: "Celwyn Evans" celwyne@compuserve.com
Cc: "celwyn evans" celwyne@compuserve.com
Subject: AOL: Scheduling concurrent requests

Hi All

For some weeks now I have been working on a project where we need to schedule a number of requests overnight for a number of orgs/sob.

There is dependency between the requests i.e. request 1 must complete before request 2 begins etc.

We have adopted request sets and a number of custom programs to provide dependency between request sets which will provide a short term solution. We will also use alert to assist in tracking errors etc from requests and notifying users.

However I am seeking examples of how other sites have approached this issue.

For example have you used db tables to provide a parent/child step relationship between requests and then have some controlling process which uses this table to submit requests with a further table to store errors/ status etc.

The key would be too provide a flexible schedule method which you can add to quickly and ideally via Apps functionality i.e. custom concurrent programs, use of value sets etc.

We have information on appworx and a few other scheduling products with Apps extensions/ agents but while looking to these for a possible long term solution it would be great to hear from any of you who have implemented custom solutions to this issue and to obtain an overview.

There must be some documents out there which outline some good and working solutions.

Cheers Celwyn

NLS_LANG and Applmgr

Date: Mon, 19 Jul 1999 10:21:58 -0500
From: Tim_Plunkett@praxair.com
Subject: NLS_LANG and Applmgr

I have a question regarding the NLS_LANG parameter and the application of oracle patches. One of our plant locations is located in Italy , with all oracle users and applmgr NLS_LANG parameter set to Italian. While applying a patch, I received lots of REP-0083 errors while generating the reports. Oracle support recommended setting the NLS_LANG parameter for applmgr to English and re-applying the patch. This worked ok, but I question whether the patch is applying (re: compiling) everything correctly. Personally, I would prefer to have the NLS_LANG for the applmgr set to English permanently, as log entries for the concurrent managers, etc., would be in English, and I would not have to translate any status messages and errors. Does anyone know if this is acceptable? We have other locations/languages, such as French & German, so this question would apply to these set-ups as well.

Thanks in advance, Tim.

Date: Mon, 19 Jul 1999 19:17:23 +0200
From: "A.Attyasse" aford@cybercable.tm.fr
Subject: Re: NLS_LANG and Applmgr

Tim,
You should consider that for a patch that should contain translated strings you need a translated patch version from Oracle Support. That is why you don't need to worry about the NLS_LANG parameter on the server.

How to register Tables in Rel. 11

Date: Mon, 19 Jul 1999 14:06:12 -0400
From: "Vasquez, Sabrina" SV131388@exchange.DAYTONOH.NCR.com
Subject: AOL: table registration

Does anyone know how to register tables in Release 11? I know if 10.7 you had to use ad_dd.register_table and ad_dd.register_column but they don't exist in our 11 database.

TIA
Sabrina Vasquez
DBA NCR

Date: Tue, 20 Jul 1999 10:35:46 +0100
From: rchalton@dunnes-stores.ie
Subject: Re: AOL: table registration

We have Release 11.0.2 on NT and use ad_dd.register_table and ad_dd.register_column without any problem.

Standalone Batch Process

Date: Tue, 20 Jul 1999 11:48:51 +0200
From: "Sjoquist, Randy (AFIS)" Randy.Sjoquist@fao.org
Subject: USER: STANDALONE BATCH PROCESS

Hi all,

I have a prepayment invoice that has been paid. An expense claim has been applied to it. There is a balance.

A user, or by the looks of it process that goes by this user id, by the the name 'STANDALONE BATCH PROCESS' has added two distributions to the prepayment. The distributions offset so there is not an accounting problem, however, the invoice requries re-approval which is consistent when there is a change to the distributions. This is a problem as I must re-approve the invoice. Ok, but why is this process being run?

In FND USER, the description for this user is:

Used for batch processes which haven't been specifically run from Application Foundation Concurrent Manager

Does anybody know anything about this?
Thanks, Randy

Login to Apps problem

Date: Thu, 22 Jul 1999 10:15:13 +0530
From: partha.kanjilal@in.pwcglobal.com
Subject: URGENT

Hi All APPS - GURUS

We had Oracle Applications (Rel 11.0) on SUN SOLARIS (Unix) .After some time, we applied the patch successfully for upgradation to Rel 11.0.2. Now , we are facing a typical problem. The problem is as follows :
1The Sign - On Screen appears. We type the Username and Passwd.
2The Responsibility Screen appears. We choose the responsibility from the Menu.
3 The following error message appears.

This process cannot be drawn. It was not defined correctly when it was attached to your menu . Please advise your System Administrator that the function is in the incorrect format. (The error message has no number). There is however an OK option . On clicking on that the forms appear properly.

Please help us ASAP.

Date: Thu, 22 Jul 1999 13:24:23 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: URGENT

Hi !

Did you apply any localization patches / Upgrades ?

Gopal Thanx in advance.
Regards Partha kanjilal

How to print into a log file from a Concurrent program using PL/SQL

Nirmal Kumar appsdev_99@yahoo.com
on 07/21/99 11:16:15 PM
cc: (bcc: Robert Chalton/Mail)
Subject: Reg:Concurrent Program

Hi Techies,
I am having a PL/SQL stored procedure as concurrent program.I wanna print into log file from the pl/sql procedure.Could anyone help me in solving this problem?

Thank You Nirmal

Date: Thu, 22 Jul 1999 10:04:09 +0100
From: rchalton@dunnes-stores.ie
Subject: Re: Reg:Concurrent Program

If you're using R11 you can use FND_FILE:
fnd_file.put_line(fnd_file.log,'my message');
RobC

Request Sets - Current Date Parameter

Date: Thu, 22 Jul 1999 10:07:44 -0500
From: Deborah Bryda DBryda@specgrp.com
Subject: FW: Request Sets - Current Date Parameter

Hi All,

Hoping someone out there can help!

We set up a Request Set to run three jobs at an interval of 1 day. It is a sequential set. We have specified Current Date as the parameter for the jobs within the set.

The Request set is running daily as expected, however, the parameter being used is the original date that we set up the request set. It is not being incremented each day to pick up the current days' data.

Has anyone else experienced this? How did you resolve it?
Thanks, Deb

Date: Thu, 22 Jul 1999 09:25:19 -0600
From: PKBATCHU@micronpc.com
Subject: RE: Request Sets - Current Date Parameter

May be it is taking the current date as parameter for all the jobs in the set at the time of submitting. I think you can achieve the thing programmatically by value of the parameter and interval.

Date: Thu, 22 Jul 1999 18:21:14 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Request Sets - Current Date Parameter

Hi,
My answer refers to rel.11.
When you schedule the request set, in the schedule window check the "Periodically" radio button. Then you'll get a checkbox "Increment date parameters each run". Check it, and it will increment the current date each run.

-- Suzie Roth MIS (Ext. 7151)

Date: Thu, 22 Jul 1999 11:32:35 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: Request Sets - Current Date Parameter

This is a known problem with request sets and there is no plan to fix it in 10.7 sc. The problem is supposed to be addressed in REL 11

Date: Thu, 22 Jul 1999 18:37:11 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Request Sets - Current Date Parameter

Sorry. I'm not familiar with 10.7. The only solution I can give you is query the date in the program itself instead of passing it as a parameter.

Regards,
-- Suzie Roth
MIS (Ext. 7151)