BI Publisher
Discussion List
-
Possibility to use a BI report as Learning ActivitySummary: Possibility to use a BI report as Learning Activity Content (please ensure you mask any confidential information): Hi, we would like to create a course in LMS. … -
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
Can we extract data from oracle fusion ERP using BICC and deliver it to SFTP serverSummary:Hello Folks, We wanted to know if it is possible to extract maximum data from fusion ERP using BICC and deliver it to SFTP server. Thank you. Content (required):…
-
What is the recommended setup for timezone?Summary: What is the recommended setup for timezone? Content (please ensure you mask any confidential information): We are currently implementing Oracle Financials Cloud…Swapnil.S 51 views 2 comments 0 points Most recent by Swapnil.S Payables, Payments & Cash Management
-
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
How to get Rules for Account Payables Invoice Approval and Holds ApprovalSummary: Hello Colleagues, Good day! With regards to Approval Rules, we would like to ask where we can retrieve the Account Payables Invoice Approval and Holds Approval …Ralph Aldrich Magno 21 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 452 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM -
Seeded Reports - Key RMCS Reports and OTBI ReportSummary: Can someone guide me for Key RMCS Reports and OTBI Report in latest versions. Content (please ensure you mask any confidential information): Version (include th… -
Empty Reports on BIP Result files with DATA_DSSummary DATA_DS file removalContent Hello. I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day. … -
What is the maximum number of lookup codes that can be defined in a common lookup?Summary: We have a requirement on custom BIP report for AR Receipts, if the report is printed again for the same receipt number then report output should have 'REPRINT' …Mayur_Gidwani 82 views 12 comments 0 points Most recent by Venkat Patlola-Oracle Receivables & Collections -
Adding distribution budget date, accounting date and expenditure item date to AP Invoice Approval RTSummary: Has anyone added these fields to the AP Invoice Approval RTF? Content (required): Users are requesting we add this to aid in year end processing of invoices to …Alex Glose 81 views 3 comments 0 points Most recent by Alex Glose Payables, Payments & Cash Management -
Invoice Print Template criteriasSummary: I would like to have 2 different criteria for Invoice Print Template Content (please ensure you mask any confidential information): If I have only criteria like…usr_a.nv 31 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 71 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 52 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Where can we see the audit details for Payable invoiceSummary: Hi Team, I have created two invoices with an invoice amount of 2000.00 INR. Subsequently, I updated one of the invoices with the amount of 3000.00 INR, and for …Venkateswari 11 views 3 comments 0 points Most recent by Jesus N Payables, Payments & Cash Management
-
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
All cost centers are not appearing in gl_seg_val_hier_rfSummary: We have few cost center present in same tree node still few are missing in gl_seg_val_hier_rf What can be possible reason? Content (please ensure you mask any c…Nidhi Chhajed 101 views 4 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI Publisher -
Count of development Goals analysisSummary Can't add people with 0 Goals altogether with other Assignment fieldsContent Hi Team, We are trying to build an OTBI analysis that lists Person Name, Person Numb…Alvaro Couto 21 views 3 comments 1 point Most recent by Shawn Gertler Reporting and Analytics for HCM -
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 71 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to create Formula type Depreciation Method with different Depreciation Rates for different PerioSummary How to create Formula type Depreciation Method with different Depreciation Rates for different Periods?Content Hi Experts, I have requirement to create the calcu…
-
Report to show Employees serving Probation PeriodSELECT Command for extracting Employees that are serving probation period.
-
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Customer Statement - Advise of unsuccessful emailed statementsSummary Customer Statement - Emailed - Advise of unsuccessful emailed statements requiredContent This surfaced after a training session with the client where in the ques…
-
How do I connect SmartView to ERP Cloud?Hi, It's been a long time. In the past when Cloud ERP was fairly new(4yrs ago). I remember on a project we connected SmartView to Cloud ERP. If I remember right, ERP spi…Hyperion_Junkie 641 views 2 comments 0 points Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.4K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP