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
-
Attaching BI Report to OTBI DashboardSummary: Hello, I want to attach a BI report to OTBI Dashboard and connect it with dashboard's prompt. Question 1: Can I attach and view a report made from FSCM Tables (… -
FRC Report - issue in save and insert row and column template functionality in FRCWe are facing issue in using insert row and column template functionality in FRC , we are not able to transfer values from 1 report to another or 1 grid to another using…
-
BI Publisher Data Field formulasSummary: Hello Oracle folks, Maybe someone knows the solution to below: can someone help how to achieve adding two summarized data field in BIP Layout? I have 2 fields t…
-
Edit template and add new column in the existing templateHi We have an existing date model with 20 columns and all are selected in the report template. I have added one more column in the DM as per requirement but am not able …
-
How tables are joined for a View ObjectSummary: Is there any document or Oracle Cloud Application embedded method to figure out how the Database Tables are joined for a View Object? Content (required): Versio…
-
Employee Audit ReportSummary: Are there any delivered reports or custom BIP reports someone could share to help with an Employee Audit Report? I have already included the required Employee i…
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
BICC offering on specific EntitySummary: I have configured the BICC on UAT and created the offering for AP Invoice and Line. I need to know how to extract the data only for specific legal entity (we ha…
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report… -
Need to know how much longer the ESS/Scheduled jobs logs can keep in the system.Summary: Need to know how much longer the ESS/Scheduled jobs logs keep in the system. Content (required): How much longer we can pertain the logs of the ESS/Scheduled jo…
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21B
-
What will be the expression to calculate duration between two timestamps ?Summary: While Creating the Downtime Custom Page using Application Composer, a field named "Calculated Duration" is defined with data type as "Formula". So, an EL Expres…
-
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…
-
Query to fetch the Requisition job pending approval details in oracle fusionSummary: In purchase requisitions we have to prepare a bi report for the pending approval status and their job name Content (required): Version (include the version you …
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde… -
BI Cloud Connector (BICC) - Only limited columns selected by default in PVOSummary: While configuring data extract from BICCC, we notice that within a particular PVO, only limited columns are selected by default. While we can customize and sele…
-
how can we schedule the archive processhow can we schedule the archive process Content (required): how can we schedule the archive process for custom reports Version (include the version you are using, if app…
-
Moved: Need document on Localization for Israel, Switzerland and Portugal in Oracle Fusion ERPThis discussion has been moved. -
Ctreating a report for my PPM moduleDear all I am creating a report for my PPM module I just want to list the project name - task name and number - Cost and Resource I found all the above except the Resour… -
The report cannot be rendered because of an error, please contact the administrator.Summary: We have a custom report and when business user is trying to run the report below error is displayed Content (required): The report cannot be rendered because of…
-
Why the condition row value is not able to sum up as expected.Summary: We have got a requirement where either of one value is nonzero consider that value for result row. Row values are Account 400000 Department 555015,Account 40000…
-
How to wrap BI ParametersHi, I would like to have two lines for parameters instead of a single line when reports have more than 4 parameters. Is there any way to wrap or split BI report paramete…
-
Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLSummary Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLContent Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALL -
How to make MICR bold in AP checks?Summary: Couldn't make MICR bolder using the AP checks in RTF Template. Content (required): i I have tried changing the MICR tag bold in RTF template ii I have tried add… -
Why to use e-text format in BIP report when we can use default csv formatSummary: Why to use e-text format in BIP report when we can use default csv format Content (required): Why to use e-text format in BIP report when we can use default csv…
-
Ability to Search ESS- Using Report parameterSummary: There are standard or Custom Reports to be scheduled for autorun, and the output is being sent to the Printer or any other communication method. If there is a f…
-
How to View BIP Report Output in CSV Without Creating a LayoutSummary: Default the output of BIP Report to csv without having to setup a layout Content (required): In order to set the Default Format of a BIP report to csv you must …
-
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…
-
OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDContent I spent (as a newbie in OTBI) a couple of days trying to display the same column measure but with differe… -
How to access P2P OTBI Dashboards in Oracle.Summary: A user is requesting access to P2P OTBI Dashboard they saw in Oracle Learning, we don't know how to get to it. Content (required): From that user: "I’m in Oracl…