Category 385
Discussion List
-
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 18 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 80 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…
-
Receivables - Transaction Real Time to Receivables - Standard Receipts Application Details Real TimeHi. We are tying to get this subject are (Receivables - Transaction Real Time TO Receivables - Standard Receipts Application Details Real Time), however data is not show…Krishna Kishore 9 views 0 comments 0 points Started by Krishna Kishore Reporting and Analytics for ERP
-
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 16 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 40 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 23 views 3 comments 0 points Most recent by Mark Di Ponio Reporting & Analytics for Fusion Service
-
Account Analysis Drill down -Subledger-Real TimeSummary: The requirement is to have all the transactions (Invoices/Credit Memo's) listed in tabular form once we click on particular balance sheet account for the period…Kinjal Patel-Oracle 11 views 1 comment 2 points Most recent by Rashmitkumar Dodiya-Oracle 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 34 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 21 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Help Needed: REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM DemoI am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…srikanth gollapally 11 views 0 comments 0 points Started by srikanth gollapally Reporting and Analytics for ERP
-
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 20 views 4 comments 0 points Most recent by Selva.N Payroll and Global Payroll Interface (GPI)
-
FDI is not accessible for some users only in some locations due to sign-on policy accessSome users that were supposed to have access to FDI cannot access the tool any more ( only for some locations) they still access our HRIS using their addresses IP but no…Ayoub Afrass_1 12 views 2 comments 0 points Most recent by Ayoub Afrass_1 Fusion Applications Administration -
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 26 views 5 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
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…
-
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 17 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. -
Customizing Data Model for GL and Subledger Account Analysis Report – Add/Remove ColumnsHi Everyone, Has anyone customized the data model for the General Ledger and Subledger Account Analysis Report in Oracle Cloud ERP? I'm looking to add new columns and po…Pratiksha Sawandkar 21 views 0 comments 0 points Started by Pratiksha Sawandkar Reporting and Analytics for ERP
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…Shikha Charadva 38 views 4 comments 0 points Most recent by Saptadip Datta DXB Reporting & Analytics for Fusion Service
-
Does BICC query returns live data?Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source? select distinct TransactionEntitySour…SHAHRAM SALAMI 7 views 0 comments 0 points Started by SHAHRAM SALAMI Reporting and Analytics for ERP
-
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…Karthikeyan s-Oracle 47 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Rest API/SOAP API to check if particular folder exists on analytics catalogHi Team, I am searching for API to check 1.if a particular folder exists on particular path 2.to upload/replace a folder in BIP Please help me out if there are any?Aditi Agrawal2650 3 views 0 comments 0 points Started by Aditi Agrawal2650 Reporting and Analytics for ERP
-
Need to fetch user preferred date format for excel templatesDescription: We need to incorporate the user-preferred date format in Excel reports. Please refer to the attached screenshot of the UI from which the date format needs t…
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …Nithin Nannuri 12 views 0 comments 0 points Started by Nithin Nannuri Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Nannuri 19 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
Need API or Scheduled Process to Submit "Request Time Change" Regularizations in Oracle Fusion HCMWe are currently using the Oracle HCM REST API (/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests) to create time change regularizations for employees. While the…