BI Publisher
Discussion List
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…Mukund Kudrimoti-144443 27 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…Mukund Kudrimoti-144443 36 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Process name not filled for bip job in 'scheduled processes'Summary Process name not filled for bip job report in 'scheduled processes'Content Hello, When we schedule bip report (manually or via web services), a process is execut…Médéric Chauvin 330 views 3 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, RinkuRinku Gautam 287 views 5 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Summary How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Content Can anyone guide us on how to generate and view the DB trace fi…Umamaheswara Reddy Karri 77 views 5 comments 2 points Most recent by Hannah Dorman Reporting and Analytics for ERP
-
Non - standard SQL data model bind to different templatesSummary Non - standard SQL data model bind to different templatesContent Hi there I was wondering if it was possible to bind a non-standard SQL query parameter to a Repo…User_2025-02-05-10-38-08-223 24 views 3 comments 0 points Most recent by User_2025-02-05-10-38-08-223 Reporting and Analytics for ERP
-
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Custom Groups in BIPSummary Need to create custom grouping of Accounts in BIPContent Hello - I have a requirement to show selected account attribute values from Account dimension in an expe…Hari Thyagaraj 42 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for ERP
-
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…Mohamed Mahmoud-157904 82 views 9 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…Avesh Ganodwala-57885 224 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
BI Publisher : Setup Data Source and extract data from itContent Hi, In BI Publisher, I am looking to setup a new data source to extract specific business unit related from it in the data model. Also, Out of all the data sourc…Rinku Gautam 55 views 3 comments 0 points Most recent by Milind Dalvi Reporting and Analytics for ERP
-
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…User_2025-01-22-19-25-44-650 64 views 3 comments 0 points Most recent by User_2025-02-05-11-38-57-253 Reporting and Analytics for ERP
-
View future scheduled ESS jobs in SaaSSummary We have a requirement to extract the future scheduled jobs for a user.Content Test Case: Admin wants to know what are the future jobs scheduled for a user. In ca…Sumanth Kunimakki-21932 78 views 4 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
MOAC in BIP ReportsSummary Implementing MOAC in BIP ReportsContent Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been abl…
-
BIP Report ParamtersSummary BIP Output via ScheduleContent Hello - I scheduled a BIP report and the export output shows the parameters as columns in the excel file. The requirement is such …Hari Thyagaraj 57 views 3 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Bi Reports Does not Show LOV CorrectlyContent Dear , I created a user defined lov in (Manage List of Values Sources) and then defined into my reports . Reports run correctly with lov but issue is lov filed i…User_2025-02-04-12-49-58-154 29 views 11 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Inventory List of Stored ProceduresSummary Looking for documentation on delivered stored proceduresContent Where can I find more information about the stored procedures that can be called from BI Publishe…Meredith Bickell 40 views 2 comments 0 points Most recent by Mark_Daynes Reporting and Analytics for ERP
-
Sub ledger Account table - Data VisibilitySummary Sub ledger Account tabl: Data Visibility for XLA_TRANSACTION_ENTITIES table.Content We are trying to build a BI Publisher report for extracting data for Sub ledg…Senthilrajan V 92 views 4 comments 1 point Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Database table details for content stored in UCMSummary Need to extrat details of UCM content in BIPContent Hi Experts , UCM contents has some properties like comments, owner , account , security group etc. Do we have…Manish Pesswani 55 views 3 comments 2 points Most recent by MadhuVitta Reporting and Analytics for ERP
-
Parameters Appear Under Data_DS in CSV FormatSummary How to remove the Parameters appearing as fields in CSVContent Hi, We are currently working in a report and the data model is bringing through the fields require…User_2025-02-03-21-40-10-404 51 views 9 comments 2 points Most recent by Wendy Ware Reporting and Analytics for ERP
-
What is the best option for incremental extracts in Procurement Cloud 19aSummary What is the best option for incremental extracts in Procurement Cloud 19aContent We have a requirement to extract PO information on the basis of an incremental u…Umamaheswara Reddy Karri 56 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
BIP ParametersSummary Add parameter details to report at exportContent I have a requirement to show parameters while exporting a BIP report. When I export the report in an excel I do …Hari Thyagaraj 47 views 4 comments 0 points Most recent by MadhuVitta Reporting and Analytics for ERP
-
Remove first blank page of BIP report having rtf templateContent Hi, In a rtf template linked to Customer invoice in Fusion Cloud, I am having 2 IF loops inside which, are sections breaks (continuous & next page). It works fin…
-
How to add Legal Entity Parameter to oracle standard report "Collections Aging by Collector 7 BucketSummary We have a Requirement to add Legal Entity Parameter to existing Standard Report.Content Hi All, We have a Requirement to add Legal Entity Parameter to existing S…User_1B10X 68 views 1 comment 1 point Most recent by User_2025-02-03-21-40-10-404 Reporting and Analytics for ERP
-
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…User_2025-02-05-04-43-06-903 92 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
Fixed Asset Book Comparison ReportSummary Is there is a fixed asset report that will compare asset detail across different books?Content We need a report that will compare asset detail across different b…User_2025-02-05-01-44-13-448 50 views 2 comments 0 points Most recent by User_2025-02-05-01-44-13-448 Reporting and Analytics for ERP
-
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho…AnsumanM 40 views 5 comments 2 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Deep Link to open Payment info in view mode?Summary Deep Link to open Payment info in view mode?Content Hi, The deep links page in Fusion cloud show the following for the link to the payment https://.oraclecloud.c…Michelle Haynes 580 views 2 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Data restriction on Data Model in Fusion CloudContent Hi, I am trying to restrict data to users having privilege to create Data Model wrt business unit e.g: There are 2 business units BU_1 and BU_2. If a user logs i…Rinku Gautam 68 views 6 comments 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP
-
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, …Soumya Prakash Parhi 170 views 1 comment 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP