Reporting and Analytics for ERP
Discussion List
-
BIP Report Parameter - DATE & TIME - TIME ZONESummary DATE & TIME - TIME ZONEContent Good People, How to create BIP report parameter in yyyy-MM-dd'T'HH:mm:ss'Z' format and compare it with last_update_date ? Thanks, … -
Asset report with all the detailsSummary Asset report with all the detailsContent We have migrated clients assets using the asset additions spreadsheet. Data includes, asset description, categories, Ori… -
Multiple Parameter List - With 2 Column Values Concatenated (BI Publisher)Summary ORA-00909: invalid number of arguments message when executing report with multiple parms.Content It is a business requirement to have Cost Centre code and Descri…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o… -
Rtf Template : Print specific texts on specific pagesSummary Oracle Fusion BIPContent Hi All, In Oracle Fusion BI Publisher, I need to print certain texts on specific pages depends on how many pages gets printed in Custome…
-
Timezone - BIP Report schedule defaultSummary Timezone - BIP Report schedule defaultContent Hello All, When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all use… -
Listing name of purchase order attachments in a reportSummary OTBI subject areas do not provide the filenames of attached documentsContent I need to produce a report that lists the names of all the attachments for purchase …
-
Mostrar en un reporte múltiples valores de campoSummary El campo tiene múltiples comentarios, sin embargo en el reporte sólo se muestra el primero.Content Hola, Tengo un campo "notas privadas" en el cuál se almacena m…
-
XML Report RTF DesignSummary To display AP Invoice and PO details with distinct valuesContent Hi Support, I am working on a report which displays VENDOR NAME, INV_BATCH, INVOICE_NUM, PO_NUM,…
-
How to remove EDIT option from User in AnalysisSummary How to remove EDIT option from User in AnalysisContent Hi, How to remove EDIT option from User in Analysis. Thanks -
Oracle ERP Cloud in MobileSummary Access Oracle Cloud Reports in MobileContent Hello - One of our client is asking if they can leverage the Oracle cloud reports (for example ERP) in mobile? I kno…
-
BIP Report ParametersSummary BIP Report ParametersContent Hi -> BIP Report Parameters: Can we make BIP report parameters in the required order if there are more parameters. Ex: I have 20 par…
-
BPM - capture comments in a ReportSummary BPM - capture comments in a ReportContent Hello All, We have a requirement to build the report to fetch all the invoices where Approvers either Rejected or Reque…
-
Oracle Fusion Financial Standard ReportsSummary Oracle Fusion Financial Standard ReportsContent Hi where can I get the list of oracle standard reports and How can I make Job Group (request groups as in EBS) an…
-
CSV output Date FormatSummary CSV output Date FormatContent Hello all, I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have crea…
-
OTBI questionsSummary Custom style and OTBI presentation/session variablesContent Hi all, I hope someone can help me with my below questions, regarding OTBI. in Oracle Fusion ERP Clou…
-
Table of Contents formattingSummary How to format the Table of Contents within the BIP templateContent Hi All I am working on the Negotiation Layout which is being customised for the production of … -
Unable to find invoice validation status through BIP sqlSummary Unable to find invoice validation status through BIP sqlContent We are not bale find invoice validation status through BIP sql by using AP_INVOICE_ALL. Will be a… -
Bursting : Split Files by Number of RecordsContent Good People, How can we split files based on number of records in BI ? e.g. Say the extract is having 700 records , I want it to be split into 4 files , 3 of 200…
-
Date an Invoice is Accounted (Posted to the GL)Summary Date an Invoice is Accounted (Posted to the GL)Content I need to build a BI Publisher report for accounted invoices that includes the date an invoice was account…
-
Payment Process Request tablesSummary PPR details stored tablesContent hello Folks, My requirement is like display/report PPR details contains invoice,supplier,payment details. Please let me know whi…
-
Obtain user's timezone from preferencesSummary Obtain user's timezone from preferences for BIP reportContent We have a BIP report which needs to display datetime values based on user's location (timezone). We…
-
General Ledger - Journals Real Time Subject Area OTBI Analysis Posting Date shows next daySummary General Ledger - Journals Real Time Subject Area OTBI Analysis Posting Date shows next dayContent Hello All, General Ledger - Journals Real Time Subject Area OTB…
-
FRC synch timeSummary FR Studio Reports don't appear in FRC immediatelyContent When we create new Financial Reports using FRS, they do not appear in FRC right away. It seems there is …
-
BI Publisher Report printing in PCL PrinterSummary PCL PrinterContent Good People, How to use BIP to print documents in PCL Printer ? I mean how to convert PDF to PCL in BIP ? or Generate the PCL output using BIP…
-
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou… -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and …
-
How to show PO Number from Lines PageSummary How to show PO Number from Lines Page -- rtf templateContent Hi All, We have an custom requirement of printing Purchase Order Number from PO lines pages from eve…
-
Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Summary Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Content p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helveti…
-
TODATE Function not working in 'Budgetary Control - Balances Real Time')Summary TODATE Function not working as expected in mentioned SAContent When using the TODATE() Function in Subject Area 'Budgetary Control - Balances Real Time' an error…