OTBI report built is rounding off the Accounted amount column, how to stop it — Oracle Analytics

Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

OTBI report built is rounding off the Accounted amount column, how to stop it

Received Response
66
Views
4
Comments
ChetanaR
ChetanaR Rank 1 - Community Starter
edited Aug 13, 2024 7:35PM in Oracle Fusion Data Intelligence

OTBI report built is rounding off the Accounted amount column, how to stop it

Tagged:

Answers

  • Renuka Nuguru-Oracle
    Renuka Nuguru-Oracle Rank 5 - Community Champion

    Hello Chetana,

    Can you provide your logical sql and the requirement of the report design.

    Example: Use formula with round and test the issue.

    sum(round("- Invoice Accounting"."SLA Unrounded Accounted Amount Credit", 2) by "- General Information"."Invoice Number","- Subledger Accounting Journals Details"."Journal Line Number")

    Thanks,

    Renuka

  • ChetanaR
    ChetanaR Rank 1 - Community Starter

    Hi Renuka,

    The issue is , we have not used any rounding function but the GL amount displayed in OTBI report is getting rounded automatically, which we want to avoid.

    Thanks,

    Chetana

  • Renuka Nuguru-Oracle
    Renuka Nuguru-Oracle Rank 5 - Community Champion

    Chetana,

    Can you create simple report with few columns and provide the logical sql.

    What format do you see for round("yourGLColumn, 2)


    Thanks,

    Renuka

  • User_73QED
    User_73QED Rank 1 - Community Starter

    I am having the same issue. Did you find the fix?