BI Publisher
Discussion List
-
Fetching Workforce Structure from Job Profile Type in BI queryContent Hi Team, I have a requirement of fetching "Workforce Structure" from Job Profile using BI query.Please help me with the query. Thanks Sandip KarmakarSandip Karmakar 66 views 3 comments 1 point Most recent by Jen Troeger Reporting and Analytics for HCM -
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 41 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le… -
How can I pass the current date to a job that runs a BI publisher report with a text parameter?Summary: I have a report that takes a date in TZ format (ex: '2023-03-10T00:00:00.000+05:00'), through a text parameter. I need to create a scheduled job for this report…
-
Customize create accounting jobHi, We have more than 50 ledgers and would like to schedule a create accounting program for all the ledgers. Ledger is a mandatory field while submission of the program …
-
Need to restrict Public output of a report to a group of peopleSummary: Currently report output generated using "Make output Public" is visible to everybody but we want to restrict this Public output of the report to a particular gr…Tarun_chaudhary 11 views 2 comments 0 points Most recent by Tarun_chaudhary Reporting and Analytics for HCM
-
FEC - Audit report for France - huge data problemSummary: FEC - Audit report for France - huge data problem Content (required): We are concerned about the high volume of data generated by the FEC ( Audit report for Fra…Patrick Chrabieh 101 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 834 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
Location Report - No ResultSummary: Content (required): Attempted to run a seeded BI Publisher report but there are no results. Shared Folders/Human Capital Management/Data Exchange/Location Repor…
-
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 551 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to get Payment Id and Invoices related to a posted G/L batch?Summary: We need to get the payments and invoices related to a posted batch and prints it (the invoice) in a custom BIP Report Content (required): We're working on a cus…Claudio Errecart 133 views 0 comments 0 points Started by Claudio Errecart Reporting and Analytics for ERP
-
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 167 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…minati_behera-Oracle 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 31 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
find an approver from the setup tablesHi, We don't have any report or workflow to check the potential approver once Invoice adjustment is submitted by the user in Receivables Module. so I am trying to develo…Madhu A 42 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Were Does The 'Generate Audit Report' Data Model reside in BI Publisher.Summary: Hi there, Were Does The 'Generate Audit Report' Data Model resides in BI Publisher ? Content (required): Does anyone know where the data model linked to the 'Ge…
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…[Deleted User] 2.3K views 4 comments 2 points Most recent by Kavitha Balaiah Reporting and Analytics for HCM
-
How do we obtain a report of the notes associated with a lead?Summary: We need to obtain a report to obtain the relationship of leads with the notes that have been created. Content (required): We tried to build this report across s…SERGIO BARRETO 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Oracle BIP Report Issue with RTF templateSummary: Seeking a solution to fix the corrupted RTP template. Content (required): Enhancing the existing rtf template to add a new field. However, the new field value d… -
Specialization and Course assignment records relationSummary Tables for specialization and course assignment relation recordsContent Hello Folks Can anyone in this forum help me with information regarding the tables which …
-
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
Table to pull the ESS Scheduled Job definition details.Summary Required table which stores the ESS scheduled job defiinition details.Content Hi Experts, I would like to know from which table we can pull the ESS Job definitio…Charan Kollipara 116 views 3 comments 1 point Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for HCM
-
Invoice line Level DFF Information on PPR XMLSummary: Hi Experts, We got a requirement to capture AP Invoice line-level DFF information on Separate Remittance Advice. When we generate PPR XML, we are able to identi…Akhil Ch-Oracle 21 views 2 comments 1 point Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management
-
REST - API for AR InvoiceSummary: We have a requirement to populate BILLING_PERIOD_START_DATE and BILLING_PERIOD_END_DATE in the AR lines level while creating AR invoice with REST API. Is there …Sam Samaddar 42 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…Ratha Sun 41 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM