Category 81
Discussion List
-
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 41 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM -
Accounts/Transactions That Should Not Be Carried Forward:Purchase Order Balance by Control BudgetSummary: Can't find the following report "Purchase Order Balance by Control Budget report" Content (required): Documentation 'Using Financials for the Public Sector' rel… -
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 31 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
how to restricted otbi report to show employee absencesDear , I have a otbi report which is showing correctly result with all employees absences but issue is its showing for those employee who applied leaves on 2021 Dec to 2…Mirza_Adeel 31 views 6 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details… -
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 541 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP -
Is there onboarding form edited by Acrobat Pro? required timestamp from pdf editor?Summary: HI all, we are trying to get time date and timezone format in onboarding forms in pdf editor. the example of time zone format is 2022.08.03 09:55:19 -04'00' . A… -
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 81 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
Regarding Alternate Fusion Application function for XLA_CONDITIONS_PKG.DISPLAY_CONDITIONSummary: Hi Team, We are migrating a few reports from EBS to Fusion and we have found that the XLA_CONDITIONS_PKG.DISPLAY_CONDITION function is not available in the Fusi…Ankit GML 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…Hazel De Castro 61 views 15 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
How to add an image in customize on email custom with datamodelSummary: Content (required): Hello, We are creating custom notifications for the learning module for a client. In particular, we have created both reports, bursting and … -
Encryption Approach for outbound interfacesContent Hi Team, We have couple of outbound interfaces from HCM cloud to third parties. And we want to encrypt the output files. We are evaluating the below options: 1. … -
Huge number of Contracts impact on reporting/performanceHello team, We are evaluating options where there will be around half a million contracts created in the system to perform billing from Projects each year. I need pointe… -
In Otbi reports where we find Absence DatesDear , I need to put Absences Dates in otbi report but i cant find Not need Date Start and End Date i need only Date For example if one employees taken 30 leaves from 25… -
Can we include a pivot table in a OTBI report.Summary: I have a report and wondering if a Pivot table can be added so if we run this report or schedule it, it would include that pivot table? Content (required): Vers…Rajib_Samanta 51 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 21 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Deep Links in narrative textSummary: Content (required): Hi, I would like to insert a deep link inside an alert with narrative text. For example: https...fscmUI/faces/deeplink?objType=DOCUMENT_RECO…Alberto Americi 71 views 12 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM -
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…Aloka Bhattacharya 61 views 2 comments 0 points Most recent by R Ravichandran Reporting and Analytics for HCM -
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar…Maria Xydopoulou 31 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM -
Customizing the Payables Workflow Transactions Listing seeded reportSummary: Business needed few more column for the seeded report, But we do not have access to Data model.Suggestions needed in order to get this done. Content (required):…NarenInova 91 views 4 comments 0 points Most recent by Raunak Kumar Singh Payables, Payments & Cash Management -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 113 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
Competencies custom ReportSummary: new to the oracle HCM system and i need to create a report listing all competencies for a job / position by staff assigned to these titles. Content (required): … -
Payables Trial Balance OTBISummary: Payables Trial Balance OTBI Content (required): How to create Payables Trial Balance from OTBI? How do I get the as at date? How do I get the Original Amount an…CraigX 41 views 1 comment 0 points Most recent by Nagaraju-Oracle Payables, Payments & Cash Management