BI Publisher
Discussion List
-
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View… -
Best Practices for OTBI Reports Handling Large Data VolumesSummary: Hi everyone, I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data. Is there a recommended st… -
BIP report only bursting to default printerHi Team, I have bursting logic in my BIP report to burst the output to different printers based on a lookup. If the selected printer is set as default printer in Adminin…
-
Data Roles and Security Profiles - Unable to find 'STATUS' column for BI reportsHello, I’m currently working on a report related to Data Roles, and I was wondering if anyone here has worked on something similar or knows which table/column stores the…
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.9K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Not able to create a PO adding Header level DFF and line level DFF in that single payloadAble to create a PO in a single payload having headers, lines, schedules and distributions. However not able to create a PO adding Header level DFF and line level DFF in…
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 261 views 16 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP
-
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?Summary: Hello, I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the templa…Frank.Steinjan 57 views 6 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 31 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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 400 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 45 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 32 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 3 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 12 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…