Sample Reports
Discussion List
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 545 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 191 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP -
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 43 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Total completion count from the year reportSummary: I need a report that show the total number of completions either overall or for each time I try to put dated parameters in (Jan 1 2023-Dec 31-2023) I get every …
-
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 1 view 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM
-
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 28 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 1 view 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Managing Bounce Back EmailsHi everyone, We are looking for ways to manage email bounce backs when assigning Surveys to a large group of employees. The purpose of this requirement will support the …
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 466 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 51 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 32 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 41 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 544 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 23 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 1 view 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Project Cost Budget BreakoutSummary: Project Cost Budget Breakout Content (please ensure you mask any confidential information): How can I get the breakout of what makes up the Cost Budget? Which r…
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM