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

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

Bill wise Outstanding Query in Oracle apps R12.2.5

SELECT
 DISTINCT cust_acct.ACCOUNT_NUMBER customer_number,
        SUBSTRB (HP.party_name, 1, 50) customer_name,
       ps.trx_number Invoice_No,
       ps.trx_date,
       (SELECT DESCRIPTION
          FROM RA_CUSTOMER_TRX_LINES_ALL
         WHERE     CUSTOMER_TRX_ID = ps.CUSTOMER_TRX_ID
               AND DESCRIPTION IS NOT NULL
               AND ROWNUM = 1)
          PRODUCT_CATEGORY,
       ps.due_date,
       NVL (ps.amount_due_original, 0) Invoice_amt,
      NVL (ps.AMOUNT_DUE_REMAINING, 0) DUEAMOUNT,
     -- NVL (SUM (ps.amount_due_remaining), 0) invoice_balance
       NVL ( (ps.amount_due_REMAINING * NVL (ps.EXCHANGE_RATE, 1)), 0)
          NET_OUTSTANDING,
       PS.CLASS TYPE,
       (SELECT DISTINCT name
          FROM JTF_RS_SALESREPS
         WHERE salesrep_id(+) = rta.primary_salesrep_id)
          SALESREP_NAME,
       HP.STATE REGION,
       HP.COUNTY Continent,
       TERMS.NAME CREDIT_PERIOD,
       TRUNC (SYSDATE) RUN_DATE,
       :P_AS_ON_DATE AS_ON_DATE
  FROM ra_cust_trx_types_all rtt,
       ra_customer_trx_all rta,
       ra_cust_trx_line_gl_dist_all rgld,
       gl_code_combinations cc,
       hz_cust_accounts_all cust_acct,
       --ra_customer_trx_lines_all rctla,
       hz_parties hp,
       --JTF_RS_SALESREPS REP,
       ra_terms terms,
       ar_payment_schedules_all ps,
       hz_cust_acct_sites_all acct_site,
       hz_party_sites party_site,
       hz_locations loc,
       hz_cust_site_uses_all site_uses
 WHERE  --cust_acct.account_number = :p_account_number
       ps.customer_id = cust_acct.cust_account_id
       AND ps.cust_trx_type_id = rtt.cust_trx_type_id
       AND cust_acct.party_id = hp.party_id
       --and rta.customer_trx_id = rctla.customer_trx_id
       AND rta.term_id = terms.term_id
     --  AND ps.trx_date <= :p_as_of_date
       AND ps.CLASS NOT IN ('CM', 'PMT')
       AND site_uses.site_use_code = 'BILL_TO'
       AND acct_site.party_site_id = party_site.party_site_id
       AND loc.location_id = party_site.location_id
       AND NVL (site_uses.status, 'A') = 'A'
       AND cust_acct.cust_account_id = acct_site.cust_account_id
       AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
       AND ps.customer_id = acct_site.cust_account_id
       AND ps.customer_site_use_id = site_uses.site_use_id
       AND rta.customer_trx_id = ps.customer_trx_id
       AND rta.customer_trx_id = rgld.customer_trx_id
       AND rgld.code_combination_id = cc.code_combination_id
       AND rgld.account_class = 'REV'
      -- AND RTA.ORG_ID = 102
       AND RTA.SET_OF_BOOKS_ID = '2021'
       AND rta.previous_customer_trx_id IS NULL
       AND cust_acct.account_number =
              NVL (:P_CUST_NUMBER, cust_acct.account_number)
       AND ps.ORG_ID = :P_ORG_ID
       AND HP.party_name = NVL (:P_CUST_NAME, HP.party_name)
       AND ps.TRX_NUMBER <= NVL (:P_FROM_INVOICE_NO, ps.trx_number)
       AND ps.TRX_NUMBER >= NVL (:P_TO_INVOICE_NO, ps.trx_number)
       and  TRUNC (ps.gl_date) <= :P_AS_ON_DATE
       AND PS.AMOUNT_DUE_REMAINING <> 0
       ORDER BY TRX_DATE