BI Publisher Data Models
Discussion List
-
BIP OptionsContent Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help! 1) Is it possible to allow users to type into a paramet…Prudence K 35 views 12 comments 5 points Most recent by Isaline Nguyen General Transactional Reporting (OTBI) -
Published Report Schedule - showing message if attachment has nothingSummary If the published report attachment has no data, can we put that in the body of the message?Content Hello, For a personal BIP report schedule, if the attachment h…Stephanie Gott 16 views 0 comments 0 points Started by Stephanie Gott General Transactional Reporting (OTBI) -
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patchContent New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be…Senthilrajan V 19 views 0 comments 0 points Started by Senthilrajan V 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 155 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 49 views 1 comment 0 points Most recent by RyanPatrick General Transactional Reporting (OTBI) -
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not ProvideContent Hi, we're in the middle…Juan Miguel Isip-94819 32 views 0 comments 1 point Started by Juan Miguel Isip-94819 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 59 views 8 comments 0 points Most recent by rajArun General Transactional Reporting (OTBI) -
GET_DURATION function syntax in Release 13Summary We are getting error in Release 13 because of wrong number or types of arguments in call to GET_DURATION'Content We are getting error in Release 13 because of wr…Mahesh Ganji-29437 21 views 0 comments 1 point Started by Mahesh Ganji-29437 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 26 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
Dynamic Report layouts in BI PublisherSummary Dynamic Report layouts in BI PublisherContent We have a requirement from a client where from the prompts, if we select any attributes you report layout has to sh…Ramesh Pusarapu 37 views 5 comments 0 points Most recent by Ramesh Pusarapu General Transactional Reporting (OTBI)
-
Dashboard Custom Print and Export design in 12CSummary Any resources that give detailed instructions on how to design a custom print layout?Content Hello, I have stumbled across a 'Custom Print and Export Layouts' fe…Stephanie Gott 18 views 0 comments 0 points Started by Stephanie Gott General Transactional Reporting (OTBI)
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …Abdalaziz Barham 88 views 1 comment 0 points Most recent by Abdalaziz Barham General Transactional Reporting (OTBI)
-
Dynamically place the custom logo in BIP reports in Fusion CloudSummary Dynamically place the custom logo in BIP reports in Fusion CloudContent Hi, We need to developed few custom reports as per the requirements. In this implementati…Islam Abu Khamseh-76822 47 views 3 comments 0 points Most recent by rajArun General Transactional Reporting (OTBI)
-
Packages in BI publisherSummary Packages in BI publisherContent Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pac…Islam Abu Khamseh-76822 36 views 1 comment 0 points Most recent by rajArun General Transactional Reporting (OTBI)
-
Translate SQL of OTBI in ApplicationDB HCMSummary How to Translate SQL of OTBI in ApplicationDB HCM?Content Hello, I have verified that in SA of OTBI there aren't some value that I want to use in a report. I fou…Giuseppe 1234 63 views 1 comment 0 points Most recent by Vijaya Kumar-70229 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 17 views 0 comments 0 points Started by AshishERPCloud General Transactional Reporting (OTBI) -
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo…Nirmal Kumar L 34 views 3 comments 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sqlContent Hi, Anyone know how to fetch the manager name for the terminated employees? For …Nirmal Kumar L 43 views 1 comment 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Data model with parameter with "Select all"Summary Data model with parameter with "Select all"Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employee…Giuseppe 1234 43 views 10 comments 0 points Most recent by Nirmal-64675 General Transactional Reporting (OTBI)
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…Aaron Leggett 42 views 2 comments 0 points Most recent by Manoj Madhavan General Transactional Reporting (OTBI) -
Time in role reportSummary I need to create a time in role reportContent I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Emplo…Peter Kirwan 21 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 General Transactional Reporting (OTBI)
-
Bursting ReportSummary A report on Probation which bursts out to Line ManagersContent is there any example reports which look at Probation Period? Also sample reports for Bursting?Peter Kirwan 89 views 1 comment 0 points Most recent by Sowdhaminya Murugan General Transactional Reporting (OTBI)
-
Access Denied for user to path..Summary Access Denied for user to path..Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific use…AbulKhair 61 views 1 comment 0 points Most recent by Rick Brobbel General Transactional Reporting (OTBI) -
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all dataContent Any suggestions on how to get the subtotals added to this report? Example below, want totals fo…Michelle Slobig Rotsolk 31 views 1 comment 0 points Most recent by Manoj Madhavan General Transactional Reporting (OTBI) -
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where …Nirmal Kumar L 24 views 0 comments 0 points Started by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sqlContent Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to …Nirmal Kumar L 185 views 1 comment 1 point Most recent by Manoj.Gupta General Transactional Reporting (OTBI)
-
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…Aaron Leggett 27 views 2 comments 0 points Most recent by Brett-28437 General Transactional Reporting (OTBI)
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 16 views 0 comments 1 point Started by Aaron Leggett General Transactional Reporting (OTBI)
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12?Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/unar…Gala Meyerovich 62 views 4 comments 0 points Most recent by Gala Meyerovich General Transactional Reporting (OTBI) -
Embedded Reporting/BI PublisherSummary audit report using offer fieldsContent Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for the…Alice Kim, SPHR-SCP 48 views 5 comments 1 point Most recent by Alice Kim, SPHR-SCP General Transactional Reporting (OTBI)