1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need substitute table for financials_system_params_all in Oracle Apps R12

Discussion in 'Oracle Apps Technical' started by RG Hegde, Feb 13, 2015.

  1. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello

    We have merged 2 instances . One of our report is not showing the data for the new instance . It is showing the data only for old instance .

    As per the existing logic the report fetches organization_id and org_id from financials_system_params_all. But this table has only the organization relating to old instance .

    Is there any other table we can think to get the data instead of financials_system_params_all except org_organization_definitions and hr_operating_unit?
     
  2. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi ,

    Can you try financials_system_parameters
     
  3. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello Yowan,

    Thanks for the reply .

    As financials_system_parameters is just the synonym for financials_system_params_all it wont make the difference.
     
  4. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi Hegde,

    financials_system_parameters is the org_id based view on financials_system_params_all, whether hr_all_organization_units helps you?
     
    RG Hegde likes this.
  5. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Finally I have used mtl_parameters as it is relating to inventory orgs .

    My issue has been resolved