Sample Reports
Discussion List
-
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…Padamatinti Varsha 20 views 4 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 1K views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP
-
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me…Reddykrishna Chidella-Oracle 38 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 46 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 188 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Recruitment Subject Area - retrieve Candidate skillsSummary Fusion (21c) Subject Area Recruiting - Recruiting Real TimeContent Our customer requirement is to see Skills from the 'Skill and Qualifications' Candidate sectio… -
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 380 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
commonly used HCM tables in fusionContent Hi, Any body has commonly used HCM tables in fusion, Please let me know. Regards, ReddykrishnaReddykrishna Chidella-Oracle 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 48 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
Exception reporting for projects with no baselined budgetContent We are trying to create a report that will list any projects that do not have a baselined budget. I have been able to get so far in OTBI using 'Project Control -…
-
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 23 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 371 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific usersMurilo Damasceno 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 63 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 83 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Project task Exceptions-PPM Tables/ViewSummary Looking for Project Task Exceptions information in DBContent Hi All, I am looking for information about Project task exceptions data in PPM tables Or BI report t… -
PJC_TXN_TASK _NAME_IS_INV ALIDSummary PJC_TXN_TASK _NAME_IS_INV ALIDContent I keep getting this error for below. some transaction load and others error. Task Number Task Name 3 Overtime PJC_TXN_TASK …
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.3K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Risk Management Entitlements ReportSummary A listing of entitlements and the access points they are composed of.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file…Stephanie Golly-Oracle 75 views 2 comments 2 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Risk Management Results by Control Summary ExtractSummary For a specified control, show the last time it was run, by who and how many results it returned.Content * Download the zip file attached to this post * Unzip and…Stephanie Golly-Oracle 160 views 3 comments 3 points Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 2K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Sample Daily Digest for Agents - Unassigned and My Open TicketsSummary Daily digest report ready for subscribable agent to inform agent of open tickets currently assigned to them or unassigned but in their queueContent Our agents wo…Josh Vincent 60 views 2 comments 1 point Most recent by Josh Vincent Reporting & Analytics for Fusion Service -
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 50 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…Vinod Kumar Mohanraj 31 views 2 comments 1 point Most recent by Vinod Kumar Mohanraj Reporting and Analytics for ERP
-
Integration from Microsoft Projects to Oracle FusionSummary Integration from Microsoft Projects to Oracle FusionContent Hello I have read the following note about the integration between Microsoft Projects and PPM. Micros…gabriel kinovisques-163562 107 views 5 comments 0 points Most recent by Andy May-Coates-Oracle Project Management
-
Application table for standard coverage under subscription managementSummary Need to query coverage details under subscription management using data modelContent Subscription Management -> Standard Coverage - > (Template details) what is …ViswanathaReddyKetireddy 45 views 1 comment 0 points Most recent by Justin Anderson-Oracle Reporting & Analytics for Fusion Service
-
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an…Koteswararao Yenikepalli 54 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP