BI Publisher
Discussion List
-
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 45 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 23 views 3 comments 2 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM -
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 2.1K 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 22 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 89 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 47 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 80 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 75 views 4 comments 0 points Most recent by Ramachandran Mani 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…
-
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
-
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 65 views 4 comments 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 …
-
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,…
-
Sending the clearing date instead of payment date as part of BACS payment runSummary: BACS has 3 days of clearing cycle. My client has a specific requirement to select the day 3 in the payment date column while running the payment run. This is to…Pranshu Todaria 25 views 3 comments 0 points Most recent by Pranshu Todaria Payables, Payments & Cash Management
-
Escheatment Processes with a Payment Process Profile Configuration Value of 'Electronic'At my current client, they are asking for Escheatment Processes. The only way Escheatment processes can be achieved is using a Payment Process Profile with a processing …Andrew Thiele 20 views 0 comments 1 point Started by Andrew Thiele Payables, Payments & Cash Management -
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20AUser_2025-02-05-04-17-04-394 439 views 6 comments 0 points Most recent by Derrick Ellis Reporting and Analytics for HCM -
Required Table to get "Add Organizations to Tree" under Manage Project Organization ClassificationsSummary: We are unable to get the right table where the Add organization tree information stored. We tried to link the table PER_ORG_TREE_NODE_RF, PER_ORG_TREE_NODE, FND…
-
How can Fusion BI Report generate two different PDFs for same data at each ESS run.I have a requirement where my report should have two outputs one with all price columns other without for same data. Based on my bursting logic I can generate two emails…
-
Issue with a date column in customized Asset Register report in Oracle FusionHi, We customized the Fixed Assets "Asset Register" report. There's a date column whose logic is as below. (SELECTTO_DATE(TO_CHAR(fcp.end_date, 'MM-DD-YYYY'), 'MM-DD-YYY…
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Table or logic to find Account Coding Status in ap invoicesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Prasadreddyv 13 views 2 comments 0 points Most recent by Gaurav Kumar-100036 Payables, Payments & Cash Management