Re: APP-FND-01630: Cannot open file f:\d01\oracle\viscomn\temp\OF31.tmp for reading

Last 11.5.9 install I did still required some 30+ additional patches and patchsets, both large and small, after the "base" install.

You are far from done. Especially on Windows.

Log a TAR. Log a TAR. Log a TAR...

For example, I needed to apply the "Concurrent Processing Rollup Patch F" (#2949264), but in turn that required 3 pre-requisite patches. It in turn was a pre-requisite for the "11i.ADX.E" patchset and the "11i.OIE.H" patchset. And so on...

There really is no "standard" list, though there is a list of the current patchset levels for the different major modules. You'll need to log a TAR, log a TAR, log a TAR and have Oracle Support provide a list relevant to this problem, and then you yourself will have to spend a few hours (or days) on MetaLink researching the prerequisites and the prerequisite's prerequisites, ordering them in the proper order of apply yourself in a spreadsheet. Like I said, mine grew to some 30 items for 11.5.9. This is much better than earlier versions of 11i and 11.0, where the list grew into the hundreds...

They say that the only things in life that are certain are death and taxes. If you are an 11i DBA, then you can add patches to the list...

Also, become very familiar with all of the fabulous diagnostics now provided for 11i Apps on MetaLink. For this one, you might want to search MetaLink for "FNDCCMDiagnostic115" and run it. Log a TAR, log a TAR, log a TAR; the TAR logging process will point you right at it, and others...

Hope this helps...

on 10/5/04 1:27 AM, Abhishek Saxena at AbhishekS_at_KPITCummins.com wrote:

> We are working on Oracle Application 11.5.9 on windows and it is a fresh
> instance means no additional patch applied to this instance .
> I have installed printer now all the sysadmin reports are running fine and
> showing output , but when i try to run some other report like asset category
> or transaction register report it says ..can any body tell me the solution for
> this
> ********************************************error
> description*********************************************
> Oracle Inventory: Version : 11.5.0 - Development
> Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
>
> INVTRREG module: Transaction register
> +---------------------------------------------------------------------------+
>
> Current system time is 04-OCT-2004 20:31:50
>
> +---------------------------------------------------------------------------+
>
>
> +-----------------------------
> | Starting concurrent program execution...
> +-----------------------------
>
> Arguments
> ------------
> P_BREAK_ID='1'
> P_RPT_UOM='2'
> P_ORG='207'
> P_QTY_PRECISION='2'
> P_GLCC_STRUCT_NUM='101'
> P_TXN_DATE_LO='2001/10/04 00:00:00'
> P_TXN_DATE_HI='2001/10/04 00:00:00'
> P_AUDIT_DETAIL='2'
> P_REASON_DETAIL='2'
> P_LOC_DETAIL='2'
> P_CATEGORY_DETAIL='2'
> P_SERIAL_DETAIL='2'
> P_LOT_DETAIL='2'
> P_CATG_SET_ID='27'
> P_CATG_STRUCT_NUM='101'
>
> ------------
> Program exited with status -1073741819
>
> Cause: The program terminated, returning status code -1073741819.
>
> Action: Check your installation manual for the meaning of this code on this
> operating system.
> APP-FND-01630: Cannot open file f:\d01\oracle\viscomn\temp\OF31.tmp for
> reading
>
> Cause: USDINS encountered an error when attempting to open file
> f:\d01\oracle\viscomn\temp\OF31.tmp for reading.
>
> Action: Verify that the filename is correct and that the environment
> variables controlling that filename are correct.
>
> Action: If the file is opened in read mode, check that the file exists.
> Check that you have privileges to read the file in the file directory.
> Contact your system administrator to obtain read privileges.
>
> Action: If the file is opened in write or append mode, check that you have
> privileges to create and write files in the file directory. Contact your
> system administrator to obtain create and write privileges.
> Concurrent Manager encountered an error while running Oracle*Report for your
> concurrent request 2168970.
>
> Review your concurrent request log and/or report output file for more detailed
> information.
>
>
> +---------------------------------------------------------------------------+
>
>
> Executing request completion options...
>
>
> Finished executing request completion options.
>
>
>
> +---------------------------------------------------------------------------+
> Concurrent request completed
> Current system time is 04-OCT-2004 20:31:58
>
> +---------------------------------------------------------------------------+

--
http://www.freelists.org/webpage/oracle-l