BI Publisher
Discussion List
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
How to include attachments from the main transaction page into a custom reportSummary: Hello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…Abby Chen522 61 views 11 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 51 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
where are segment member aliases stored in the oracle financials database?Summary: Where can I find the aliases for individual segment members in the oracle financials database tables? Content (please ensure you mask any confidential informati…josstenger 1 view 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…Salma Mohamed Salem 81 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…simonl 51 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 57 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…Rakesh Sreenivasa 85 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need to know the table and api for Fusion application notification setupWe want to know the tables and web service APIs of the below two locations of notification setup. As we are creating bip reports and integrations for the same. Navigatio…
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D -
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 31 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
How to join ZMM_NOTES to RA_CUSTOMER_TRX_ALLHello, I am trying to construct a sql query to pull notes related to AR Invoices, can anyone assist, I had thought the source_object_uid in ZMM_NOTES would join to the p…Robert of STAU 211 views 5 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…Aparna N-Oracle 11 views 3 comments 0 points Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
How to create language (billto-site language) dependent BIP invoice template?Summary: We try to find a way (Oracle supported or best practice) on how to use multi language templates depending on our customers bill-to-site language setup. Oracle F…Frank.Steinjan 71 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…Ninad Joshi 81 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How does gms_ffr_indirect_expenses table get populated? Is it from another source tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Annie Li 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
how to store burden rate details to table gms_ffr_indirect_expensesSummary: Where do data come from for the Federal Financial Report table gms_ffr_indirect_expenses Content (please ensure you mask any confidential information): Version …Annie Li 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…George Mattar 89 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…Hitesh Khandelwal 11 views 2 comments 0 points Most recent by Hitesh Khandelwal Reporting and Analytics for ERP
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…Cesar Saveedra 475 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r…