Discussion Forums
Discussion List
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: ****-XX-XXXX (112-10-1234) TI…satya_nvs 23 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI) -
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI General Transactional Reporting (OTBI) -
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rashmi M-Oracle 5.2K views 14 comments 10 points Most recent by LCann-Oracle General Transactional Reporting (OTBI)
-
View/Table details for Data SecuritySummary: Hi Everyone, We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table detai…Maruvada Sanat Kumar-Oracle 13 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
which subject Area need to take for Talent RatingsSummary: Hi team, we have new requirement on Talent ratings of employees So how can I go with and in which subject area below columns are available ? Talent ratings>care…AjayKumar Maddipati 22 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 25 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In OutputContent The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for asso…User_EQ8R5 5 views 2 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
How to version OBIEE report output sent to webcenter content serverSummary OBIEE reports are scheduled to send to WCC but getting "file already exists"Content We have several scheduled reports in OBIEE that are configured to send to the…John Stinnett 18 views 5 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 21 views 1 comment 0 points Most recent by aconavay General Transactional Reporting (OTBI)
-
Deferred Termination field in OTBISummary looking on how to determine a deferred terminationContent Hello, I have been asked to create a report showing the associates with a deferred termination. When th…Kevin Lee Choon 31 views 3 comments 2 points Most recent by prjohnson General Transactional Reporting (OTBI)
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspa…User_AEMC1 19 views 2 comments 3 points Most recent by user650055 General Transactional Reporting (OTBI) -
Use ESS to run a BI Publisher job that transmits reports via SFTPSummary Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?Content We have built some Custom Reports in BI Publisher that extract data …Juan Miguel Isip-94819 53 views 7 comments 1 point Most recent by rajArun General Transactional Reporting (OTBI) -
R13.19C Introducing OTBI Metadata Independent Mode Using BI Cloud Connector (BICC)Summary Opt in to use the OTBI Metadata Independent Extract Mode in BICC introduced in R13.19C.Content What is the Change? Starting in Release 13.19C, BICC will no longe…Rohan Lobo-Oracle 718 views 5 comments 7 points Most recent by Rohan Lobo-Oracle General Transactional Reporting (OTBI)
-
How to Pass Parameter from Dashboard to BI ReportSummary Passing Parameter from Dashboard to BI ReportContent Hi Experts, I have a BI Report which has a parameter. (A List of Value Item which gets value from a SQL Quer…AshishERPCloud 230 views 21 comments 1 point Most recent by sameer ashturkar General Transactional Reporting (OTBI) -
Formula to capture last 7 days of dataSummary Formula to capture last 7 days of dataContent Hello, We are looking to capture requisition in specific statuses (Approved, To Be Approved, Draft, Sourcing and Fi…Nicole Hicks 45 views 7 comments 1 point Most recent by rajArun General Transactional Reporting (OTBI)
-
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releasesContent Creating Reports with Direct Database Query in Oracle Fusi…Senthilrajan V 159 views 9 comments 2 points Most recent by Senthilrajan V General Transactional Reporting (OTBI) -
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current BalancesContent Hello, Is anybody aware of a method in which we can view a colleag…Brad Hughes 50 views 1 comment 0 points Most recent by RyanPatrick General Transactional Reporting (OTBI) -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.Content I am searchi…Tim Welsh 62 views 8 comments 0 points Most recent by rajArun General Transactional Reporting (OTBI) -
Reporting Options for data source in PaaS and SaaSSummary Reporting Options for data source in PaaS and SaaSContent I understand we have OTBI and BI tools available to report out of SaaS Data Source. Similarly, * What a…Raghuram Nanda Krishnamachary 52 views 1 comment 0 points Most recent by Shakher Sharma General Transactional Reporting (OTBI)
-
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 27 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
Contract Changes in HCM CloudSummary How to handle changes to contract using HCM CloudContent Hi, We are using HCM Cloud and one of our areas we are falling down on is changes to peoples contracts I…Graeme Thomson 26 views 0 comments 0 points Started by Graeme Thomson General Transactional Reporting (OTBI)
-
mapping between EBS tables and oracle fusion cloud tablesSummary mapping between EBS tables and oracle fusion cloud tablesContent Hi Team , as the schema changed from EBS to oracle fusion cloud so Is there any document that ma…Islam Abu Khamseh-76822 68 views 0 comments 0 points Started by Islam Abu Khamseh-76822 General Transactional Reporting (OTBI)
-
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr…user11018780 52 views 0 comments 0 points Started by user11018780 General Transactional Reporting (OTBI)
-
Is It Possible to Create a BI Report from RSS Feed in Oracle HCM CloudSummary Is It Possible to Create a BI Report from RSS Feed in Oracle HCM CloudContent Hi Experts, Can we create a BI Report from RSS feed. Any documents/pointers/insight…AshishERPCloud 18 views 0 comments 0 points Started by AshishERPCloud General Transactional Reporting (OTBI)
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin ViewContent In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but m…Jonathan Jackson-2093 43 views 1 comment 0 points Most recent by jcs General Transactional Reporting (OTBI)
-
Hands-On Training/Consulting Svcs on OBI DashboardsSummary Hands-On Training/Consulting Svcs on OBI DashboardsContent Hello:) Can anyone recommend a consulting services that provides hands-on training for OBI Dashboards?…Melva McElroy 25 views 1 comment 0 points Most recent by David Ivester General Transactional Reporting (OTBI)
-
Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI exportContent When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day …
-
Need Help in Creating a OTBI Analysis from Simple Logical SQLSummary I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurenceContent I have attache…AshishERPCloud 59 views 1 comment 0 points Most recent by Merrick Hartslief General Transactional Reporting (OTBI)
-
User BI ReportSummary Report on Total UsersContent Wanting to run a report on Users only. Trying to produce a report on All Users in the All Users Group with details Username. First N…Kylie Ross 64 views 0 comments 0 points Started by Kylie Ross General Transactional Reporting (OTBI)