Useful Tips

R11i Support Life

Useful Tips

| | | | | |

On this page we will provide some tips that can be used any time when fixing problem.

You must know...

DISPLAY

This environment variable is required for running any Motif application. The Oracle Reports executable rwrun60 is a Motif application, so if you want to run a report with rwrun60, the DISPLAY environment variable is mandatory. However, rwrun60c is a character mode executable which does not require the DISPLAY variable.

PROFILES

begin
dbms_output.put_line(fnd_profile.value('GL_SET_OF_BKS_ID'));
end;

You have to set the Profile Code to get the value.

CLIENT_INFO

When you have multiorg operations, you can set the CLIENT_INFO environment variable, using the following function.
begin
dbms_application_info.set_client_info(42);
end;
Then you can get information from AP_INVOICES and all records from ORG_ID=42 are displayed.
Now you can use this option instead of create a SQL with ORG_ID=XX condition for AP_INVOICES_ALL.

and also...

Use this PL/SQL command to display variable values.

Examples:

dbms_output.put_line('str');
dbms_output.put_line('Vendor Total Records Inserted: '||V_TOTAL_REC_INS);
dbms_output.put_line('Vendor Total Records No Inserted: '||V_TOTAL_REC_NOINS);

R11i Module Release

Check information from table:

- fnd_product_installations

This table has records about modules installed and which release was installed.

R11i Patches

Check patches applied from table:

- ad_applied_patches

Version from Binary File

For example, you need to know the program version of GMACACOST process and you don't have the source code. For this situation you have to use the next unix command:

strings -a GMCACOST | grep -in '$Header' | more

Where $Header is located previous the version number.

UNIX Path

To know what is the current path in Unix directories, use the following command:

PS1='$PWD-> ';export PS1

With this command you don't need to execute de pwd command to know what is the current path.

Program Version ($Header)

To know what is the current Package version into the Database use the following SQL command:

SELECT name, text
FROM user_source
WHERE 1=1
AND TEXT LIKE '%$Header%'
AND type = 'PACKAGE BODY'
and (upper(name) like 'PO%'

With this command you will get all Package Body versions from PO module.

Database Version

That's a typical question from Metalink guys... use the following command:

select *
from sys.V_$VERSION

Note: Some suggestions could not be valid depending on your Operating System, Database and R11i version. This commands will not update information but you run this command under your own decision. Thanks.

Sharing R11i Support Actions and Tips