Reports
Discussion List
-
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…User_2025-02-07-19-03-14-525 48 views 6 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 30 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM -
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 -
Reports Note Function with Note Template parameter not workingSummary Note Function with Note TemplateContent I am trying to use a Note function in a MR grid. I have multiple Note Templates that overlap on the same POV. I want to d… -
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 33 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM -
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 19 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP -
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 827 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
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 -
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
What's New in 21.07?Summary Better late than never for me to post...Content Yes, I know I'm 2 weeks later than normal. Sorry if you haven't been able to sleep at night awaiting this post bu… -
Importing MR reports from Narrative Reporting to PlanningContent I am trying to explore the new functionality rolled out in Planning where Management Report (MR) comes as standard. We have a good amount of MR reports that were… -
Export Excel new Report ModuleContent Hello, How can I export reports to excel in the new reporting module? Thanks, Michael -
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular … -
21B Project Performance is picking up the wrong data as compared to Manage Committed Cost and ManageSummary 21B Project Performance page is picking up the wrong data as compared to Manage Committed Cost and Manage Project Cost Page?Content Hi Experts, Please for your a… -
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We… -
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 -
Field in form - how to find the corresponding attribute and tableContent Hi experts :) I have been working in many different ERP systems. Oracle Cloud is new to me. In some ERP systems it is possible in a form to access information ab…NajaBM 65 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 250 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Report as reference doclet: grid per individual member (pov) in doclet?Content Narrative reporting: When using a management report (one grid, several cost centers) as a reference doclet, you are asked to set the POV when inserting the repor… -
Generate Data in Query with ThresholdSummary Generate Data in Query with ThresholdContent Hi - Is there a way we can generate Data through PCMCS Query with a threshold, say I would like to have only the Cos…Amit Agarwal-158816 43 views 3 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop… -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…