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
-
eText Templates seeded sample templatesHi , From where can we download some of the seeded eText Templates used in Oracle for payment formats. Can anyone please share the exact path in the BI catalog. Thanks V… -
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 (…
-
Moved: FRC Report - issue in save and insert row and column template functionality in FRCThis discussion has been moved. -
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…
-
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…
-
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 …
-
saas fusion data retention polity - access to transactional dataSummary what is the period users are able to access transactional data (10 yrs?)Content For Fusion financials, users would like to be able to access transactional data f…
-
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… -
Understanding generic user 'FAWService' in Oracle fusion cloud ERPSummary: Could you please help us understand the generic user 'FAWService' in Oracle fusion erp. We can see this user while querying the table per_users which has user c…
-
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 …
-
ESS base cubes Vs RDMBSSummary: I am getting confused here when we say cubes and RDMS in Cloud. Content (required): I had a debate with one of my peers where he said that there is only cubes a…
-
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…