Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Cristian Betancur
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom...Answered
    Topic posted September 3, 2019 by Cristian BetancurBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OTBI, Reports 
    23 Views, 1 Comment
    Title:
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data Model
    Summary:
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data Model
    Content:

    Hi

    I have LACLS Colombia reports into Oracle ERP Cloud. 

    However, they do not show information, because HZ_GEOGRAPHY_IDENTIFIERS_VL view does not show geography code type as I created and associated it to the geography hierarchy. 

    This is SR where we found this issue: SR 3-20756472981 : Error in LACLS Colombia Reports. 

    We want to know if I cannot see information in this view because I have not run any process or I do not have role related with it. 

    Thanks. 

    Cristian.

    Version:
    Oracle Fusion Release 13 19B

    Best Comment

    Cristian Betancur

    Hi Janardhana

    With your reply, I was looking for about this view, and I can see that my geography codes are not primary code.

    I updated it, and I can see custom geography code type.

    Thanks.

    Cristian.

    Comment

     

    • Cristian Betancur

      Hi Janardhana

      With your reply, I was looking for about this view, and I can see that my geography codes are not primary code.

      I updated it, and I can see custom geography code type.

      Thanks.

      Cristian.