Reports
Discussion List
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 121 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
multiple phone numbers on single rowSummary: I have an employee report returning multiple rows when the employee has multiple phone types. Does anyone know how to correct so that the report only shows one …Gaby Castelan 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
alignment issues in EPBCS reportsSummary: While trying to create a report in epbcs, I am trying to put a graph and grid side by side and they will always have alignment issues in size though size, width…
-
Narrative Reporting Formula - Ignore negative values in sumHi, In narrative reporting I have a number of conditional suppressions in my report for negative values. I am trying to only sum the positive values for a certain range …
-
Can migrating Reports between TRCS applications be enabled?Summary: Solution to migrate Reports (Narrative Reporting) from one TRCS application to another Content (please ensure you mask any confidential information) We are atte…Catherine Carney 51 views 3 comments 0 points Most recent by Komala Reddy-Oracle Tax Reporting (Direct Tax) -
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 102 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 52 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 52 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 67 views 5 comments 0 points Most recent by Dileep Reddy Vattimi Reporting and Analytics for HCM