BI Publisher
Discussion List
-
Help on Defining the LOV in BIP Excel TemplateHi Team, We have requirement to define a Person Name List of value in BIP excel template . Report will be run by Manager. Based on manager scope list of person Name need… -
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p… -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 340 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a
-
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…Basavaraj Navalagi 42 views 3 comments 0 points Most recent by Basavaraj Navalagi Self Service Procurement -
is it possible to translate tags in OTBI in arabicSummary: I am developing a BI report in arabic, but the data I want to print through Tags (dynamically) in report such as Legal Entity Name, Legal Entity address, Bank n…
-
Default person name using SQL query for DFFHi Team, We have a requirement to default the person name on DFF filed using SQL query. By default the DFF value should be the person name who is logged in currently. We…Suresh Manchukonda 25 views 1 comment 0 points Most recent by Suresh Manchukonda Reporting and Analytics for ERP
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
bursting is not workingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
What are the Scheduled Process Tables that could connect to the business unitI'm trying to get the connection of the tables uses to store the scheduled process and join it to the table of business unitShe_1080 31 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …
-
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…
-
Do we have any WebService to display the list of reports in Oracle Fusion ?Summary: Hi Team , Do we have any WebService to display the list of reports in Oracle Fusion ? ** i have used the table : GL_FRC_REPORTS_B , but its of not much use - as…Sridhar Gupta Yerram-Oracle 2 views 1 comment 0 points Most recent by Ayala01 Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Tax Audit Trail Report export to excel doesn't have transaction num but html and pdf does have it.Summary: Export to excel different than html and pdf export. Anyone else have that issue? Content (please ensure you mask any confidential information): Version (include…
-
Date filter in rtf templateSummary: Hi All, Good Day! The template is in RTF . need to see the output in excel. Can anyone help on this ! Content (please ensure you mask any confidential informati…
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 989 views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…Andy McIlroy 38 views 4 comments 1 point Most recent by Andy McIlroy Reporting and Analytics for ERP -
Steps to customize standard BI Report and Add ParametersContent Hello All, We have a requirement to customize standard BI Report to add parameters and modify the data model. Do we have any oracle document about this process ?…Sridhar Gupta 107 views 8 comments 0 points Most recent by Yugesh Keluskar Reporting and Analytics for ERP
-
Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI ReportI am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the sam…DeepankarGera 2 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
BIP Bursting is not delivered the emails to DLsSummary: Bursting emails from a BIP report are not delivered to any of the email ID's part of DL list, even though the Report Job History/Output & Delivery section indic…Priyanka_Ghosh 161 views 7 comments 2 points Most recent by MYNagendra Reporting and Analytics for ERP
-
How to convert WD attachment in the rtf into table formatHi everyone I want to check if there is any possibility to convert the attachment from Work definition screen into table format. Below is the attachment being printed in…Mazher Shaikh 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a query to get job board (e.g. LinkedIn, Broadbean) posting status?Summary: Is there an SQL query to get job board (e.g. LinkedIn, Broadbean) posting status for a specific job requisition? Content (please ensure you mask any confidentia…TomaszWyszomirski 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
forgetaccount utility not working for one of the userSummary: Hi All, I am trying to use forget accounts from this document and it is not working How To Run renameAccounts/forgetAccounts When User is Unable To Login to Ana…LC2502 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
Launch OIC integrations from the Oracle Cloud ERP ESS job using oAuth authenticationSummary: Is there a way to launch OIC integrations from Oracle Fusion ERP ESS job using oAuth authentication Content (please ensure you mask any confidential information…