Analytics
Discussion List
-
is it possible to have access for specific entities in FRS report(income statement)?Dear all, Kindly find the below: the client want to have access in the FRS income statement for each entity to not show all the income statements available in the financ…Anthony Sleiman 21 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
how to edit Supplier negotiation invitation email subjectSummary: I need to change/edit the supplier negotiation invitation email subject which is sent to suppliers to invite them to negotiation. Content (required): I need to …
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…Suganya v 12 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…Tom Harris 31 views 2 comments 0 points Most recent by Sandeep Pati-Trinamix Supply Chain Planning and Collaboration
-
How to pick delivery method (online or offline) on the report defined in development goal pageOn the development goal page we have attached the course as a training and that course has DFF of online training or offline training defined on create course page, now … -
ORC Job Offer Letter has got a different font than the RTF Template.Hi Team, I am currently facing an issue on the Job Offer letter in ORC,the customer is using their own custom font style for branding purpose. I am using the same font s…Beatrice C 32 views 1 comment 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace
-
How to display the content of the PO PDF document in the Email body of the Approval NotificationApart from getting the attachment as a PDF, need to display a few columns in the email body as well
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…Nalsoft Pvt Ltd 12 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…Nalsoft Pvt Ltd 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 95 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
Hi, Can somebody assist how to join external data source into subject area in Oracle Analytics CloudHi, Can somebody assist how to connect to external data source into subject area in Oracle Analytics Cloud - FDI?Priya Parthiban 21 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…Isaac_s 83 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables
-
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a… -
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 16 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 31 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Hide Reject Button only in Performance Goal Approval Workflow Email NotificationsHi, We need to populate only Approve and Request info buttons in workflow email and remove Reject button. Thanks, Chetanpuja suryanarayana 32 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management
-
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification…Katharina_Seidenfuß 11 views 0 comments 0 points Started by Katharina_Seidenfuß Reporting and Analytics for HCM -
How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which…
-
Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …Ksimmy200 21 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service -
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …Tuhinaa Nanda 72 views 3 comments 0 points Most recent by Will Paddock -Support-Oracle Reporting and Analytics for HCM
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Oracle BIP Report Job ends in error: ORA-56733: logical I/O limit exceededWe have a customized report that when is scheduled ends in error: ORA-56733: logical I/O limit exceeded. What's weird is that when we run the report via the catalog with…User_APIIU 71 views 3 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service