BI Publisher
Discussion List
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 44 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management -
Where can I find Talent Review Columns of Task Subject, Task Status, Task Owner and Task Due Date?Summary: In what table can I find Talent Review Columns of Task Subject, Task Status, Task Owner, and Task Due Date? Content (required): Here is a brief description of t…Basti 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Looking for Department column which contain value of PSSR Requisition DFFhttps://us.v-cdn.net/6034893/uploads/CLUU6PV3IEH7/department-column-step-by-step-doc.docx https://us.v-cdn.net/6034893/uploads/3J6ABUS2ZEIC/department-column.docx Summar…Pooja_123 21 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to include attachments from the main transaction page into a custom reportHello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages one is t…Gurupreet S 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 270 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Query that fetch Grade Rate Value for a certain personSummary: Hello! I need help to get a query that passing the assignment_number of an employee I can get the value field of a Rate Value inside the Grade of a person. Exam…Matheus Roberto 127 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (…Consultant Ian 111 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 41 views 5 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM
-
is there any rest api to get all rejected ap invoices?Summar Summary: Is there a REST API available for fetching all rejected AP invoices? If yes, how can it be utilized? Content: [Please provide any relevant information] V…Nikhil Pande 11 views 1 comment 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
Hide Diagram tab in Data Model for the BIP report for users with particular fusion HCM roleSummary: Hide 'Diagram' tab in the Data model for users with particular fusion HCM role Content (please ensure you mask any confidential information): There is a require…Girish_Kulkarni_123 11 views 2 comments 0 points Most recent by Girish_Kulkarni_123 Reporting and Analytics for HCM
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
Modified payslip Data model bursting is not workingSummary: We are trying to achieve the requirement to send payslip for ex-employees over personal email address, Below is the custom bursting data model that we modified.…Rama123-Oracle 11 views 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM
-
Is there a way to add field in Edit distribution feature on the BPM notificationIs it possible to pull the accounting date field into the BPM notification and make it editable when using the edit distributions feature on an invoice notificationAkanksha Bhardwaj 31 views 5 comments 0 points Most recent by Tara Ebarb Payables, Payments & Cash Management -
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 202 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Data access issue with HZ_LOCATIONS tableSummary: I am trying to troubleshoot an issue with a custom BI Publisher query. The report works just fine for some users, but for other users it never finishes and time…Chris Mansfield 41 views 2 comments 0 points Most recent by Chris Mansfield Reporting & Analytics for Sales
-
How to add attachment to bursting?Summary: How to add attachment to bursting? Content (please ensure you mask any confidential information): I need to add a zip file to an email sent via bursting. Where …Stefano_Mazzocca 62 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 31 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Locking the Receivable Invoice Form based on DFF ValueSummary: There is a requirement where I want to lock the receivable Invoice based on the DFF value. The scenario is, If the DFF value shows the In-process status of bein…
-
Expenses Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked the following 2 questions by one of our internal auditors, specific to the Expenses Module: List the specific tables and fields where the employ…
-
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…DebayanB 82 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…Aishwarya_15 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 21 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How does the Financial Tax Register(FTR) report works with the following parametersSummary: How does the Financial Tax Register(FTR) report works with the following parameters : Reporting Level : Ledger Reporting Context : Ireland USD Reporting Ledger …Yasasree Boosireddy-Oracle 141 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Tax & Global
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 123 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM