Reports
Discussion List
-
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 13 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 43 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 52 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 35 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 63 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 34 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 3 views 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. 23 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 31 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…
-
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 41 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 52 views 0 comments 2 points Started by Dave Roberts_-Oracle Narrative Reporting