BI Publisher
Discussion List
-
Data Model option does not show up in BIPSummary: Data Model option does not show up in BIP Content (please ensure you mask any confidential information): Hi All, Greetings! We have added the needful BI related…Parag Hiremath 10 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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… -
French Social Report - Required Parameters and Payroll Action IDHello, I am working with the French Social Report BI Publisher report. To run the report, several parameters need to be provided, such as: ArchiveActionId DeliveryOption…Imene_Zaouzaou 21 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Print Receivables Transactions – multiple invoices for same customer in one email or PDFSummary: We are using the standard Print Receivables Transactions job in Oracle Cloud ERP to generate and burst invoice PDFs to customers via email. The standard process… -
ASE_USER_ROLE_MBR table usage restriction and alternate table suggestionSummary: Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation detail… -
payroll query in oracle ebs r12 2.7i want paroll data of an employee using oracle ebs r12 2.7 -
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…Opkey PA 10 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Trial balance report is not matching with Payables open item revaluation report for the Past periodsTeam, Trial balance report is not matching with Payables open item revaluation report for the Past periods. Since invoices are paid in the later period. For Example: Inv…Raj Thirumal 4 views 3 comments 0 points Most recent by Raj Thirumal Payables, Payments & Cash Management -
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 1.3K views 4 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM -
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for…Shikha Agarwal 1.6K views 7 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…Gurivi Reddy-Oracle 23 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
BI Catalog Folder ManagementI am looking for best practices on managing Custom Folder in BI Catalog: We have 2 folders for custom reports: Custom Folder and CompanyName Business User Reports (mostl…Ulitka 12 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Unable to Identify Join Between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B for Evaluation DetailsSummary: We need to retrieve evaluation details in our report. We are able to identify the evaluation records in the WLF_LI_ACTIVITIES_F table where the ACTIVITY_TYPE = … -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 347 views 8 comments 11 points Most recent by Ulitka Reporting and Analytics for HCM -
Content Type - Web LinkSummary: What is the correct mapping for content weblink for a web based content type. We are mapping the Web link from table - WLF_LI_CONTENT_F and field - STARTING_URL… -
Financial Reporting Excel Export Splitting into Multiple Worksheets Instead of a Single WorksheetHi Everyone, We're experiencing an issue where Financial Reports exported from Open Workspace for Financial Reports are now split into multiple Excel worksheets based on… -
Uploaded Daily Rates QuerySummary: Need to create a report for the uploaded conversion daily rate in the GL. Content (please ensure you mask any confidential information): Hello, We have a requir…Mamdouh Ahmed 15 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP -
Change Email Subject for Separate Remittance Advice EmailSummary: How would we change the email subject when sending payment remittance advice. We currently have Payment Notification as our current Email Subject. I believe th…Lovely Tamba 14 views 4 comments 0 points Most recent by Lovely Tamba Payables, Payments & Cash Management -
How to Display Daily Movement Debit and Credit Separately in FRS Using the ADB CubeSummary: We have a requirement to display Daily Movement Debit and Daily Movement Credit in separate columns in an FRS (Financial Reporting Studio) report using the ADB … -
Oracle AI Apps: Intelligent Account Combination DefaultingSummary: Hi Oracle Team, When i going to enable this feature 'Oracle AI Apps: Intelligent Account Combination Defaulting' , I can't find the mentioned job role AIAPPS_BI…Mina Sabry 161 views 14 comments 0 points Most recent by Rekhav Payables, Payments & Cash Management -
Request for Solution & Documentation on Oracle Fusion ERP Integration with ZATCA for AR invoicesSummary: We are currently working on implementing e-Invoicing compliance for Saudi Arabia (KSA) and need to integrate Oracle Fusion ERP with the ZATCA portal in accordan… -
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…SushmaMeesala006 41 views 6 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…Shruthi Arun Krithika 1 view 0 comments 0 points Started by Shruthi Arun Krithika Reporting and Analytics for ERP -
SQL not fetching pending worker created in last 1 hourSummary: SQL not fetching pending worker created in last 1 hour Content (please ensure you mask any confidential information): Hi All, There is a BIP report with burstin…Gayathri K M-Oracle 45 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
From email address for the scheduled reports not stored in the tableSummary: While trying to extract the From Email address for the scheduled reports then "bipublisher-report@oracle.com" is getting fetched instead of the actual Email add…Ranjith1166 21 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 17 views 3 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM -
PDF and doc / docx document types not supported as attachments to Expense ReportsSummary The expense report printed from the system using “Print Preview with Attachments” shows blank pages in place of the so called “unsupported” attachment formats (P…