BI Publisher
Discussion List
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 139 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
Does anyone know the Oracle BI Publisher Notification can be customized or notDear all, We would like to teach the user to schedule the report, however, does anyone know if this "Job was successfully processed" notification can be customized or no… -
how to pass dynamically the flow name and instance Id from HCM Extract to SFP FileSummary: In an HCM EXTRACT, We enabled SFTP bursting need to save the file name with flow instance name and flow instance Id dynamically in SFTP server when we ran the e…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…
-
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?Amit Dey 12 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…Ankurzen 461 views 7 comments 0 points Most recent by Ashok Pavithran Reporting and Analytics for ERP
-
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.3K views 12 comments 0 points Most recent by Lisa Carter Reporting and Analytics for HCM -
How to remove the USD from the Email notification report in Expense module?Hello, We require your support regarding an issue with the Expense Report approval email notification in Oracle Fusion Expenses. Currently, when an expense report is sub… -
SQL query for item master and functional catalog assignmentsSummary: We have a requirement to develop a report to fetch a list of items with catalog and category values. Content (please ensure you mask any confidential informatio…Mamdouh Ahmed 51 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…Akankshya Jena 101 views 3 comments 0 points Most recent by Gangadhara S Ariga Receivables & Collections
-
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…Aseef Babujan-Oracle 24 views 5 comments 0 points Most recent by Rohit Mali - API Wizard Reporting and Analytics for ERP
-
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. '…
-
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…Pritam Das 22 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to give access to Learning reports onlyHello, Do you know if there are any privileges/ duties for Learning reports? We have couple of users (HRBPs) who need to see how many employees completed a specific cour…
-
Sourcing BIP: Cannot fetch multi option supplier bid responsesSummary: We need to create a custom reportfor the supplier requirements bid, in Sourcing. To achieve that, we are creating a report on BIP, having the RFP number and Bid…Sergio F Oliveira 42 views 5 comments 0 points Most recent by Naveen_CCC Reporting and Analytics for ERP -
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 3 comments 2 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM
-
Custom Approver Logic in BPM – Validating User Email/Access via BIP or Alternative ApproachSummary: In Oracle Fusion BPM, approval routing is typically based on predefined rules such as user, supervisory hierarchy, AOR, or role. However, we have a requirement …
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 2K views 9 comments 1 point Most recent by AnushaDB-Oracle Reporting and Analytics for HCM -
In which table candidate position stored?Summary: I am looking for HCM table in which canidate position information stored ? Content (please ensure you mask any confidential information): Version (include the v…manish_kumar 13 views 3 comments 0 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM
-
Getting Invalid format excel format requested error using RTF templateSummary: Getting Invalid format excel format requested error using RTF template Content (please ensure you mask any confidential information): Hi, I have a report that I…Pritam Das 36 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 44 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 82 views 4 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 …
-
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 …
-
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 53 views 4 comments 0 points Most recent by Ramachandran Mani Reporting and Analytics for HCM