Reports
Discussion List
-
EPBCS Report BuidingWhat is the best way to create a report from different cubes from epbcs, Where we have different prefixes for the metadata from account dimension members? Eg : TPF_ABCD(… -
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. https://us.v-…AjayKumar Maddipati 101 views 24 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 21 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - …
-
Invalid Intersection Report - Audit InformationSummary: We had a user create an Invalid Intersection Report, and the audit log information for this action was a bit unclear. In the audit records, the creation of this…Alyssa Longo 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Text String to Number Function in Management ReportingSummary: We have a report requirement for which I need a substring of a number from a member name to use in a formula in the report. Is there any way to achieve this wit…
-
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…THawkins_LGI 21 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning…Sowmiya Velusamy 131 views 7 comments 0 points Most recent by User_7DF56 Reporting and Analytics for HCM -
Error opening journey reportHi experts, When I try to open the journey report, this error appears. It happens every now and then, not all the time. Is there a way to solve this problem? Thank you, … -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
Ability to export or print comments entered during a particular journal entry action phaseSummary: Users have the ability enter comments during each action phase of a journal entry (ex. submitted, approved, post etc…). Is there the ability to export or print …
-
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V…AjayKumar Maddipati 11 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 51 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This …Erica Williams 61 views 11 comments 1 point Most recent by Erica Williams Reporting and Analytics for HCM -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 51 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Is it good idea making all Dimensions Dynamic calc for Freeform application (Hybrid BSO)Summary: Is it good idea making all Dimensions as Dynamic calc(Parent members) for Freeform application (Hybrid BSO). Single BSO cube application. We have one large cust…
-
Report/Dashboard about Performance ModuleContent Hi Guys, Does someone know where could we find Performance Reports or Dashboards standard? I hope in your answer, Best Regards, GiuseppeGiuseppe Iacono 68 views 5 comments 0 points Most recent by Dileep Reddy Vattimi Reporting and Analytics for HCM -
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem…CCannadayCTR 13 views 2 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
How do I query Estimated Time To Hire from ORC using BI Publisher?Summary: I need to query data on Estimated Time To Hire for existing requisitions. Any information is greatly appreciated. Content (please ensure you mask any confidenti…
-
Not able to see data from front end in LookupSummary: We are entering values in common lookup with help of Pl-sql wrapper program. In this program we are using 'fnd_lookup_values_pkg.insert_row' api to insert value…
-
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma…User_2025-02-11-03-07-51-707 36 views 3 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…Opkey PA 288 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati…AjayKumar Maddipati 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to query for encumbrance amount on an Open status Purchase OrderSummary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) usi…