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 modify Asset Cost Summary ReportSummary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Sum… -
Roadmap Features ListSummary: Roadmap Features List Content (required): Hi , Is there any page where we can see roadmap of upcoming features till next 2 or 3 releases. One of my customer is … -
Oracle Fusion the seeded report "Receivables Aging by General Ledger Account Report" custom steps ?Summary: Seeded Report name - "Receivables Aging by General Ledger Account Report" custom steps ? How to use the Report parameters used in this scheduled report in some …
-
OTBI legal entity of AP invoiceSummary: Content (required): We want invoice header LE information in the report but as soon as we are adding payment details it starts showing payment LE information. S…
-
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you… -
Is there a setting in BICC so that data store extracts handle special characters correctly?Summary: We are finding that special characters are not being exported correctly in our data store extracts. Is there something we can do to export the characters correc…
-
Data missing in outbound integrationSummary: Data missing in outbound integration Content (required): Hi Experts, We implemented GL Journals outbound integration between fusion and AWS SFTP server. We have…
-
Is it possible to hide a graph prompt?Summary: I have a requirement to hide a graph prompt, because the graph is being updated by clicking in another table as a master-detail event. Content (required): It se… -
How to access the sample XML for the Printable Expense Report Template?Summary: I need to customise the Printed Expense Report Template to suit client's requirements. I understand that the seeded report does not have an associated Data Mode… -
Can you please share with me Workflow/BPM tables in Fusion? Are there workflow/BPM tables for Cash AContent Can you please share with me Workflow/BPM tables for Cash Advances in Fusion? Following I found in Procurement 1.POR_AMX_RULES2.POR_AMX_PARTICIPANTS3.POR_AMX_DIM…
-
Sequence Command for BI PUblisher eTextSummary: Sequence Command for BI PUblisher eText Content (required): Hi Folks, I'm using eText template to do payments, I need a unique id for each payment but for each …
-
How many columns we can have in data modelSummary: Maximum number of columns we can have in data model Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…
-
Recommended way for an external system to extract data in bulk from Oracle Fusion ERPSummary: I'd like to understand the recommended way for an external system to extract data in bulk from Oracle Fusion? Content (required): I understand the various ways …
-
Failing to retrieve data from presentation layer when trying to export BIP folderSummary: Our team is using the VBS pipeline to export BIP reports from the dev region to the sat region. Everything was working correctly and then it stopped working on …
-
How do I remove grouping of grouped columns?Summary: I have created a report with a subject area and it has worked fine... For some reason, it's suddenly decided to group almost all my chosen columns and I simply …
-
Customize seeded report "Award Approval Notification Report"Summary: We need to customize this seeded report "Award Approval Notification Report". We have made the changes as per the process but the Award approval notification is… -
Pass parameters from excel to BI Publisher reportSummary Pass parameters from excel to BI Publisher reportContent Hi, I run BI publisher report directly from excel by using soap and it works ok as long as i don't use a… -
Report gives an errorI created a excel template report which data model is working fine but when i run the report which is excel template its give me an error Error The report cannot be rend… -
Audit Report for OTBI Reports Metadata ChangesSummary Audit Report for OTBI Reports Metadata ChangesContent Hi Gurus, It is year end Audit time and we need some information on the changes made to "Key Reports" durin… -
Unable to get parameter values using ExternalReportWSSService - getReportDefinitionSummary: Content (required): Using the below WSDL and Operation: WSDL: https://xxxxxxx.xx.****.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSService?WSDL Oper…
-
How to create Report Filter that only provides results based upon Current DateSummary: I have a BI report with I need to retrieve all transaction created on current date Content (required): Report is BI Publisher Report based upon Receivables Tran…
-
RTF Template - To Display Total Amount in last row of the pageSummary: Hi All, We have requirement to display Total Amount only in the last row of the last page, even if the report data ends middle of the page Total should be displ…
-
How to add standard report icon in springboardSummary: I have a requirement to add icon of a standard BIP report in springboard. I am using static URL to create page entry. We cannot open a standard BIP report from …
-
How can I display a CLOB column value in a Data Model created from Oracle BI EE data source?Summary: Unable to display a CLOB column value in a Data Model created from Oracle BI EE data source Content (required): I have created a data model from a OTBI subject … -
How to Pass Parameter value Of All in REST APIWe use REST API to call BIPublisher report - we are able to pass specific values in the parameters however if the report parameter has a Value of All (aba.batch_name in … -
How to get list of all the reports that are run in the last 3 monthsSummary: Is there a way to get list of all the reports that are run in the last 3 months in Oracle Fusion(Not just ESS Jobs but also run directly in catalog). Content (r…
-
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…
-
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…
-
How do I implement custom barcode fontSummary: We have a requirement to print barcodes in BC3of9 and Code128 fonts. We implemented using the delivered Oracle-supported fonts. However, the client tested and s…
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…