To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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 …
-
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… -
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… -
Invoice Line Level Account Combination (Distribution) ReportSummary Invoice Line Level Account Combination (Distribution) ReportContent Can someone tell me what Subject Area and specific Subject in Reports and Analytics should be…
-
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…
-
How to add OTBI report parameter to filter out those zero outstanding balance and date in range?Summary Add report parameters to filter those zero outstanidng balance and date in rangeContent hi all, I have two OTBI report parameters would like to add: 1) In the Su…
-
Drill Down using Invoice NumberContent Hi, I have created analytical report which has Ledger Name, Supplier Name and Invoice Number When the invoice number is clicked i would like to drill down to tra… -
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… -
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… -
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… -
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… -
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 …
-
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…
-
Couldn't Integrate a OTBI report including Project details and Project Contract DetailsSummary Can i Create an OTBI Report combining Project Details and Project Contract DetailsContent When i create new OTBI report add in it Projects details from subject a… -
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…
-
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…
-
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…
-
Payables positive pay fileSummary Rename positive pay file nameContent Hello Guys, Can someone help on the below requirement, We have to send positive pay file to external server and with specifi…
-
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… -
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…
-
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…
-
Report on email approvalSummary How to obtain email approval information?Content We have a requirement to analyse our Fusion user population and check who have/have not logged into the system r…
-
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…
-
Fusion User Roles&Responsibilites Add/RemoveSummary Custom BI Report to capture the user roles&reponsibilitesContent Guys, Can someone help with below requirement, We have to capture what are all the roles added t…
-
Did not receive (BCC) email in schedule processContent Dear , I run report in oracle fusion Tools > Scheduled Process > Scheduled New Process > select (PRG it is my report name) > A process details window open in whi…
-
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…