BI Publisher
Discussion List
-
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM -
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 204 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 372 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
Need BIP report SQL query to get GL Balances by Posting Date in oracle FusionSummary: Customer is looking for following columns in the report -Ledger -Period -Posting Date -Account -beginning balance -period activity -ending balance tried to join…Kalyani-Oracle 27 views 5 comments 0 points Most recent by Kalyani-Oracle General Ledger & Intercompany
-
How to Sort the data in Resource AlertSummary: We've developed an alert which will notify line managers and listing the employee's (reporting to the line manager) who are all overdue in completing their lear… -
How to create positive pay file for outside checks recorded using Manual paymentSummary: Need to create positive pay file for payments recorded using Payment type = Manual while using the "create payment" functionality Content (please ensure you mas…Umakanth Saripalli 31 views 4 comments 0 points Most recent by Kish_Hariharan Payables, Payments & Cash Management
-
Impact of Redwood Changes on backend Tables (OTBI/BIP/FRS Reports)Summary: Any changes to database/table structure for Fusion Financials? Any guide/pointers on what's needed to be checked before/after migrating to Redwood for our exist…
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
Create Rules XML File for BI Extender Automation under a custom roleSummary: How to allow ESS Job 'Create Rules XML File for BI Extender Automation' under a custom role (no privilege since a Java type program) Content (please ensure you …Umesh Chauhan 21 views 2 comments 0 points Most recent by Umesh Chauhan Reporting and Analytics for ERP
-
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
Scheduling in HCM ExtractWe have the following requirement for the extract and would like to seek inputs on feasibility and the recommended solution approach. Requirement: The extract XX needs t…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 7 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…Raghavendar 446 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
How to Include Invoice Legal Entity in Custom Oracle Payment File for Third-Party IntegrationSummary: We are working on integrating Oracle ERP Cloud with a third-party platform to process Accounts Payable (AP) payments. The process involves submitting a Payment …Khushbu Mahindru 1 view 3 comments 0 points Most recent by Willson Mach Payables, Payments & Cash Management
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 2 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system.How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system while integration. We don't want add as an attachment in the invoice, we n…Thanigainathan R 55 views 4 comments 0 points Most recent by Sunil Pradhan Receivables & Collections
-
The selected analysis object doesn't contain a list of people to assign the learningSummary: I have created a very simple BI Report, which includes person_id, Display Name and Job Name. I have applied a filter on the Job Name field to limit the data ret… -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
I am getting this error in bursting code ORA-01489: result of string concatenation is too long".Summary: I am getting this error in bursting code ORA-01489: result of string concatenation is too long". Content (please ensure you mask any confidential information): …Shiv Garg 11 views 2 comments 0 points Most recent by Vasanthakumar Ravi 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…Pradeep Moganti 11 views 3 comments 0 points Most recent by Tarika Jain1403 Receivables & Collections
-
Fixed Asset Additions/Adjustements Infotile datasource in OTBISummary: Hi, Where can we find this data for Fixed Assets in incomplete status, exceptions etc? Do we have an OTBI subject area to create this type of KPI/analysis? Cont…
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 31 views 2 comments 0 points Most recent by Saulo Salvador Reporting and Analytics for HCM -
Which table stores the Auditor Notes for Expense reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we exclude minimum amount receipts from AR Aging report (like -0.01)Our customer don't want receipts which has amount less than $1 in their AR aging report (attached ss for the same), can we exclude those receipts from this report? -
Empty per_person_secured_list_v and per_assignment_secured_list_vSummary: I have admin profile but secured views are empty. Content (please ensure you mask any confidential information): I have admin profile but the following queries …Stefano_Mazzocca 363 views 6 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm…Ramachandran Mani 21 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…Akash M Mahalle 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM