Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query to find the tax Reporting code using the tax rate from zx_lines?

Received Response
202
Views
4
Comments
User_1ZWDZ
User_1ZWDZ Rank 2 - Community Beginner
in Oracle Analytics Publisher

The tax Reporting Code is in the table - ZX_REPORTING_CODES_B

I need help on how to join this table with zx_lines,

or join tax rate with tax reporting code?

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_1ZWDZ

    Tax reporting codes you can refer below table -

    ZX_REPORTING_CODES_B (oracle.com)

    ZX_REPORTING_CODES_B

    This table stores the tax reporting codes, which are unique codes for tax reporting purposes.

    Regards,

    Arjun

  • User_1ZWDZ
    User_1ZWDZ Rank 2 - Community Beginner

    Hello,

    I need a join between zx_lines and ZX_REPORTING_CODES_B

  • Maalavica
    Maalavica Rank 1 - Community Starter
    edited February 3

    hi i have the same requirement did you get the table?

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited February 3

    Hi @Maalavica , what product are you asking about?

    This category is mostly for technical questions on Publisher. If you are using OBIA or FDI, there are dedicated categories for those products where to ask questions about the data model.

    If you are using a Fusion product, then you should consider asking your data question in the forum that cover the Fusion products: https://community.oracle.com/customerconnect