Reports
Discussion List
-
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 23 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 47 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 37 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…Gurivi Reddy-Oracle 27 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 18 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 45 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 50 views 10 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
The absence report should calculates absence durations based solely on working days.We have created a report name "Absence Balance Details Report" , which has below columns : EMPLOYEE NUMBER EMPLOYEE NAME LEGISLATION CODE LEGAL EMPLOYER NAME ASSIGNMENT …User_6VOPA 31 views 4 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
Lease Accounting - CWB + Test Scripts + Business Process ModelSummary: Lease Accounting - CWB + Test Script + Process Flow Content (required): We are looking at replacing our legacy system for Lease with Oracle Lease Accounting, an… -
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 61 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
VAT report for a specific VAT regime currencyWe have a requirement to generate a VAT report for a specific VAT regime currency (e.g., DKK), with potential extension to additional currencies in the future. For examp…Kamonwan Srasrisom 22 views 2 comments 0 points Most recent by Kamonwan Srasrisom Tax Reporting (Direct Tax)
-
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their…Abdul Raqueeb 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 1 view 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
how get query manage locationsCan someone help me with the query to obtain the information shown in the "manage locations" option? Basic details name status code Main address Main address usage type …Henry S. 25 views 3 comments 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 34 views 3 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM
-
What role is required to run the report in Lease Accounting Folder?Summary: I'm receiving below error when trying to run the report under Lease Accounting Tab > Leases > Generate Lease Transactions and Balances Report "Exception in Exec…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.1K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP
-
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…Mohammad Merie 7 views 0 comments 0 points Started by Mohammad Merie Reporting and Analytics for ERP
-
How does smart view work with Oracle fusion? are there any conditions to work like license?Summary: How does Smart View work with Oracle Fusion? Are there any conditions to work like a license? Content (please ensure you mask any confidential information): Ver…Mohamed Roshdy 43 views 4 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 26.06What’s New in EPM Cloud Narrative Reporting and Reports Release 26.06 Please refer to the June 2026 What's New Guide to understand the new features included in Cloud EPM…Dave Roberts_-Oracle 44 views 0 comments 2 points Started by Dave Roberts_-Oracle Narrative Reporting -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 91 views 16 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
Unable to pull the pull the complete parent hierarchy chain through OTBI reportUnable to pull the pull the complete parent hierarchy chain (Parent Manager 01 to Parent Manager 05) for terminated cases through OTBI report Subject Area > Workforce Ma…Harpreet Kohli 34 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is data contained in a report created/ scheduled in BI Publisher automatically encrypted ?We are looking to improve the way data is extracted from Oracle Fusion and delivered to internal customers. Using BI Publisher reporting, it is not clear or visible if t…
-
CIP Account Analysis is not showing dataSummary: Why is my asset project not showing data here in the dashboard: There are plenty of cap transactions. I have also tried with chosing all periods - same result …
-
Employee Rating not fetchingSummary: I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Sta…Marilyn O 15 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM