BI Publisher
Discussion List
-
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a…Parag Hiremath 1 view 0 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I see all chart types in Fusion Data Intelligence (FDI)?Summary: How can I see all chart types in Fusion Data Intelligence (FDI)? Content (please ensure you mask any confidential information): I need to know what kind of char…Stefano_Mazzocca 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
sql to get learner pass fail status along with course completionHello, Does any one know which table stores the Learner course completion status (complete/not complete) along with pass/fail status? @Sricharan Monigari @MandeepGupta @… -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 82 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Can we get ZPL output for Zebra Printer from Oracle BI PublisherSummary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidentia…Sandipan_Chakraborti07 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…PrasadN 52 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…Chez 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…LE 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Hide Custom ESS Job Parameters LOV Seach FieldsHello, As the client requirement, we create a Custom ESS Job to run a BI Publisher Report. For this report, we need a few parameters, and for two of these parameters, ex…
-
Query to get the details of Project Cost Transfer status in Time card details in OTL.For a reporting purpose we want the details of Project Cost Transfer Status from Additional Statuses with in Time Card Details for a particular date range. Please find t…
-
Oracle HCM Extract, function XDO_SKIPROW not working in excel template with multisheetsI need to hide/skip some rows in each sheets with different conditions for each sheet. Instead i am using : XDO_GROUP_?XDOG2? but it is limited to 1 condition. What is…
-
1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…Evelina Hobson 1 view 0 comments 0 points Most recent by Evelina Hobson Reporting and Analytics for HCM
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture … -
OTBI - Static PDF attachment in email notificationSummary Is there any option to attach PDF in email notificationsContent Hello, We have a requirement to send email notification to new joiners along with user guides att…User_2025-02-05-07-43-29-505 69 views 8 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM -
Oracle Report Rendering IssueHi All, When I try to run a report post mapping the fields using BI, the excel output is not generating. Getting the below issue.. But when I try to download the same in…Dhilipkumaar-Oracle 11 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
where can i find receiving and inbound quantity's for on hand reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_3KQOD 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get costing and Element linkSummary SQL Query to get costing segment columns and element link name columnContent Hi All, I want to pull the costing segments along with credit, debit amounts and ele…User_C7E7N 775 views 4 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a…
-
How to get party tax profile third party and third party site?We would to get a query to extract party tax profile third party and third party site but but with the one we used we can only extract third parties: Select zxp.PARTY_TY…Ylenia Gentile 148 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
Table name to join course with competency/skill/certification details direclySummary: Hi Team, I have one requirement where we need to fetch course wise skill/competency/certification details. Please help to apply direct join to the skill/compete…
-
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
emergency contacts reportsSummary: Hello, I've created report to get emergency contacts for employee below this only part of it. I'm getting error message that subquery return more then one row. …
-
ap_holds_all.last_updated_by as "HOLD_RELEASED_BY"This is related to the AP Invoice tax hold release. We are looking for the table details where the hold released by name will be captured for the AP Invoice. Currently w…POOJAJSINGH 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…