Friday, 26 August 2016

Junk Characters remove in oracle pdf out put in oracle apps r12.2.5

Issue: After Migrating from 11i to R12.2.5 Oracle Apps Custom Reports are getting Junk Character when ever we select PDF output format.
Resolution:
------------
Execute Below Commands in Linux Enviorment
1. Set up Env
  . ./APPSTEST.env
2. cd $XXTEST_TOP/reports/US

3. rwconverter userid=apps/testapps04 source=XXUCHMBHIDEPOT.rdf dest=XXUCHMBHIDEPOT.rex stype=rdffile dtype=rexfile overwrite=yes batch=yes

4. cat XXUCHMBHIDEPOT.rex | tr -d "\015" >XXUCHMBHIDEPOT.rextmp

5. 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/' <XXUCHMBHIDEPOT.rextmp> XXUCHMBHIDEPOT.rex

6. mv  XXUCHMBHIDEPOT.rdf XXUCHMBHIDEPOT.rdf-bb11

7. rwconverter userid=apps/testapps04 source=XXUCHMBHIDEPOT.rex dest=XXUCHMBHIDEPOT.rdf stype=rexfile dtype=rdffile  overwrite=yes batch=yes



Any Doubts let me know..

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...