BI Publisher
Discussion List
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 70 views 8 comments 0 points Most recent by MarkHodges Reporting and Analytics for HCM -
Is there any standard report for document of record audit fields?Hi, After 26A the audit field (Last updated by) of the screen "document of record" are not visible anymore. For audit purposes, HR administrator needs to view this infor…Lynda Ramos 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Filter PER_EXT_PAY_EMPLOYEES_V2_UE to get the assignments of employees with payroll results onlySummary: Our custom HCM Extract contains the following UEs (per hierarchy): 1. PAYROLL ACTIONS RANGE UE (Root Data Group) 2. PAYROLL REL ACTIONS RANGE UE (Connected to #…
-
Technical Specialization BI Pub ReportHello everyone, We need to create a BI Publisher report to retrieve the Technical Specialization for each employee. For this, we need to extract all technical specializa…Andriampeno Odilon 55 views 9 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow 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 PDF. The …PASALA SATEESH REDDY 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Balance Value for Balance Dimension visible in Fusion UI but not in OTBISummary: We are trying to lookup Payroll Balance Results based on a specific Dimension Name and Balance Name, and the output retrieved from OTBI is not matching to that …
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 97 views 18 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
PaybalesWhen printing the check directly from the application, certain details such as the amount in words are not appearing on the check. However, when the same PDF is download…Akshat Srivastava 1 view 0 comments 0 points Started by Akshat Srivastava Payables, Payments & Cash Management
-
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 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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 11 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 27 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 23 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 21 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 32 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.4K 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 33 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 21 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 11 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 …