OTBI
Discussion List
-
SQL for fetching Item, Item Class, Attribute and Attribute Group etc.Summary: SQL for fetching Item, Item Class, Attribute and Attribute Group etc. Content (required): SQL for fetching Item, Item Class, Attribute and Attribute Group etc. …Goopikrishnan Jayaraman-Oracle 2.2K views 2 comments 0 points Most recent by Ramaraj M Product Master Data Management -
OTBI Report for EthnicitySummary OTBI Report for EthnicityContent Hello, CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker".…Shanna Oppenheim 643 views 79 comments 2 points Most recent by Juliet Eaton Reporting and Analytics for HCM -
Accounts Receivable RollForward ReportSummary: Is there a delivered AR Rollforward report in Fusion OTBI? Content (please ensure you mask any confidential information): Version (include the version you are u… -
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…Sylvia Wong 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting for Questionnaire DataSummary: We have multiple Observation Checklists and Learner Evaluations within various learning items in Oracle Learn, but I'm not seeing where we can pull the data fro…
-
Why can't I see DFF configured in Trading Community Model in OTBI Receivables subject area?Summary: DFF has been setup in Manage Trading Community Organization Descriptive Flexfield under the application Trading Community Model, and Module is Trading Community…Jennifer-Leung 21 views 1 comment 0 points Most recent by Marius Neagu - Oracle Support-Oracle Receivables & Collections
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
Project skill matrixSummary: Dear Experts, I would like to build the following scenarios in Oracle Cloud Learning and need guidance on the best approach to implement them. I would like to u…
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…Suganya v 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Need to report the number of Goal plan assignees who have Goals Created/Not createdSummary: Hi peers, My client wants a report that gives a count of the number of employees that have created goals as well as those who haven't yet created (even a single…
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - ORC Report - How to pull the Offer accepted application status and Background Check applicatiSummary OTBI - ORC Report - How to pull the Offer accepted application status and Background Check application statusContent Hi. We have the candidates who accepted thei…Shabber Shaik 70 views 3 comments 0 points Most recent by Abhiram Vissamsetty Reporting and Analytics for HCM -
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…Anand.a.Gaurav-Oracle 42 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To remove NULL row occurring due to CASE statementThrough OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement: CASE WHEN "…
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 126 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP -
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens… -
Multi Language update to existing OTBI reportsSummary: Multi-Language: How would you create or update existing reports to pull in any language? Is there a way to update all reports simultaneously with the option to …
-
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ?
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra…Vasanthakumar Ravi 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
For OTBI Analysis not getting data in correct formatSummary: I am trying to built a analysis bases on 2 Subject areas Project Billing Revenue real time and Project costing Actual cost Real Time, this issue is like I am tr…