Sample Reports
Discussion List
-
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 66 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.2K 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 61 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 96 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 46 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 53 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…Vinod Kumar Mohanraj 55 views 1 comment 1 point Most recent by SimonTomey Reporting and Analytics for ERP
-
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying …
-
Report: Project Number is '000000' for most of projects in report.Summary Report: Project Number is '000000' for most of projects in report.Content Hi All, Report: Project Number is '000000' for most of the projects in the report. Vers…
-
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…User_2025-01-30-20-59-13-989 63 views 2 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for ERP -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How can you modifying due date for a required offering using HDL for mass learnersContent I have over 2000 learners in a required course offering and I need to modify the due date. I see I can do it one at a time, but how can I do it using a dat file …
-
Course File Path ReportSummary Need to identify the file path of all SCORM and AICC courses in Taleo Learn.Content We are transitioning content and need to identify the file path for each of t…
-
Project Costing - Committed CostSummary Project Costing - Committed CostContent Project Costing - Committed Cost - 1. Once a requisition is raised it is reflected under Committed Cost. 2. Once the Purc…
-
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 235 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 937 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 931 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…User_85V95 42 views 4 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 1.1K views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Learning InfoletsSummary Looking to see if anyone has created Infolets for managers to see the status of their teams trainingContent Looking to see if anyone has created Infolets for man…