BI Publisher
Discussion List
-
How to Customize Withholding Tax Letter (Payables and the one for Italy) and usage of je_it_wht_letSummary: We need to have a fully customized version of Withholding Tax Letter for Italy. We need it as fully customized because reqiorements want the parameters from Pay… -
Reverse the BIP Analytics Folder OwnershipHello IS there a way/process to reverse the folder ownership that was set to specific Folders. Say User A created the folder and User A was the Owner of the folder. Now,… -
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Table Names/ SQL Query to fetch the data for Other compensation from Manage OfferHello All, Someone please help on how to know the table for other compensation which can be found from MyClientGroups> Quick Actions> Manage Job Offer Please see below S…Joliver Caangay 101 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get the specialization linked with courses?Hi All, I am working on getting all courses details report and trying to get one of the column in my report Part of Specialization but i am unable to get the link betwee… -
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 1 view 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler … -
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D… -
How to Extract the whole Transactional Data of Finance and ProcurementSummary: Want to extract the transactional data of Finance and Procurement which can be easily accessible and viewed via Excel. Content (please ensure you mask any confi… -
Report number of times a learner restarted the course when inprogress under one enrollmentSummary: Capture Report number of times a learner restarted the course when inprogress under one enrollment in a BI Report Content (please ensure you mask any confidenti… -
Learning specialist needs to download certificates to comply with auditingsHi! Our client has expressed the necessity to download their employees certificate to comply with their auditings, they were previously using the route: Me >Directory > … -
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t…Paul Worsley 11 views 0 comments 0 points Most recent by Paul Worsley Reporting and Analytics for HCM -
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…Camilla Crescenzi 111 views 4 comments 0 points Most recent by AP0410 Reporting and Analytics for HCM -
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.6K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to get text attachment information from customised "Invoice Print Report" using SQL QuerySummary: Extract text attachment on customised "Invoice Print Report" data model when run via ESS job Content (please ensure you mask any confidential information): A si… -
Bill-to-Customer Tax Registration NumberIn transactions, the 'Bill-to Customer Tax Registration Number' is stored in which table and column?Shireesha 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
How attach more than one PDF file into an alert custom (e-mail)Summary: How attach more than one ".PDF" files into an alert custom (e-mail) Content (please ensure you mask any confidential information): Hi to all, our client asked u… -
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr…
-
BI Publisher - RTF Template - FontSummary: Hi Everyone, I am developing the Offer Letter and Employment Agreement for my client using BI Publisher. Since they are using numbering, and under the original … -
What is the relationship between hrc_txn_header and gl tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe… -
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 149 views 2 comments 0 points Most recent by arpit_paliwal Reporting and Analytics for ERP -
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo…Oriana L. 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…Anusha716 147 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Asset RegisterSummary: Looking for SQL query or OTBI report to get Project Segment (CoA) wise Asset Register Report. Balancing Segment, Cost Centre and Natural accounts are visible in… -
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev… -
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in… -
Which field holds data for 'Expense Auditor Completed Approval Date ' in Expense ModuleSummary: Which field holds data for 'Expense Auditor Completed Approval Date ' in Expense Module. We have also created an SR 4-0000627381. Content (please ensure you mas…