BI Publisher
Discussion List
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …Shweta Prakash Veer 3 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.8K views 12 comments 1 point Most recent by Ganesh Kamath 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 = …
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
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 12 views 3 comments 0 points Most recent by User_OUC03 Reporting and Analytics for ERP
-
Need query to compare roles for personSummary: I want to compare roles for person based on role mapping. For example , role mapping has 5 roles and person has currently 2 roles only in that role map. I want …Ranjith1166 26 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…VeerakumarS 27 views 2 comments 0 points Most recent by MandeepGupta 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…
-
pasteItem2Summary: Which value of flagACL I should use to correspond to the ACL option 'Create'? Content (please ensure you mask any confidential information): Unarchive the BIP c…Gary Wan Guanghui 22 views 2 comments 0 points Most recent by Venky Pavuluri Reporting and Analytics for ERP
-
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
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 38 views 2 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…
-
payroll query in oracle ebs r12 2.7i want paroll data of an employee using oracle ebs r12 2.7
-
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 1 view 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 40 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 19 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 341 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…
-
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 15 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 166 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
-
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 46 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