Reports
Discussion List
-
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 33 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 41 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 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 21 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 33 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. 22 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 32 views 3 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM
-
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 55 views 0 comments 2 points Started by Dave Roberts_-Oracle Narrative Reporting -
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 31 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 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re…Parag Hiremath 1 view 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM