Category 129
Discussion List
-
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 47 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
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 29 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Query to get PPR pending approver nameI need to extract data for Payment Process Request ( PPR ) with pending approver name.
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…
-
BIP Report Interactive LayoutSummary: We have developed an interactive layout in our report. We are looking to see if we can do below, How to add scroll bars to table data in the layout How to align…Nagarjuna Nudurupati 9 views 0 comments 0 points Started by Nagarjuna Nudurupati Reporting and Analytics for ERP
-
Subject area for FND Flex valuesWe have a flex set defiend with values for categories. This flex field is used as source on invoice as DFF. Payable Subject area is used to design a report and we are us… -
Can you explain the purpose of the BIPUBLISHER_V view and how the IAU_AUDITUSER column fits into itSummary: Can you explain the purpose of the BIPUBLISHER_V table and how the IAU_AUDITUSER column fits into it SELECT iau_resource , IAU_TSTZORIGINATING, IAU_INITIATOR , …KHALED IHADDADENE 110 views 3 comments 0 points Most recent by Debby P Reporting and Analytics for ERP -
Which BICC PVO Stocked Purchase Order Receipts Information?Summary: Maybe someone knows or can give a hint where to find Stocked Purchase Order Receipts Information like Receipt Date in BICC extracts. So which PVO to use for thi…Frank.Steinjan 5 views 0 comments 0 points Started by Frank.Steinjan Reporting and Analytics for ERP
-
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… -
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 26 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP
-
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …
-
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…Sravanthi0310 10 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
XDO_TEMPLATES_BSummary: I am not able to query XDO_TEMPLATES_B. Getting ORA-00942: table or view does not existhttps://docs.oracle.com/error-help/db/ora-0 Content (please ensure you ma…
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
How to monitor the following reporting and analytics field : "Enable Monitor and Audit" fieldSummary: Under reporting and analytics, under Administration, Manage Publisher, Server configuration, under Monitor and Audit section How can monitor "Enable Monitor and…
-
Which report is responsible for managing the approval notification in the application and the emailSummary: We would like to add the supplier name to the report that manages the sending of approval notifications. The goal is to display the supplier name in both the in…Varun Dhondea 24 views 2 comments 0 points Most recent by Varun Dhondea Reporting and Analytics for ERP -
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 93 views 5 comments 1 point Most recent by Nathan CCC 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…
-
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 51 views 8 comments 0 points Most recent by Ranga Swamy Ediga 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 9 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 47 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 849 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 71 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 62 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 17 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…