OTBI
Discussion List
-
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 41 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
issues with customized OTBI report in HR Help DeskSummary: we are customizing an OTBI report for the hr help desk module but we are unable to extract the following info: - Which employees (which person ID) did a search …Gianfranco Fariello 42 views 2 comments 1 point Most recent by KMChris-Oracle Reporting and Analytics for HCM -
general ledger - Balance real time subject area not showing hierarchy values for balancing segmentsSummary: In General ledger - Balance Real time Subject area - Balancing segment - There is no value coming in hierarchy (22nd level of hierarchy for balancing segment) t…Shreeya Jain 35 views 1 comment 0 points Most recent by Madhavi.Godbole General Ledger & Intercompany -
I have a requirment to upload PDf file on released work order at header level using Rest API.Summary: I have a requirment to upload PDf file on released work order at header level using Rest API. I can find get attachment rest APIs but not able to find any API f… -
How to check "Note to buyer" before submitting of Negotiation in OTBI ReportSummary: After submitting a "Purchase Reauisition" and before creating a "Supplier Negotiation", I would like to display "Note to buyer" using OTBI Report. Content (plea… -
Can we report on deleted OTBI agents?Hi all, We seem to be unable to find a very important OTBI agent - at this point having gone through each folder we can only conclude somebody deleted it. Is there any w…Cora_Stanciu 11 views 2 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin… -
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t… -
Which Subject Area does Default Maintenance Work Order type and Subtype from Asset page can be foundWhich Subject Area does Default Maintenance Work Order type and Subtype from Maintenance Assets page can be found? -
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…Veera_CPS 112 views 4 comments 1 point Most recent by Veera_CPS Payables, Payments & Cash Management -
sql query to extract standard cost details in FBDISummary: I need to extract item standard cost details for a particular valuation unit in the same format as FBDI templates for item standard cost and then upload it to a… -
Manager only saves ratings (no submit) and then the OTBI report is run, are saved ratings fetched?Summary: Hi Peers, Our client has a requirement relating to an already live Performance Evaluation. They want to calibrate the rating (as an afterthought) Instead of add…S Shree 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Rating Subject Area showing future cost center instead current cost center informationSummary: Workforce Performance - Performance Rating Real Time Subject Area showing future cost center instead current cost center information Content (please ensure you …VarunG 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Data is not fetching When I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment DetailsSummary: No records are fetching when I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment Details from Workforce Management - Worker Assignment Real Time with another…sayeed_ahmed 22 views 9 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 11 views 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM -
Import AutoInvoice Successful Transactions ReportSummary: Is there a report which lists down details of all transactions that were successfully interfaced into Oracle AR (not just the count)? Content (please ensure you…Francine Gemora 61 views 3 comments 0 points Most recent by Francine Gemora Receivables & Collections -
Hide the OTBI Seeded Folder in the shared folderSummary: Is it possible to hide the OTBI seeded folder in the shared folder and will just only show the custom folder? Content (please ensure you mask any confidential i…Altagracia Javier 41 views 1 comment 0 points Most recent by Haripriya-Oracle Reporting and Analytics for ERP -
OTBI Deep link not workingHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 31 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 11 views 1 comment 0 points Most recent by Swapnil Kashid Product Master Data Management -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh… -
Invoice Distributions Prepayment amount remainingHello We are creating a report to reconcile prepayment in OTBI. We are facing a case that the "Invoice Distributions Prepayment amount remaining" field for unpaid prepay…Kamonwan Srasrisom 11 views 2 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management -
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
What is the role required to access the Negotiation OTBI reports?Summary: We need to know the exact role or privilege required to access the Negotiation OTBI reports. Content (please ensure you mask any confidential information): Vers… -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Course CategorySummary: Hi, Do you know where can I find the course category either in BI Publisher or in OTBI? Content (please ensure you mask any confidential information): Hi, Do yo… -
OTBI analysis joining General ledger and Project subject areas blank fieldsSummary: We are trying to pull GL transaction data and add the project and invoice information to it when relevant. Content (please ensure you mask any confidential info…Tashi Temple-Wood 168 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM