OTBI
Discussion List
-
Receivables Source Missing in OTBI Payables Transactions Real Time Despite Appearing in Manage InvoiSummary: In Oracle Fusion OTBI, I’m trying to build a report using the Payables - Transactions Real Time subject area to track refund-related invoices. The report needs …Sejal Mehta 11 views 0 comments 0 points Started by Sejal Mehta Payables, Payments & Cash Management -
How to adjust the alignment of output messages within the OTBI dashboard reports?Summary: Hi Team, Could you please advise on how to adjust the alignment of output messages within the dashboard reports? I’ve attached a screenshot below for your refer…Saras Mudliyar 11 views 0 comments 0 points Started by Saras Mudliyar Reporting and Analytics for HCM
-
"Go Noto" Font Used in PDF OutputRegarding the default "Go Noto" font used in PDF reports generated by BI Publisher or OTBI, could you please let me know whether the font available for download from the…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 573 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464…
-
Looking for Questionnaire Question / Check-In Questionnaire manager and worker response textI’m currently working on building an OTBI report to extract “Questionnaire Question” responses from the Workforce Performance – Performance Rating Real Time subject area…
-
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 14 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM
-
Scheduled Work Order Traveler print process causing duplications on shop floorWe currently have an ESS job scheduled to run every hour to print all work orders in the "Released" status. The problem we are having is that it will print duplicates if…
-
OTBI AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 12 views 2 comments 0 points Most recent by A Lotfy Payables, Payments & Cash Management
-
Link Between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) & quality (ENQ_ISSUES_B) in oracle fusionHi All, we are developing a report to get the Quality Issue approval notification details. We are unable to link the WFTASK to ENQ_ISSUES_B. The WFTASK.IDENTIFICATIONKEY…
-
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie…Valerio Curzi 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
We are trying to obtain a Audit report which captures audit for customer bank account changes.Summary:We are trying to obtain a Audit report which captures audit for customer bank account changes. The business need is to capture the following details for audit: I…
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi…Aaron Reynolds 32 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur…Rob F 42 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 6.9K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
OTBI complex query assembler. UPDATE - now with 10 subject areas.https://us.v-cdn.net/6034893/uploads/IUFR0AQN0NRH/logical-sql-assembler-v5.xlsx UPDATE: V5 can now assemble up to 10 queries, with up to 15 inner joins. SummaryCombine u… -
Field Created on in OTBISummary: In which subject area of OTBI HCM can the field created on of an action be found?
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
Getting error when running OTBISummary: Getting error when running OTBI analysis using Benefits - Person Information Real time Content (please ensure you mask any confidential information): Hi, Gettin…
-
How to remove access to Approval Group in BPM worklistContent We need to remove the access to Approval Group in BPM worklist for edit/update for all business users and only IT team should have access. Which role/previlege c…DPM 48 views 4 comments 2 points Most recent by SyedMustafaArshad Payables, Payments & Cash Management
-
How to report recognized revenue by Item Code in Oracle Fusion AR with Revenue Recognition enabledSummary: We need to report recognized revenue amounts by Item Code in Oracle Fusion Accounts Receivable. However, since Revenue Recognition (Unearned/Earned Revenue) is …
-
Learning Initiative not assigning course to all learners from analysis report criteriaSummary: Learning Initiative not assigning course to all learners from analysis report criteria Content (please ensure you mask any confidential information): We have cr…
-
Is it possible to create a DFF on Inventory Balance (On-Hand)?The goal is to tag an inventory with Project Details. The business doesn't want to utilize the 'Project Transfer' transaction, as it would create an additional charge to… -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 114 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
Unable to extract OTBI Italian Collective agreements information for WorkersSummary: Content (required): Hi team, We are unable to extract standard fields on contracts for Italian Employees related to collective Agreements with OTBI. Do you have…Gabriele Falso-Oracle 11 views 10 comments 0 points Most recent by Luca Trabucco Reporting and Analytics for HCM -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…Gail Langendorf-Oracle 85 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…Gail Langendorf-Oracle 36 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…Gail Langendorf-Oracle 130 views 2 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM