Analytics
Discussion List
-
Case Management/HR Helpdesk delivered OTBI reports not openingHi Everyone, I am facing issue accessing the delivered case management OTBI analyses that is found under Shared Folders > Service > Embedded Content > all Help Desk subj… -
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… -
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… -
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 43 views 4 comments 3 points Most recent by Grant Abbondanza BI Publisher Learning Center -
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 31 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 35 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 21 views 4 comments 0 points Most recent by Selva.N Payroll and Global Payroll Interface (GPI) -
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. -
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 1 view 0 comments 0 points Started by Aditi Agrawal2650 Reporting and Analytics for ERP -
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… -
criblSummary: We would like to integrate the OCI Logs to Cribl Content (please ensure you mask any confidential information): To stream the logs Version (include the version … -
Direct and Indirect Reports OTBI data using HR Help Desk Subject AreaWe are creating an OTBI analysis using the "HR Help Desk Service Requests Real Time" Subject Area. When a line manager accesses the report, it does not automatically fil… -
Error when trying to create a custom model of type KEY_VALUE_EXTRACTION in OCI Document UnderstandinSummary: Once data labeling has been successfully completed in Label Studio following the instructions in the Label Studio documentation, a custom model is created in th… -
We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet.Summary: We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet. CMP_RANGE_DIFF_VALUES_F CMP_RANGE_DIFFS_F_TL Can you please help me …Janardhana Kondaveeti 11 views 0 comments 0 points Started by Janardhana Kondaveeti Reporting and Analytics for HCM -
Oracle fusion FDI in data actions How to provide the authentication for REST APII'm trying to get the invoice attchemnt url in FDI using data actions type HTTP API by call the REST API. but facing an issue to authenticate the REST API. We have enabl… -
Clarification on Delivery Status Storage in Receivables – AR_BPA_DELIVERY_DETAILS Table BehaviorWe are currently investigating where the delivery status is stored in Oracle Receivables. During our analysis, we identified the table AR_BPA_DELIVERY_DETAILS as a poten… -
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
Need the joining for legal entity and fiscal classification in manage party tax profilesHi Team, Need the joining for legal entity and fiscal classification in manage party tax profiles.As shown in below screenshot I am creating a query for Legal Entity, Fi… -
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464… -
Feasibility of Using PDF with Embedded Tags Instead of RTF TemplateCan we modify the PDF document to include tags/tokens such as P_SIGNER within the PDF itself and upload it in place of the existing RTF templateAprajita Gokhale 1 view 0 comments 0 points Started by Aprajita Gokhale Reporting and Analytics for ERP -
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag… -
Administer Salary Notification template modificationThe approval workflow for administer salary includes - current HRBP-> Second Level Manager -> AROC_COMPENSATION_ROLE EXCEPTION: if the person receiving the salary increa… -
Query to fetch approvers listWe are trying to customize performance seeded report and trying to fetch the list of approvers/managers who has approved the document. We are trying to get the details f… -
Is it possible to register BICC Jobs in an ESS Job Set?Is it possible to register BICC Jobs in an ESS Job Set? -
Difference in Accounts Shown Between Trial Balance Extract Report and SmartViewWe have a doubt regarding the Trial Balance. When we run the Trial Balance Extract Report from the Schedule Processes, the output is missing some accounts. However, when…Mukesh Sirigiri 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Issue with PO PDF Layout in Oracle FusionWhile customizing the Purchase Order PDF layout in Oracle Fusion, I encountered an issue with the standard data model. When the PO is in "Draft" status, all line details… -
Total Outstanding Amount and Current Amount in FDI are retrieving incorrect information.I am working on an AP analysis in FDI and I am using the fields Total transaction Amount (AP Invoices), Total Outstanding Amount (AP Aging) and Current Amount (AP Aging)…Maria F Covarrubias-Oracle 12 views 0 comments 0 points Started by Maria F Covarrubias-Oracle Payables, Payments & Cash Management -
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany