Reports
Discussion List
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sql
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Ramzzz 72 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center
-
Oracle Fusion Application MT Timezone is not reflecting sometimes in OTBI ReportsHi Everyone, I have set the timezone in oracle fusion application as UTC-07:00 Denver - Mountain Time (MT) and now when I am creating an OTBI analysis and using Now() fu…Himansh Agarwal 27 views 0 comments 0 points Started by Himansh Agarwal BI Publisher Learning Center
-
Bi Reporting Error #221When attempting to open our organisation structure report we are being hit with an error as shown in the screenshot attached. This error is occurring when initially tryi…
-
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
Use .XLS template with Excel MacroIs it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply for…
-
How to find the sum total of an element for all the groups in rtf template?Hi, I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template. The scenario is there are …
-
How to group rows based on one column and then find the sum for each group?Hi, I am working on a rtf template where it is required to group the records based on the tax code value. Now I want to show the sum of amount for each tax code in diffe…
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
HCM Extract attribute back end QueryHi All, We need your help in finding out the Actual query being used in the back end of Attribute in HCM Extract. We built a HCM Extract with data group using the user e…
-
query for receivables receiptsI wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help m…
-
How to create from and to date parameter without default and mandatory fileHow to create from and to date parameter without default and mandatory file in BI PublisherRitika.ray-Oracle 21 views 7 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
how to add prompt of Start Accounting date and end accounting date in FRS reportHi, I am looking out for ways to pass a period range Prompt in FRS report based on which my columns will dynamically be fetched. However i can't seem to find the ways to…
-
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d…
-
Need help with checkbox wingding.ttf font fileHi All, we have a requirement to insert check box in a report. based provided "DocID: How to Add a Checkbox in a BI Publisher Report ( Doc ID 2692589.1 )" For the checkb…
-
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and…
-
BI Publisher Word Plug-In ErrorI have the Word Plug-in that has previously worked without issue, however it is now kicking back an error when I attempt to preview my data. Steps taken: Opened rtf temp…
-
Remove Banner from BIP Report templateIs there a setting to remove the below banner from BIP templates (.rtf) that output in Excel format, either globally or at the report level? This banner is not in the ac…KDR 81 views 14 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
BIP Samples?Is there another place to see samples of reports? the links from this page are brokenWayne Van Sluys 22 views 3 comments 1 point Most recent by Bhaskar Konar BI Publisher Learning Center
-
Maximum Number Of Columns Created In Excel RTF TemplateHi All, What is the maximum number of columns supported by Oracle Fusion BIP report having Excel Template. Regards VijaiVijai Bhatia 53 views 4 comments 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
Does oracle has any table that give us Users Signin and signout details for the past few weeksFor auditing purpose we want a report to extract the users who login and logout in the past 7 days login datetime logout datetime if any table or pre-build tables please…Chandra Thangavelu 72 views 5 comments 0 points Most recent by Chandra Thangavelu BI Publisher Learning Center
-
Would like to report on HR Help Desk Audit History table in BI PublisherHello, We would like to report on HR Help Desk audit history in a BI Publisher report. Has anyone done this and might be willing to provide instruction? Thank you, Natal…Natalie Andrek 51 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
Narayanan Subramaniam-Oracle 62 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Is there a way to organize the Shared Reports and Analytics in PD?Currently we have a list of shared reports under the Shared Reports and Analytics task drawer drop down in Product Development. Is there a way to setup folders for bette…Candice Chacon - Dexcom 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Report Missing NotificationsHi All, We have loads of notifications we have from Oracle and few we develop custom. We have them scheduled and some are BI Bursting notifications. Due to multiple reas…Vibha Pandey - Oracle 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…New 41 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Can we suppress a hyperlink in BI Publisher Report PDF Output?We are building a BI Publisher Report in which one of the field has email ids. We are using an RTF template to generate the report output. When we view the output in PDF…Pinky Mukherjee 51 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center