BI Publisher
Discussion List
-
OTBI create/edit/view accesshi, We have a requirement to give OTBI access to business users. business user should be able to create/edit/view report for all the subject areas Should not have access…Nivya Mathire 51 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 483 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…
-
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…Manoharan 31 views 2 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM
-
How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ?Summary: How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ? Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud…
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…User_2025-02-05-02-38-04-251 42 views 6 comments 0 points Most recent by Zehra M Reporting and Analytics for ERP -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 34 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM
-
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 51 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…User_2025-02-03-21-28-21-735 54 views 3 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for HCM
-
Need to display Employee Image in the BIP report outputSummary Requirement to display Employee Image along with employee details in the BIP report outputContent Hi All, We have a requirement to display Employee Image and wit…
-
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 56 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM
-
To capture Personal Payment method changesSummary: To capture Personal Payment method changes Content (required): Planning to develop a extract to capture personal payment method changes . My question is , how t…
-
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
The report cannot be rendered because of an error, please contact the administrator.Summary: We have a custom report and when business user is trying to run the report below error is displayed Content (required): The report cannot be rendered because of…Kaushik Pola 614 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl…
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to identify process id of data load triggerred using HCm extractSummary: Need to know logic to find process id of a HDL load carried out using "inbound integration" delivery type option within a HCM extract using a BIP query Content …
-
Which table has data for 'Manage Data Access for Users' where security context is 'Legal Entity'Summary: We have created a BI Publisher report which is restricted to role - 'Cash Manager' via permission option. From task 'Manage Data Access for Users' we can restri…Sudip Kumar Mishra 752 views 0 comments 1 point Started by Sudip Kumar Mishra Payables, Payments & Cash Management
-
How to wrap BI ParametersHi, I would like to have two lines for parameters instead of a single line when reports have more than 4 parameters. Is there any way to wrap or split BI report paramete…
-
How to make MICR bold in AP checks?Summary: Couldn't make MICR bolder using the AP checks in RTF Template. Content (required): i I have tried changing the MICR tag bold in RTF template ii I have tried add…Krishna Kumar v 11 views 0 comments 0 points Started by Krishna Kumar v Reporting and Analytics for ERP -
REST API for Receivable Invoices (CM/DM/ONACC)Summary: Hi Team I am looking for API to get the details of Credit Memo, Debit Memo and On Account Invoices. I am not able to get those data when using /resources/latest…sailesh_cloudare 121 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Why to use e-text format in BIP report when we can use default csv formatSummary: Why to use e-text format in BIP report when we can use default csv format Content (required): Why to use e-text format in BIP report when we can use default csv…ShitalRamteke 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is it possible to trigger Notifications while adding or replying to comments in learning community.Summary: Need to Trigger Notification to community learners when there is any comments or reply added into the learning community portal. is there any seeded functionali…
-
How to View BIP Report Output in CSV Without Creating a LayoutSummary: Default the output of BIP Report to csv without having to setup a layout Content (required): In order to set the Default Format of a BIP report to csv you must …Rory Mullin 393 views 3 comments 0 points Most recent by Rory Mullin Reporting and Analytics for ERP
-
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…Satyavrat_Savarn 81 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 146 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-…Anders W. Langholm 2 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-…
-
From what basis data's are populating to AR_STATEMENT_DELIVERY TableSummary: From what basis data's are populating to AR_STATEMENT_DELIVERY Table Content (required): Version (include the version you are using, if applicable): Code Snippe…CJPandian 84 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections