Query for File version track of DB packages in R12

Hi All,

Below SQL Query helps in extracting the Package Version details updated due to application of various patches to e-business home.

select a.file_id,(select filename from ad_files where b.file_id=file_id) file_name, to_char(a.last_update_date,'DD/MM/YYYY HH24:Mi:SS')

from ad_file_versions a,

(select file_id from AD_FILES where filename in

(select ltrim(substr(text,instr(text,'H',-1)+7,instr((substr(text,instr(text,'H',-1)+7)),'s 1',-1))) from dba_source

where name = '&Package_name'

and text like '%$Header%.pls%' )) b

where a.file_id =b.file_id

order by last_update_date

Hope this helps..

Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run IAX

Issue:

We are upgrading our current 11i instance to 12,1,3 and as part of upgrade we executed 12.1.1 driver successfully. But later when I tried to configure application using rapidwiz it is continuously failing. The environment working in AIX.

Found below error in adconfig.log

Starting AutoConfig at Tue Dec 10 06:00:28 2013
Using adconfig.pl version 120.26

    Script execution phase specified: INSTE8_SETUP
        Classpath                   :

Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.

Also found below errors in rapidwiz logfile $INST_TOP/logs/12100618.log

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /u01/oracle/test/inst/apps/test_tesdb

ERROR: Invalid java version found:

        JVMJ9VM015W Initialization error for library j9dmp24(0): JVMJ9VM009E J9VMDllMain failed

Could not create the Java virtual machine.

ERROR: Invalid java version found:

        JVMJ9VM015W Initialization error for library j9dmp24(0): JVMJ9VM009E J9VMDllMain failed

Could not create the Java virtual machine.

       Classpath                   :

Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.

Cause:

Before running rapidwix we have executed 12.1.1 upgrade driver by setting the below parameter 

export LDR_CNTRL=MAXDATA=0x40000000

Solution:

The parameter LDR_CNTRL=MAXDATA=0x40000000 should be set only if we run large jobs in AIX

unset LDR_CNTRL as below

$ unset LDR_CNTRL 

Enabling Trace for reports in R12

This blog explains how to enable a trace for concurrent programs that run rdf reports to generate output.


Enabling Trace for reports in R12

Enable trace, in the report, so the command used to submit it will appear in the log file.
Using the System Administrator responsibility navigate to the Define Concurrent Program Screen and query the report. Check the box next to Enable Trace.
Submit the report from the Concurrent Manager and view the log file for the NLS_LANG Parameter and the command used to run the report.

Example:
A.Submit Concurrent program from "Submit New Request"
B.When the request completes click on the View Log button.
Copy the lines between -- Start of Reports Command --
                              and -- End of Reports Command --

Arguments
------------
p_mag_assign_action_id='882414262'
------------


 -- Start of Reports Command --
/u01/oracle/test/inst/apps/test_host/ora/10.1.2/bin/appsrwrun.sh
P_CONC_REQUEST_ID=1340141
p_mag_assign_action_id='882414262'
report=/u01/oracle/test/apps/apps_st/appl/pip/12.0.0/reports/US/TEST.rdf
batch=yes
destype=file
desname=/u01/oracle/test/inst/apps/TEST_host/logs/appl/conc/out/o1340141.out
desformat=XML
 -- End of Reports Command --

Verify the Forms CATCHTERM variable and be sure it is set to 0. If the CATCHTERM variable is not set to 0 (zero) a core file will not be created.
Example:
echo $FORMS_CATCHTERM
export FORMS60_CATCHTERM=0
Verify your DISPLAY setting: echo $DISPLAY
If DISPLAY is not set: export DISPLAY=

Convert to REP to prevent any compilation issue as below
 REP-1247: The report contains uncompiled PL/SQL.
 $ORACLE_HOME/bin/rwconverter.sh userid=apps/password@apps source=/u01/oracle/test/apps/apps_st/appl/pip/12.0.0/reports/US/HBPY_PDF_PAY_SLIP.rdf stype=RDFFILE dtype=RDFFILE compile_all=yes batch=yes

Run the report from the command line with TRACE Option as follows:

$INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/appsnft@hrcmnft p_mag_assign_action_id='882414262' report=/home/oracle/onlinepdf.rep batch=yes destype=file desname=/home/hrcmpll/payslip.out desformat=XML traceopts=trace_all tracefile=/home/hrcmpll/payslip.trc tracemode=trace_replace

Here default is trace_all (Log all possible trace information in the trace file)

TRACEFILE= Any valid file name including the full path to the file.

TRACEMODE= TRACE_APPEND Adds the new information to the end of the file and TRACE_REPLACE Overwrites the file