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
-
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F… -
Oracle Fusion SaaS Cloud Application ManagementSummary: Looking for pre-built dashboards to monitor your entire SaaS Application like Content (required): Hi Team, We are looking for pre-built dashboards to monitor yo…
-
Oracle Fusion SaaS Cloud Application ManagementSummary: Looking for pre-built dashboards to monitor your entire SaaS Application like Content (required): Hi Team, We are looking for pre-built dashboards to monitor yo…
-
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…
-
What are the differences between Enterprise Set and Common Set?Summary: What are the differences between Enterprise Set and Common Set? Content (required): What are the differences between Enterprise Set and Common Set? Version (inc…
-
Track setup change report/analysis in OTBISummary: Track setup change report/analysis in OTBI Content (required): I'm looking for a report or to create an analysis in OTBI to track setup change. Who and When Sco… -
Select All columns from multiple tablesHi All, How to select all columns from multiple tables in the BI Data model. select a.*, b.* from table1 a,table2 b I cannot execute above sql statement when both the ta…
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
Printer Related queries raised by CustomerSummary: This print server will be configured in Oracle SaaS fusion to print the labels and invoices from BI and ESS jobs Content (required): - Does Oracle monitor the e…
-
RWS vs SmartviewSummary: Hi All, Can anyone provide insight on when should we use RWS and when to use Smartview. Dimensions are same in both methods. Please help me with pros and cons o…
-
Moved: Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL ta…This discussion has been moved. -
Invoice Line level Subject Area in FAW OACSummary: Hello, We need to create a Invoice line level report in FAW OAC, but do not find ant relevant Subject area in ERP Financials. Content (required): the Prebuilt A…
-
Scheduled OTBI report isn't showing all rowsSummary Scheduled OTBI is truncated when exported as a CSV fileContent Hi All, I have several OTBI reports which I have scheduled to be run each morning and delivered in… -
ESS jobs submittedSummary: Is there any limitations on the number of jobs that can be submitted to run in parallel? Can we set the limit on the number of jobs that we want to run in paral…
-
What table(s) contain 'Invoice Method' and 'Revenue Method'?Hi, I'm trying to find what tables/views contain the following fields for: 'Invoice Method' - Cash basis, cost reimbursement, event-based, milestone, proportional perfor…
-
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w…
-
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
Where to find employee W2 Box 1 and Box 5 Data?Summary: I have a report request for employee's W2 box 1 and box 5 values. Content (required): W2 Data in Oracle Fusion HCM Version (include the version you are using, i…
-
Job Set ParameterSummary: I have seeded ESS Job and I want to make a ESS Job set that assign value to the seeded ESS Job. Is there a way I can achive that? Content (required): There is a…
-
Assign custom role to OTBI reportHi, I have to assign custom role to custom OTBI report and I was trying to assign a role to OTBI report but custom roles are not showing in the LOV. Any suggestions?
-
How to change the "subject line" or "from address" details for Accounting Automation emailsSummary: Content (required): We have enabled GL accounting automation process in all our PODs. The issue we are facing is, all the emails from all the PODs are coming wi…
-
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…
-
How the performance will be affected if multiple user run a BIP report at the same time?Summary: How the performance will be affected if multiple user run a BIP report at the same time? Content (required): If multiple users run the same BIP report at the sa…
-
Can we submit a BIP Report as Job from UI using a linkSummary Can we create a link or button in ERP which submit a BIP Report as Job uplon click/press ? Content (required): Version (include the version you are using, if app… -
Question on Approval Groups ReportSummary: - How is a delegation visible in the system – will it show on that approval group report? Will it be indicated whether a member of the group was delegated vs co… -
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an…
-
Query to get salesrep assigned to the customer accountSummary: Hi, I am looking for the tables/query to get the salesrep number and name attached to the customer account in Oracle Fusion Cloud. Content (required): Version (…
-
Unable to edit Data Model post Deployment using Oracle SOAP ServicesSummary: Unable to edit Data Model post Deployment using Oracle SOAP Services. Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dll?SoapImpl=…
-
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…