Category 129
Discussion List
-
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T… -
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…Tomoyuki Hyakutake-Oracle 61 views 4 comments 1 point Most recent by Rob Turner Reporting and Analytics for ERP -
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
https://cloudurl:443/fscmRestApi/resources/11.13.18.05/erpintegrations' failed:bad request (400)Summary: We have integration between ebs to scp cloud. we have schedule integration run on mulesoft. mulesoft site using Below one. https://cloudurl:443/fscmRestApi/reso…
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 10 views 3 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL Query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules( Supply Chain Planning → Ma…
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t…Sandeep19rm 44 views 8 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP -
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…Akhila.Allagadda 27 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…Pritam Das 29 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …NeenaS25 4 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Assistance Required for OTBI Reports in SCM (Inventory Module)Hi, We are developing a few OTBI reports for the SCM module, specifically on the inventory side. However, we are facing difficulty in identifying the correct subject are…ShubhamP 41 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …Holly Wells 1.5K views 10 comments 0 points Most recent by Neil Wanags Livingstone Reporting and Analytics for ERP
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 800 views 8 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 52 views 3 comments 0 points Most recent by NikhilYadav Reporting and Analytics for ERP -
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…VivekKandasamy-Oracle 56 views 2 comments 0 points Most recent by Akhila.Allagadda Reporting and Analytics for ERP
-
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…FlatFish534 13 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
CMK Message Processing RulesSummary: CMK Manage Message Processing Rules Description: We are working on Collaboration Messaging Framework process PO Inbound (EDI 850) to create sales order in Oracl…
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 91 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create …
-
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil…Dennis Paredes 12 views 0 comments 0 points Started by Dennis Paredes Reporting and Analytics for ERP -
Can we import data via API to be included in OTBI dashboardSummary: Is there a way to import data via an API and have this data be available on a OTBI dashboard? MJ
-
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe…
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…Daniel Martin-Oracle 3 views 2 comments 0 points Most recent by Shubhashree R Rajanna Reporting and Analytics for ERP
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…GaneshBhor 31 views 3 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
How to generate a BI Publisher URLI need to create a direct URL for the PayablesTrialBalance.xdo report in BI Publisher that will display the report with the correct parameters and formatting in the brow…
-
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI…daniel.valdovinos 18 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP