-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted May 16, 2018 by Mahesh Ganji
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers in General OBIEE publicTitle: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 wrong number or types of arguments in call to GET_DURATION'.
'ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_DURATION'
Note: This function was working fine in Releases 9 to 12.
Any help in this regards ?
Thanks - Mahesh
- Topic posted April 5, 2018 by Doron de Jong
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, Setup, Setup/Administration, SQL in General OBIEE publicTitle: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 segregated to themselves/their own cost centre.
The reports I am looking to do is a procurement requester report I have build, and I want users to be able to see all POs that they have raised and are requester for. What custom role/seeded role is their so they can have a view of this report (I also want to pin this report onto there oracle homepage - is this possible?)
Another role I want to create is so that cost centre managers can see all POs raised to their cost centre only. How can I do this?
Finally I want to create a role for expenses where a manager can see a report of all expenses that their team (Line manager hierarchy) have raised. Is this easy to do?
Thnx
- Topic posted March 22, 2018 by Swathi gogula, tagged BI Publisher Report Templates, Customizing Layout, Customizing Reports in General OBIEE publicTitle:NACHA format filesSummary:NACHA format filesContent:
Can we create NACHA format files using BI Publisher template builder in Cloud? Any documentation for creating the same will be helpful.
Regards,
Swathi
Topic posted March 2, 2018 by Stephanie Gott
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Data Models, OBIEE Answers, Report Delivery, Report Layouts in General OBIEE publicTitle: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' feature in our OBIEE 12C dashboards. I got as far as importing into BI Publisher data model and report (which I am familiar with as well) but that's about as far as I got. This looks different than other BI report layouts I'm used to, etc. Is there any good documentation or examples out there that could help? I've read through the generic Oracle doc that tells me the limited information that I already know. Any more advanced info out there?Thanks,
Stephanie
- Topic posted March 1, 2018 by Ramesh Pusarapu
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates in General OBIEE publicTitle: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 show case those field attributes in the report layout.
Any help is highly appreciated
- Topic posted February 14, 2018 by Richa, tagged BI Publisher, BI Publisher Report Templates in General OBIEE publicTitle:not able to divide two columns RTF TemplateContent:
we are trying to divide two columns but its not working.we are using the below code.
<?CURR_TOT_GAURENTEED_COMP?>DIV <?NEW_TOT_GAURENTEED_COMP?>
- Topic posted January 22, 2018 by Islam Abu Khamseh, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, Report Layouts, Reports in General OBIEE publicTitle: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 implementation we have around 30 companies each of them has its own logo.
so in the report template we need to make the displaying logo dynamic
means if user from COMP1 run the report then LOGO1 will appear .
and if COMP2 runs the report then LOGO2 will appear.
Is there any flexibility where we keep the logo in one particular location and pull the logo dynamically in the report template in FUSION CLOUD?
or there is another way to do it fusion cloud ..For example if we can upload the logos to a path in fusion server and from the template we call them .
I am not sure how to do this in fusion
Please advise
- Topic posted November 23, 2017 by Nirmal Kumar L
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Customizing Reports, Data Models, OBI Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, SQL in General OBIEE publicTitle:Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary:Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent:Hi,
We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.
Thanks,
Nirmal kumar 
Topic posted November 16, 2017 by Ling Xiang
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Tip in General OBIEE publicTitle:Fusion BI Catalog Folder Management Best PracticesSummary:A white paper on Fusion BI Catalog Folder Management Best PracticeContent:This white paper provides the best practices for working with BI catalog folders, and suggestions on actions for accidental move or deletion of a folder.
Document:- Topic posted November 14, 2017 by Sandip Kumar, tagged BI Publisher, BI Publisher Report Templates, Public Sector in General OBIEE publicTitle:BI Publisher Report as Cloud Data Extract engineSummary:Use of Report as Cloud Data Extract engine and keep track of extracted data/ recordContent:
Cloud Integration process where data is extracted and sent via FTP to other partner applications.
If this process is performed on a scheduled basis (or manual run) then it becomes difficult to find out which records were extracted earlier and where are NOT? Other mechanisms are used to remove already extracted records from being sent twice.
Could we perform the following steps:
#01: BIP Report is given the capability (similar to EBS) to update some DFF fields (not other fields) from the source tables (data being pulled) to update and store them so that next run could validate and exclude these records. This should be kept as datatime field so that it can keep track of when the data was pulled. In addition, if the record was updated then the record should be pulled second time in BIP. This could be performed on Datatime and "Last_Update_date" comparison.
#02: ATOM configuration could accommodate custom BI Publisher reports so that one can create reports and send via ATOM audit structure to FTP / emial