Sample Reports
Discussion List
-
What is the purpose of Organization Credits in an Award ?Content Hi What is the purpose of Organization Credits in an Award ? Does it have any relation with Internal Funding Source ? If I have Cost Share internal funding sourc…User_2025-02-05-07-43-41-391 57 views 4 comments 0 points Most recent by Eva Mirzoyan Project Management -
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Non Catalog Learning Request ReportContent Hi All, Is it possible to generate an OTBI report for the non catalog requests which includes standard fields and DFFs? Please advise. Thanks.
-
BIP Report to Extract Resource Actuals and Budget and expenseSummary: Experts, I have requirement to develop a BIP report to extract resource actuals, Budgets and expense. I was able to develop another report to extract this info …
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …Jignesh_HAE 32 views 3 comments 1 point Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that.
-
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 31 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics for HCM
-
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…Cansel Karasoy 64 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 616 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP
-
Criteria for Required Learning ReportSummary: Can anyone help me find the criteria selection for "Required, Voluntary, Recommended" Assignment for this report? I need to show Required Learning that has been…
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 701 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 581 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 21 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 132 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Learning courses linked to any of the communityHi Team, Anyone developed the report to link the courses under the topic community? If so, please share. Thanks,
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 141 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 181 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.4K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…