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
-
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L… -
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m… -
"HRC_TXN_TAC_HISTORY" - Audit report for corrections to transactionsSummary: We have enabled the editing function within the Transaction Console. Users can now adjust the transactions to make corrections while not yet approved. Is there …
-
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…
-
BI Publisher Bursting Email Sent Even When Report Has No DataHi Oracle Support, Bursting emails are being sent even when the report output is empty. How can we prevent emails from being sent when there is no data? -
how to update CLOB Column of Custom Object from OIC IntegrationHi, We have a Custom Object and we have create a field with Data Type "Long Text". We are not able to update the value in this field using REST API. We are using below U…
-
FRS Reports erroring out intermittentlySummary: FRS Reports erroring out intermittently Content (please ensure you mask any confidential information):These are the errors received trying to run the Fin report… -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…
-
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
Email Oracle seeded ESS Job:Import Costs: Generate Output Report outputSummary: We have requirement to email output of 'Import Costs: Generate Output Report'. We find it challenging as this is child job for 'Import Costs' . This report 'Imp…
-
Suppliers with Duplicate Taxpayer ID Report not Available to RunSummary: No capability to open or schedule the Suppliers with Duplicate Taxpayer ID Report Content (please ensure you mask any confidential information): Our business us…
-
BI Publisher PCL Printing Issue: Layout Output Appears Scaled DownI would like to ask for your advice regarding the output of a BI Publisher printing. When we register the printer in the ERP and issue the print job using PDF to PCL fil…
-
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…
-
How Purge Interface Tables Program selects submitted by user?Summary: How Purge Interface tables select the user to schedule maintenance Purge with following arguments? Argument1 =1111 Argument6 = ORA_MAINTAIN Argument7 = SYSTEM A…
-
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…
-
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…
-
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…
-
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 , … -
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…
-
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…
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…
-
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…
-
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…
-
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…