Oracle Fusion Data Intelligence

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

Categories

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

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

Received Response
61
Views
4
Comments
ChetanaR
ChetanaR ✭
edited August 13 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 ✭✭✭✭

    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 ✭

    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 ✭✭✭✭

    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 ✭

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