Category 129
Discussion List
-
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …Scott McAnally 21 views 9 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
Logo in BI Publisher RTFIs there any way of embedding a logo dynamically in BI Publisher RTF ? We wish to show different logos based on different legal entities.
-
BI Publisher - How to pivot to display questions horizontally using answers instead of measuresSummary: BIP - How to pivot to display questions horizontally as the heading using answers instead of measures, displaying respondents as the first column Content (requi… -
OTBI including an header sectionSummary: We have defined an OTBI that exports lines with the images uploaded in the Fusion Product Hub module (SCM). Can be possible to include before the table section …adelsorbo-Oracle 1 view 5 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c… -
Can I create a button to print or cancel, when executing a report in BI?Summary: Can I create a button to print or cancel, when executing a report in BI? If possible, what would be the next steps? Content (required): Version (include the ver…
-
How to convert xml data to columns in BI Publisher report Using ExtractValue?Summary: How to convert xml data to columns in BI Publisher report Using ExtractValue? Content (required): Version (include the version you are using, if applicable): Co…Lydia Jayasingh 1 view 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 1 view 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…Saunak Mitra 21 views 2 comments 1 point Most recent by Roman Havrylyak Reporting and Analytics for ERP
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…AngelOftheNorth 1 view 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 1 view 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 1 view 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti…Sergio F Oliveira 1 view 3 comments 1 point Most recent by Sergio F Oliveira Reporting and Analytics for ERP -
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…Miyuru Guruge 1 view 4 comments 0 points Most recent by Miyuru Guruge Reporting and Analytics for ERP
-
seed report for intransit shipment (what id the tables ?)Summary: i need what a seeded report for intransit shipment ? and what is the tables to create this report ? Content (required): Version (include the version you are usi…
-
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…Miyuru Guruge 1 view 2 comments 0 points Most recent by Miyuru Guruge Reporting and Analytics for ERP
-
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 11 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Subject Area Security - Unable to view data from relative subject area despite having role assignedSummary: Subject Area Security - Unable to view data from relative subject area despite having role assigned Content (required): I am currently attempting to troubleshoo…User_IO0OQ 1 view 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …User_1CG6B 1 view 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Is there any OTBI subject area where "associated collaboration documents fields" can be found?Summary: Fields details: Navigation: Supplier > Sites > General > Associated Collaboration Documents Service Provider Trading Partner ID Partner ID Type Document Associa…User_6R773 1 view 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie…Mike Burnett 1 view 4 comments 4 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
SQL for Period Close Exceptions ReportSummary: SQL that generates reports Content (required): Hello, I am new as report guy at my company, and I would need to extract the SQL that generates this report 'Peri…
-
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…AngelOftheNorth 1 view 2 comments 1 point Most recent by AngelOftheNorth Reporting and Analytics for ERP
-
What table contains the Receipt Amount in Contract Billing Details screenSummary: Hi - what is the underlying table(s) that contain the Receipt amount in the contract billing screen Content (required): Where is the table containing this data …
-
How to show Payment Amount by Fiscal Period?Summary: I have a requirement to write an OTIB report to show total payments by fiscal period and supplier. Content (required): I've created the report using the Payable…
-
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 1 view 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
What is the best BICC PVO that matches to HR_LOCATIONS_ALL?Summary: Need BICC PVO that best aligns with on-prem table HR_LOCATIONS_ALL. I've looked at the most recent lineage mapping spreadsheet and the closest one I see is: Con…
-
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT…
-
How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 11 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Expense Report - all expenses by cost centerSummary: Content (required): We have an analysis created using Expense - Expense Transactions Real Time. When a user runs the report, they get their own expenses. When a…