Category 129
Discussion List
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo… -
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 103 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create … -
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil…Dennis Paredes 19 views 0 comments 0 points Started by Dennis Paredes Reporting and Analytics for ERP -
Can we import data via API to be included in OTBI dashboardSummary: Is there a way to import data via an API and have this data be available on a OTBI dashboard? MJ
-
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe…
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…Daniel Martin-Oracle 5 views 2 comments 0 points Most recent by Shubhashree R Rajanna Reporting and Analytics for ERP
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…GaneshBhor 40 views 3 comments 0 points Most recent by Malleswara_Rao_P 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 28 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 58.1K views 140 comments 33 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 34 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 11 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 55 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…
-
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 382 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 118 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 7 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 16 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…
-
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 26 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP