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
-
Can we create an OTBI report with smartform informations ?Summary: Hello, We have custom smartform with custom DFF's. We would like to create an OTBI report that contains the requisition with theire smartform informations. Is t… -
Need to find Parameter details which is used while running report in Audit TablesHi Team, I am trying to build an audit report for BI Reports but I am unable to get the column for parameters in the audit tables. Can you please confirm if this is stor…Shubham Khandelwal - Accenture 47 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle
-
Is there functionality like HCM AOR on the ERP side?Summary: Is there functionality like HCM AOR on the ERP side? Content (please ensure you mask any confidential information): Version (include the version you are using, …
-
How to generate XML Positive Pay File in COS payments formatSummary HSBC bank needs XML Positive Pay File in COS payments formatContent ERP Cloud customer is engaging with HSBC for payment processing. Customer will continue to pr… -
Moved: secure flexfield by role on Purchase requisition lineThis discussion has been moved. -
Issues running csv reports after 24A updateSummary: After 24A update, reports built using analysis can't be run, created, or edited. Workaround is to create new data set based uopn the SQL from original analysis,…
-
Need a Solution to restrict Parameters with respect to a Date RangeSummary: In the specified business scenario, users are restricted from selecting dates in the "GL Journal Date From" parameter between the 1st day of the month at 12:00 …
-
-
-
What is 'page join'?Summary: Recently one of our team members attended CloudWorld and came back noting we could 'page join' EPM and ERP. Does this sound familiar and, if so, how can we acco… -
Pros/Cons of creating an ESS job for a custom bi report versus not create a ESS job?Hi Community, Are there any advantages or disadvantages for creating an ESS job for a newly created custom bi report versus not creating a ESS job for it? -
-
Is there a way to identify deleted journals so that we can exclude them from reporting?Summary: Is there a way to identify deleted journal entries so that we can exclude them from reporting? Content (please ensure you mask any confidential information): We… -
Financial Reporting Web Studio from FRC WorkspaceSummary Financial Reporting Web Studio from FRC WorkspaceContent Hi, I don't see the option to Launch Financial Reporting Web Studio from the Financial Reporting Center … -
List for all OTBI subject areas/dimensions (as of 23C)Summary: Does anyone have a complete list of all OTBI subject areas/dimensions for creating ad hoc queries? Content (required): Version (include the version you are usin… -
How to hide compatibility checker in Excel while opening excel template based outputs in Fusion?Users are complaining for showing the below message while opening the excel report outputs.How to hide this?
-
How to download and upload Catalog files along with the role permissions using APISummary: We are currently using the SOAP APIs (/xmlpserver/services/ExternalReportWSSService?WSDL) and (/xmlpserver/services/v2/CatalogService?WSDL) to download and uplo…
-
unable to get data for the following fields(Quote Price,RFQ Number,Line Awarded,Lines responded) ?Hi ALL, We have a requirement for the fields(Quote Price,RFQ Number,Line Awarded,Lines responded) in OTBI report. we tried with the following subject area but no date is…
-
Pass BI Results to OTBI Analysis(please ensure you mask any confidential information): Is it possible to pass BI report results to an OTBI dashboard prompt and bind that to an OTBI Analysis column if t…
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi…
-
Moved: Difference between Ess Job Derived attributes and AttributesThis discussion has been moved.
-
BICCSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…
-
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…
-
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to Join Multiple Subject Area in OTBISummary: Hi All, Need suggestion on OTBI report. Content (please ensure you mask any confidential information): We have requirement to build an OTBI report to show trans…
-
How to find the BI reports that are using Excel TemplateHi, Referring to Doc ID 2990643.1, the BI reports that are using Excel Template are getting the corrupted output while scheduling it. Could anyone please let me know is …
-
Is there a way to create a deep link from OAC into the invoice attachments in ERP?We've created a dashboard in OAC for invoice details. Users are able to click a deep link in that dashboard that will open an invoice in ERP. They are then able to click…
-
OTBI END USER are not able to see the promtSummary: I have a requisition report and I create a prompt for a Supplier Field. When I open the report in the Report and Analytics are and select the Open link the syst…
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…