OTBI
Discussion List
-
OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI template?Hi Guys In OTBI for “General Ledger - Journals Real Time” I can see 2 fields for a Journal Header I can potentially leverage: Journal Header "Additional Information (Nam… -
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…Amrish_Amradkar 43 views 2 comments 0 points Most recent by Yann Consolin-Oracle Reporting and Analytics for SCM
-
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
Can you Delete Analysis previously used in Learn to assign CoursesSummary: Can you Delete Analysis previously used in Learn to assign Courses Content (please ensure you mask any confidential information): Hello We have a number of Anal…
-
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
allow ordering from unassigned sites on Blanket Purchase Agreements is not available in OTBIhttps://us.v-cdn.net/6034893/uploads/FH62H9CNBAYX/allow-ordering-from-unassigned-sites.pdf We utilize the "allow ordering from unassigned sites" control on Blanket Purch…
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
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.3K 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 41 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 "…