Analytics
Discussion List
-
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… -
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 32 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 31 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 22 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 12 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 46 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 13 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 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany -
How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…Rasagna Repaka-Oracle 24 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 41 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Personal Profile set up in support.oracle.comSummary: Hi I am unable to complete my personal profile on support.oracle.com since the website is not sending any verification code in my mobile. Thank you! Content (pl… -
how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 45 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service