BI Publisher
Discussion List
-
Report showing Employee Hierarchy in an OrganizationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ramesh Kumar.S-Oracle 1 view 0 comments 0 points Started by Ramesh Kumar.S-Oracle Reporting and Analytics for HCM -
was trying to fetch the date format as 01-Jan-2025 in bip getting an errorHey i have a requirement in the bip where the date format is 01-Jan-2025 and in the SQL of bip i have used the format like TO_CHAR(ele.EFFECTIVE_END_DATE,'DD-Mon-YYYY') …Kande Likhitha 42 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Issue with a date column in customized Asset Register report in Oracle FusionHi, We customized the Fixed Assets "Asset Register" report. There's a date column whose logic is as below. (SELECTTO_DATE(TO_CHAR(fcp.end_date, 'MM-DD-YYYY'), 'MM-DD-YYY…
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 51 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
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…
-
Provide the supplier balance aging report logic from backend.Summary: Hi Team, Could you please help us to provide the supplier balance aging report logic from backend. We were not able to see the logic of supplier balance aging r…Arjunayan 41 views 2 comments 0 points Most recent by Arjunayan Payables, Payments & Cash Management
-
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…
-
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 143 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. 16 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM