Category 129
Discussion List
-
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 750 views 6 comments 1 point Most recent by Florin Loghin-Oracle 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 8 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 57.2K views 140 comments 31 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
Looking for report that list active and inactive responsibilies of a userSummary: My client needs to be able to extract current and historical responsibilites of a user in order to verify that compliance rules has been followed. So far I've o…
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single RowRama Mohan ReddyB 22 views 3 comments 0 points Most recent by Pradnya Bhosale Reporting and Analytics for ERP
-
How to debug BIP report that has dataset based on Procedure as a SQL type?Summary: I have an issue with a BIP report that use a complex plsql code as a dataset. I am looking for suggestion to debug procedure used in dataset. The data set confi…Vijayaragavan Ramasamy 4 views 0 comments 0 points Started by Vijayaragavan Ramasamy Reporting and Analytics for ERP
-
RSUM Not working for running cost totalHi, I tried using the RSUM function to get a running total of the project actual costs (Actuals column). However, that function is not working as I expected in the last …Julia Looi 48 views 4 comments 0 points Most recent by Chaunae Walton Reporting and Analytics for ERP -
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" is returning blankSummary: Has anyone get to the bottom of this, I am trying to bring back "Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" But it is coming black as blan…
-
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. …
-
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 366 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 79 views 5 comments 0 points Most recent by Nermin Khaled-Oracle Reporting and Analytics for ERP -
-
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver…Krishna Manmohan 6 views 1 comment 0 points Most recent by Krishna Manmohan Reporting and Analytics for ERP -
FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud FusionHi all, I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are usi…Arthur Teodoro 12 views 3 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…
-
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 2.8K views 77 comments 9 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Scheduling BIP report is failingI have a BIP report which has bursting enabled. The underlying data model has 2 datasets- 1 is of type HTTP (XML feed) and 2nd is of type SQL query. HTTP dataset calls a…Neha Aishwarya 21 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
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…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
link to data set parameterSummary: Working with BI Publisher I have 5 different data sets. There is the header query and then there are children queries which are all linked, one of which has a t…
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…Anne Cilia 42 views 3 comments 0 points Most recent by Gopikrishna-Oracle Reporting and Analytics for ERP