Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDF Report font format changed while upgrading from 6i to 11gr2

user12077236Oct 30 2013 — edited Nov 6 2013

Hi,

Recently we migrated from Oracle forms and reports 6i to Oracle forms and reports 11g

Oracle forms and report - 11.1.2.1

App Server - Windows 2008 R2

We opened the old oracle reports in new report builder and compiled the reports.

When we called the reports and generated the output as PDFs we found report heading have fonts format issue.

i am not able to attach the snap shot, so provided the same output

Before upgrade PDF Font Format - Font-Courier New Size-8 with Center alignment.


UNIT SOLD W/

REL.STYLE


After upgrade PDF Font Format- Font Courier Size-10 with left alignment


UNIT SOLD

W/

REL.STYLE


Any information which could resolve or analyze the issue.

Thank You,

Comments

2926792

select object_name,object_type,status,owner from dba_objects where owner='SYS' and status='INVALID';

 

select comp_name, version, status from dba_registry;

As considered,SYS.KUPU$UTILITIES_INT should be invalid.

connect / as sysdba;

 

SQL> set echo on

SQL> SPOOL /tmp/catalog.log

SQL> @catalog.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

SQL> SPOOL /tmp/catproc.log

SQL> @catproc.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

SQL> SPOOL /tmp/utlrp.log

SQL> @utlrp.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

 

Execute utlrp.sql script for multiple times like 5 times in 3 minute interval.

Wesley D-Oracle

The direct approach:

sqlplus / as sysdba
@?/rdbms/admin/prvthpui.plb
@?/rdbms/admin/prvtbpui.plb
alter package KUPW$WORKER compile body;

Confirm if "KUPU$UTILITIES_INT" has successfully validated.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 4 2013
Added on Oct 30 2013
1 comment
495 views