Wednesday, 24 August 2016

Junk Characters remove from PDF output in Oracle reports(after migration reports from 11i to R12.2.5)

When ever will get Junk characters in the report, Run the below commands in LINUX Enviornment
Set the APPS Env
and go to the report dire


1). rwconverter userid=apps/testapps04 source=rdf_name.rdf dest=rdf_name.rex stype=rdffile dtype=rexfile overwrite=yes batch=yes

2). cat rdf_name.rex | tr -d "\015" >rdf_name.rextmp
sed -e 's/CHARSET = 0/CHARSET = 38/' -e 's/CHARSET = 31/CHARSET = 38/' -e 's/CHARSET = 178/CHARSET = 38/' -e 's/CHARSET = 871/CHARSET = 38/' <rdf_name.rextmp> rdf_name.rex
3) . mv  rdf_name.rdf  rdf_name.rdf-bb11
4) . rwconverter userid=apps/testapps04 source=rdf_name.rex dest=rdf_name.rdf stype=rexfile dtype=rdffile  overwrite=yes batch=yes

No comments:

Post a Comment

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...