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!

Views with quoted column names

Discussion in 'Oracle HRMS & Payroll' started by Khursheed Farooq Reshi, Oct 13, 2016.

  1. Khursheed Farooq Reshi

    Khursheed Farooq Reshi Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Hyderabad
    We have views which has quoted column names like below. Since R12.2 is not going to support these , how do you recommend us to change these column names without affecting the reports which are based on these view. ?

    Please recommend how to make this change.

    CREATE OR REPLACE FORCE VIEW hr_mc_demo_range
    (
    "Employee Name",
    "Employee No",
    "Asg No",
    "Person Type",
    "Prefix",
    "Exempt or Non-Exempt",
    "Job Name",
    "Job Full Name",
    "Position Name",
    "Position No",
    "Job No",
    "Unit"
    )
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    If the reports use the column names as report headers then changing the column names will affect the reports generated. If Oracle created tables in this fashion then it's up to Oracle to correct the definitions.

    You may need to file an SR with Oracle support to get this addressed.
     
    Khursheed Reshi likes this.