BI Publisher
Discussion List
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 92 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 868 views 12 comments 1 point Most recent by User_FVSCP Reporting and Analytics for HCM -
Incorrect Payables Invoice Approval Email TemplateHello, We're encountering a strange issue where (very rarely) a Payables invoice sent for approval triggers an email notification using a template that doesn't exist in …Willson Mach 31 views 4 comments 0 points Most recent by SanjayBasera Payables, Payments & Cash Management -
query to get employees with missing bank accountswe want all new employees who didnt enter their bank account details -
How to link AP Invoice directly to GL Module as it is not hitting subledgerSummary: Hi Team, How to link AP Invoice directly to GL Module as it is not hitting subledger Content (please ensure you mask any confidential information): Version (inc…Aditi Agrawal2650 31 views 3 comments 0 points Most recent by JimCC Subledger Accounting & Accounting Hub -
How to get items list along with Inventory organization associationSummary: How to get items list along with Inventory organization association Content (please ensure you mask any confidential information): We need list of items along w… -
Expense report Output show words garbledSummary: Expense report Output show words Garbled, Unable to read by users Content (please ensure you mask any confidential information): Expense report Output show word… -
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI… -
How to concatonate two values into a single field on Positive Pay XML templateWe have a need to combine payee name and address line 2 into the same field for one of our Positive Pay XML templates. I have tried using the concatonation function disc…Daniel T Roy 11 views 4 comments 0 points Most recent by Daniel T Roy Payables, Payments & Cash Management -
Certain fields from table HZ_PERSON_PROFILES are not visible in AR Customer MasterHi, Certain fields like Gender, Date of Birth, Date of Death, and Initials from HZ_PERSON_PROFILE are present in the backend HZ_PARTIES table but are currently unavailab…Rimoni Shah-Oracle 21 views 2 comments 0 points Most recent by Rimoni Shah-Oracle Receivables & Collections -
Past Attempt Details of LearnersIssue: We would like to view the learner's past attempts for specific courses through BIP. Description: We encountered an issue where a learner completes a course or off…Mohammed Waseem Akram S 51 views 2 comments 0 points Most recent by Mohammed Waseem Akram S Learning -
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written… -
Payment Approval History ReportHi Team, We are trying to develop a query for Payment Approval History Report. Business requested to pull the below details: Payment_number Submitted_By Submitted_Date P…Badripalli Archana-Oracle 191 views 4 comments 0 points Most recent by James McBride Payables, Payments & Cash Management -
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 12 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d… -
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif… -
Actual Termination Key Date?Client is saying The ActualTerminationKeyedDate is a column in the "per_periods_of_service" table. We don’t see from our side the termination_key_date from "per_periods_…Ronel M 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 213 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM -
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 566 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
How do I add location and brand segments to a Cost Summary report for fixed assets in Oracle Fusion?Summary: I would like to customize a seeded report found in Oracle Fusion by adding brand and location segments by updating the data model. Content (required): Version (… -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 76 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status … -
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava… -
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l…