BI Publisher
Discussion List
-
Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT TableBeginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't … -
Extra space at the top of the page : RTF TemplateSummary: Having a strange issue with PDF generated form RTF Template. The RTF template has a header. The PDF output when generated has a blank space at the top of the he…Arun Raj 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BIP report link errors unless "Create Search Index" runs—need guidance on recurring schedule.Summary: Hi Team, We have build a BI Publisher (BIP) report that sends an email to the line manager containing the same observation checklist link that appears in the re… -
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
How to zip multiple output files from HCM Extract and FTP to third partySummary: How to zip multiple output files from HCM Extract and FTP to third party Content (please ensure you mask any confidential information): We have a requirement to…
-
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 3.8K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP to create report from custom tables created in PaaS Content (please ensure you mask any confidential information): We have a require…Jepson Erattuparmbil 61 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…VasanthaFusion90 44 views 1 comment 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
Feasibility of Sending Observation Checklist Link via Email from BIPSummary: Hi Team, We have created an observation checklist activity within a blended offering. This checklist is triggered to the learner's line manager, and the line ma…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 132 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Report that can extract information about the user's active tasksIs there a report that can extract information about the user's active tasks, which are displayed in the task area of each module? A report on the privileges assigned to…
-
OOTB Subject Area and Custom Subject Area crossedIf OOTB Subject Area and Custom Subject Area have crossed, Is there any support to see if this can be done?M.AZUMA 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Could you please help with fusion table details or query to get Supplier Email Address.Summary: Looking for list of all Oracle Suppliers email addresses held in Oracle fusion. Thanks. Content (please ensure you mask any confidential information): Looking f…ManishaPatil 380 views 2 comments 0 points Most recent by Kinjal Patel-Oracle Reporting and Analytics for ERP
-
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report? -
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 11 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 133 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 61 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP
-
Include URL in BI Publisher report to allow viewing of invoice attachmentsSummary: I am trying to find a way to include a url link to a scanned invoice images stored as pdf attachments in Oracle from a BI Publisher report. Content (required): …User_2025-02-10-15-12-48-631 371 views 9 comments 1 point Most recent by Ramya_30395 Reporting and Analytics for ERP -
How to upload multiple documents to same DOR Type using HCM Extract Delivery optionSummary: I have a requirement to upload multiple documents to single DOR. Do we have any option to upload the multiple documents in single DOR record instead of creating…
-
Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_FSummary: Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F Content (please ensure you mask any confidential information): I am extracting data fro…
-
HCM Extracts PGP Encryption converts file to ANSI FormatHi Experts, We have built an HCM extract with e-text template which generates CSV file. Without encryption turned on, the file format is UTF-8, but after PGP encryption …
-
How the continuous transfer of budget balances to the budget cube affects tablesPlease tell me about the impact on tables of the ESS job "Continuous transfer of budget balances to budget cube: transfer schedule" being run. Currently, the BIP report …Akari Nuno 79 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany