1 Reply Latest reply: May 5, 2012 4:44 PM by Sandeep Gandhi, Consultant RSS

    Meaning of LSE_ID = 2

    user11258661
      We have a custom report in 11i for service contratcs and we are using below query and only if Coverage description is
      of certain type we are printing the report.
      We are in the process of upgrading to R12 and during testing we found that this query is returning values for only old contracts(11i) and not for new contracts.


      select UPPER(OCTT.MEANING) COVERAGE_MEANING
      into l_short_description
      FROM OKC_K_HEADERS_B OKHB , OKC_K_LINES_B OKLB , OKC_K_LINES_TL OKLT , OKS_K_LINES_B OKSLB, OKS_COV_TYPES_TL OCTT
      WHERE OKHB.CONTRACT_NUMBER = :P_CONTRACT_NUMBER
      AND OKHB.ID = OKLB.DNZ_CHR_ID
      AND OKLB.ID = OKLT.ID
      AND OKLT.LANGUAGE = USERENV('LANG')
      AND OKSLB.CLE_ID = OKLB.ID
      AND OCTT.CODE (+)= OKSLB.COVERAGE_TYPE
      AND OCTT.LANGUAGE (+)= USERENV('LANG')
      AND OKLB.LSE_ID = 2
      AND rownum=1;

      we found that we need to use coverage_id from oklb to derive covergae type but LSE_ID = 2 condition is failing for all new contratcs.

      We couldnt find any oracle documentaion detailing this type of changes?


      please help this is urgent!!