Reports
Discussion List
-
OTBI – Reporting on L2/L3 Org Hierarchy in ORC (Blank Hierarchy Fields)Summary: We’re currently trying to build an OTBI report in Oracle Recruiting Cloud (ORC) that includes organisational hierarchy information beyond the flat attributes. A… -
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered …David Dawson 15 views 1 comment 0 points Most recent by Jeroen van Beest Reporting and Analytics for HCM -
data load and Consolidation/Translation every hourHi All, In our Oracle FCCS application, we have an automated process that loads data and runs consolidation and translation every hour. If these processes are running on…sahuvipul 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Enhancements and Customization Options in FCCS Journal Reporta { text-decoration: none; color: #464feb;}tr th, tr td { border: 1px solid #e6e6e6;}tr th { background-color: #f5f5f5;} We are currently using the standard FCCS Journal…JyotiSharma 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Credit Time AU Disbursement Transactions not available in OTBISummary: Hi Team, I am trying to build an OTBI report for Credit Time AU but unable to retrieve Disbursement transactions. These transactions are visible in the UI under…Saras Mudliyar 11 views 0 comments 0 points Started by Saras Mudliyar Reporting and Analytics for HCM
-
Disable BI Report Emails in Non-Production InstanceSummary: Disable BI Report Emails in Non-Production Instance Content (please ensure you mask any confidential information): We are planning to test some process by test … -
OTBI Subledger Reconciliation Report with GL - ReportSummary: OTBI Subledger Reconciliation Report with GL - Report Content (please ensure you mask any confidential information): Hello The Company have the below subledgers…martingabriel Kinovisques 11 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
Report to Pull Current year Created Projects in EPM Project PlanningI want to pull out a report with List of Projects created for this fiscal Year under each department. In EPM Project Planning, Using Seeded Add Project rule, the project…
-
Dimension Alias in the Reports POVContent Hello All, We need help with reflecting the Dimension Alias in the Reports POV. We have the version dimension in the EPBCS application with the Dimension Alias B…Sandeep Hardikar N S 60 views 6 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 848 views 9 comments 0 points Most recent by User_P172L Reporting and Analytics for HCM -
Data Extraction Using Read-Only Replicated Data - 26B ReleaseHas anyone successfully enabled the 26B feature: Data Extraction Using Read-Only Replicated Data? (Feature ID: F44066). The step to Enable Security Console External Appl…
-
Payslip XML returns INPUT_VALUE_5 (Rate) as -1 but Rate is null in element entry pageSummary: We have created a Legacy element entry for a person through HDL with Input values for Original start date, Original end date, Multiple, Amount. All the values a…Satheesh Nesamani 11 views 0 comments 0 points Started by Satheesh Nesamani Reporting and Analytics for HCM
-
Time Change Request Type TableSummary: Hello, does anyone know which table stores the values of Request Type column in Time Change Request page? We are currently building a BIP report and was able to…
-
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so… -
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …bwdata 81 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…
-
Handling Minor Rounding Adjustments within Narrative Reporting OnlyWe have a requirement to adjust certain balances within Narrative Reporting due to minor rounding differences. These adjustments are immaterial in nature, and we would p…
-
Mailto links not workingSummary: I am trying to embed a mailto: action link in a report to create an email to a requester where they need to take action, for example where they have an invoice …
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
Can we customize the report 'Employee Vacation and Delegation Rules Report'Summary: Since there is no possibility to restrict employees who they can delegate approvals to we need to be able to control/report on creates approval delegation rules…Jeroen.Broecheler 21 views 0 comments 0 points Started by Jeroen.Broecheler Reporting and Analytics for HCM -
Managing User-Defined Attributes (UDA) for Accurate Period-Specific Financial DisclosuresSummary: Hi Experts, We have a requirement to retrieve data based on the control method, such as subsidiary, joint venture, or associate. To achieve this, we introduced …
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PUGALESWARAN PALANIVEL 41 views 9 comments 0 points Most recent by Ajay Kumar Kotha Reporting and Analytics for ERP
-
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm…Ramachandran Mani 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…Naveen_CCC 11 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Project Expenditure Organization Updated, but Last Update Date Not Reflecting Latest ChangeSummary: I am facing an issue in Manage Project Organization Classifications in Oracle Fusion. 🔸 Observation I updated the Project Expenditure Organization classificati…
-
Moving Level0 members of account hierarchy without affecting the locked prior period dataHi We need to move few Level0 members from different parents to another set of existing parents for the current period. But when I move them to new parents and consolida…PavanKorandla 47 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
ESG in EPM - Does Oracle offer any framework to enable or only the "configurable LCM solution" ?Summary: ESG in EPM - Does Oracle offer any framework to enable this as a module or only the "configurable LCM solution" ? Content (please ensure you mask any confidenti…
-
Is there a SQL to get EIN/TIN for Legal Entities?Summary: Rather than have to navigate to individual legal entities to find the EIN/TIN assigned (which is cumbersome), I would like to run a report for my Legal Entities…Linda Chirash 51 views 10 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM