BI Publisher
Discussion List
-
Need a query to pickout the balances details in Oracle HCM fusionHi All, Our requirement is to get the balance details of the following balances based on the employee details for a pay period. can you please share the code for that. '… -
Static IP for sftp connectionSummary: Do you know if Oracle can use a specific IP address to transfer data to the SFTP server? We have configured a connection to the sftp server via OTBI/BI Publishe…Daniel Sobotka 33 views 2 comments 0 points Most recent by PrincipalCharlesM Payables, Payments & Cash Management
-
Transaction Approvers Comments ReportSummary I am preparing a report to fetch Transaction details along with Approver comments which we can see in Transaction console.Content Hi Team, I am facing a problem …User_OWH0W 81 views 4 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
AI Agent Audit ReportSummary: Two different BI Publisher reports to track AI Agent usage by end-users and administrators. Summary Audit Report that audits a completed conversation from a pub…Race Schreimann-Oracle 162 views 6 comments 1 point Most recent by Keith McAdoo-Oracle AI for Fusion Applications -
This is the HDL I have loaded and getting errorSummary: Getting issue while loading this HDL for Withdrawing learning assignments.…
-
AR seeded deferred revenue report without RMCS being used or how are you doing it?Summary: Is anyone aware of an AR seeded deferred revenue report without RMCS module being used. Content (please ensure you mask any confidential information): As we hav…
-
I need to find a way to Audit who deleted a folder in Reports and AnalyticsWe are live on Oracle Fusion, and we have a bunch of Reports and Datamodels in Custom folder in Reports and Analytics. Someone deleted one of the folders and we need to …
-
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y…Guillaume SAVALL 141 views 7 comments 0 points Most recent by Jeeva - Cloud Vantage Reporting and Analytics for HCM
-
Unable to search employee on Assign Learn?Summary: Unable to search employee on Assign Learn? I have followed below steps , didn't resolved the issue. Add the PER_ENABLE_WORKER_SEARCHES_USING_EFFECTIVE_DATES_PRI…
-
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…Mounika-Oracle 31 views 4 comments 0 points Most recent by Mounika-Oracle Reporting and Analytics for HCM
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
Payslip is not sending to FTP through Payslip ExtractHello Team, Greetings of the day!! In seeded Payslip Extract, we have an additional delivery option which will send the Payslip XML data to FTP and it is working fine ea…
-
how to merge data from 2 different data sets into Etext template in one line?Hello, I am creating a Etext template using seeded data model globalreportsdatamodel. I am adding fields from 2 different datasets so in the output it is not showing in …
-
query that fetch failed transactionSummary: SELECT * FROM ( SELECT DISTINCT HTCE.TRANSACTION_ID, HTCE.PROCESS_CATEGORY, HTCE.OBJECaT_NAME, HTCE.CREATED_BY, papf.PERSON_NUMBER, ppnf.FULL_NAME, TO_CHAR(HTCE…Bindiya S.K 11 views 2 comments 2 points Most recent by UchihaItachi Reporting and Analytics for HCM
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti… -
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When…Guy_Ora 51 views 4 comments 0 points Most recent by Ramachandran Mani Reporting and Analytics for HCM
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?
-
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…Sara Suleiman 41 views 3 comments 0 points Most recent by Alice Gouzy Reporting and Analytics for HCM
-
We want to know max file size support for Invoice PDF file in Print Receivables TransactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Learning report(Specilization,course,offering and activity details - data issue)Hi Team, Please find the attached report columns. Could you please review them and let me know if it is possible to build a BI Publisher (BIP) query to retrieve these co…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
Requirement to have Receivables Invoice to have200 Reference Values (attributes) that can be printedSummary: Requirement to interface Receivables Invoices from an external system into Oracle Cloud via OIC, including approximately 200 reference attributes per invoice tr…
-
requesting the underlying database tables or query used to retrieve receipt accrual clearing rulesSummary: Requesting the underlying database tables or query used to retrieve receipt accrual clearing rules, including associated ruleset and criteria details, filtered …Fusion BI Reporting 1 view 0 comments 0 points Started by Fusion BI Reporting Payables, Payments & Cash Management
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2.1K views 11 comments 0 points Most recent by Raktim_Pal-IBM Reporting and Analytics for HCM -
Customization of Create Customer Statements: Generate Log(unable to edit dataset)Summary: We have a requirement to add the receipt date and receipt number to the standard 'Create Customer Statements: Generate Log' report. We're trying to achieve this…VENKATA SWAMY BATHINA-Oracle 51 views 4 comments 0 points Most recent by Nagarjuna Nudurupati Receivables & Collections
-
How to customized Create Customer Statement Report?I need help in customizing Customer Statement Report. How to create custom ESS job?MayuriMMote 11 views 1 comment 0 points Most recent by Nagarjuna Nudurupati Receivables & Collections
-
No email notification after Payment Process Request in DEV (Expense Reimbursement)Summary: Not receiving email notification after Payment Process Request (PPR). Content (please ensure you mask any confidential information): After submitting a Payment …
-
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…