2 Replies Latest reply on Mar 9, 2013 11:57 AM by Pk

    XML Report in Arabic login in Oracle apps

    Pk
      Hi,

      I have created a XML report in Oracle apps, the data is coming properly from english login.
      But when we login from Arabic Login then report does not show any data.
      The data does not come even after hard coding the values.

      Any clue for the issue..

      Below is the main query in the report.

      SELECT
      PAC1.PAYROLL_ID ,
      PAC1.PAYROLL_ACTION_ID ,
      HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME,
      PRO.PAYROLL_NAME
      ,TO_CHAR(SYSDATE,'DD-MM-YYYY') REPORT_DATE1
      FROM pay_payrolls_f pro,
      pay_payroll_actions pac1
      ,PER_TIME_PERIODS_V V
      WHERE pac1.payroll_id = pro.payroll_id (+)
      AND pac1.effective_date BETWEEN pro.effective_start_date (+) AND pro.effective_end_date (+)
      AND DECODE( PAC1.ACTION_TYPE, 'H', NVL(pay_payroll_actions_pkg.decode_cheque_type(pac1.business_group_id), HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE', PAC1.ACTION_TYPE)), 'T', DECODE(instrb(PAC1.LEGISLATIVE_PARAMETERS,'SLA_MODE=Y'), 0, HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER', 'GL'), NULL, HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER', 'GL'), HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER', 'SLA')) , HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE', PAC1.ACTION_TYPE)) = 'Run'
      AND PAC1.Payroll_id = 61--:P_PAYROLL_ID
      AND PAC1.time_period_id = V.time_period_id
      AND to_char(v.start_date,'MM-YYYY') = '01-2013'--:P_MONTH
        • 1. Re: XML Report in Arabic login in Oracle apps
          AlexAnd
          in the next time use EBS related forums - https://forums.oracle.com/forums/category.jspa?categoryID=3

          BTW
          looks like that for Arabic language you haven't some data

          in your main query you have PER_TIME_PERIODS_V which based on HR_LOOKUPS which depend on session language
          CREATE OR REPLACE VIEW HR_LOOKUPS
          ...
           where FLV.LANGUAGE = userenv('LANG')
          ...
          so check data in HR_LOOKUPS for Arabic language

          you can check it by query without PER_TIME_PERIODS_V


          also you can modify your main query like
          select t.PAYROLL_ID,
                 t.PAYROLL_ACTION_ID,
                 t.PERIOD_NAME,
                 t.PAYROLL_NAME,
                 t.REPORT_DATE1
            from (SELECT PAC1.PAYROLL_ID,
                         PAC1.PAYROLL_ACTION_ID,
                         HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME,
                         PRO.PAYROLL_NAME,
                         TO_CHAR(SYSDATE, 'DD-MM-YYYY') REPORT_DATE1,
                         PAC1.time_period_id
                    FROM pay_payrolls_f pro, pay_payroll_actions pac1
                   WHERE pac1.payroll_id = pro.payroll_id(+)
                     AND pac1.effective_date BETWEEN pro.effective_start_date(+) AND
                         pro.effective_end_date(+)
                     AND DECODE(PAC1.ACTION_TYPE,
                                'H',
                                NVL(pay_payroll_actions_pkg.decode_cheque_type(pac1.business_group_id),
                                    HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE',
                                                             PAC1.ACTION_TYPE)),
                                'T',
                                DECODE(instrb(PAC1.LEGISLATIVE_PARAMETERS, 'SLA_MODE=Y'),
                                       0,
                                       HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER',
                                                                'GL'),
                                       NULL,
                                       HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER',
                                                                'GL'),
                                       HR_GENERAL.DECODE_LOOKUP('TRANSFER_TO_LEDGER',
                                                                'SLA')),
                                HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE',
                                                         PAC1.ACTION_TYPE)) = 'Run'
                     AND PAC1.Payroll_id = 61 --:P_PAYROLL_ID
                  
                  ) t
            left outer join PER_TIME_PERIODS_V V
              on (t.time_period_id = V.time_period_id AND
                 to_char(v.start_date, 'MM-YYYY') = '01-2013' --:P_MONTH
                 )
          • 2. Re: XML Report in Arabic login in Oracle apps
            Pk
            Thanks Alex