Sample Reports
Discussion List
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 594 views 5 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 18 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting & Analytics for Fusion Service
-
Catalog object privilege validation failed for userSummary: Catalog object privilege validation failed for user Content (please ensure you mask any confidential information): Have downloaded a seeded report for HCM. When…Junade_Shujaat 37 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
LMS Utilization ReportSummary: I need to build a report in OBTI that shows our LMS Utilization Rates for our Executive Team. Does anyone have any examples or files that they would be willing …
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR…Bhavik Shah 3.2K views 5 comments 3 points Most recent by N.V. Mehta Reporting and Analytics for ERP -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 1.1K views 16 comments 5 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 545 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti… -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…Lee-GT 486 views 9 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM
-
MilanMohanty 143 views 3 comments 0 points Most recent by Mohd Affan Ahmed Reporting and Analytics for HCM -
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 1K views 8 comments 7 points Most recent by Mohamed Elwan Reporting and Analytics for ERP
-
Extract scheduled ReportHi Experts , Can someone help me with scheduled extract report? Looking for actual start date and end date of the scheduled job. Referred the below link which has next s…Nivya Mathire 22 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 4.2K views 55 comments 20 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c…
-
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…Pritam Das 41 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 43 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP
-
Bursting Feasibility for BIP Report having Multiple Data ModelsDear Team, We have one requirement wherein we need to enable bursting for one report having multiple data models, kindly confirm if that can be achieved. If yes, then pl…
-
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 104 views 3 comments 0 points Most recent by NikhilYadav Reporting and Analytics for ERP -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Unable to load content in self paced activity using HDL when content was loaded in system manuallySummary: We are attempting to load the self-paced activity using the content previously loaded from the front end. However, when we pass the content number, an error is …
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 102 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.4K views 17 comments 4 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 15.3K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
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…
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 387 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…