Reporting and Analytics
Discussion List
-
Bursting Feasibility for BIP Report having Multiple Data ModelsDear Team, We have one requirement wherein we need to enable bursting for one report having multiple data models, kindly confirm if that can be achieved. If yes, then pl…Sagnik_Das 2 views 0 comments 0 points Started by Sagnik_Das Reporting & Analytics for Fusion Service -
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and…Brian Burns 7 views 2 comments 0 points Most recent by Mustafa Abu Dayeh Reporting and Analytics for ERP -
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…Sridher 185 views 10 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for ERP
-
Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…
-
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 16 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…Rajendra.12 17 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…Ramsha Zameer 12 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …
-
Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.Hemanth Buccapatnam Tirumala 26 views 4 comments 1 point Most recent by Diksha0912 Reporting & Analytics for Fusion Service
-
Support for bank's latest ciphers -newSummary: We received below notification from bank side for the security guidelines related to payment file transfer from Oracle fusion to bank (SFTP) We've detected that…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 16 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 31 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
Supplier Address –Phone/Email Audit Tables/History Data (Old Values) in Fusion stores in which tableHi Team, Could you please help me with the below? I am trying to identify which Oracle Fusion table stores the audit/history data (old values) for Supplier Phone, and Em…
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 28 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 92 views 6 comments 0 points Most recent by Suneha .-Oracle Reporting and Analytics for HCM -
How to set comma as decimal separator in RTF Template in BIP Reports ORacle FusionI have a requirement to show the EUR format amount i.e. €1.234,00 in output of RTF template other than setting it at User Preference. I have already tried the EUR format…
-
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…srikanth gollapally 18 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…Grant Abbondanza 42 views 4 comments 3 points Most recent by Grant Abbondanza BI Publisher Learning Center
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI…JDC 30 views 3 comments 0 points Most recent by Mark Di Ponio Reporting & Analytics for Fusion Service
-
PO PDF templateWe have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amount…Kinjal Patel-Oracle 36 views 2 comments 2 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
Unable to update headcount as 1 for few employees using HDLHi, We are using HDL for updating the headcount of 48K+ records and have successfully updated for most of them however for 5 records we are getting error as "More than 1…Kapil 25 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Can we club multiple elements into one single line so that the payslip generated is not very long?We have a requirement where in we want the multiple elements (elements and their retros) to get clubbed in one single line along with their contributions summed up too. …Kanak Maheshwari 22 views 4 comments 0 points Most recent by Selva.N Payroll and Global Payroll Interface (GPI)
-
Is there any table that stores user categories and password policy in fusion ERP?Hi, Can I create a BI report where I would be able to fetch the User Categories and Password Policy details in Oracle Fusion. Regards, JahnaviJahnavi Konduru 39 views 5 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
Issue with Bursting Setup in Print Receivable Transactions – Job Stuck in RetryingHi team, We have a requirement to customize the Import Print Template. As part of this customization, we have updated the template and modified the existing data sets to…AatifSiddiqui 26 views 1 comment 0 points Most recent by Jeetendra Achary-Oracle Receivables & Collections
-
How to remove username as the report owner in the BI Publisher reports.Currently user ABC is owner of /shared folders/custom so most of the content under /shared folders/custom showing ABC as owner. How to remove ABC name as the report owne…Saikumar Konduru 31 views 0 comments 0 points Started by Saikumar Konduru Reporting and Analytics for ERP
-
Does anyone have a BI report query available that extracts data in the 834 ANSI HIPAA format?With template it would be nice to have.