BI Publisher
Discussion List
-
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 122 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 13 views 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM
-
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 201 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 61 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 85 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 152 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 124 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get organization ID and name of bank statement data?Summary: We are trying to create custom BIP report that would output the bank statement import errors and successful data. Among the fields required by client was to add…Patricia Azucena 11 views 1 comment 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Globally Change User Timezone Preference in OTBISummary Is there a way to globally change users' timezone preference in OTBI?Content Hi! I am wondering if anyone knows if there is a way to globally change the OTBI tim…Lindsay Lamont 73 views 8 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM -
REQUESTED_FOR_PERSON_ID Foreign key for BI ReportSummary: REQUESTED_FOR_PERSON_ID Foreign key for BI Report Content (please ensure you mask any confidential information): Hi, we would like to create a report which prov…Barile Alberto 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.2K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Run report REST API for Oracle BI PublisherSummary: I'm trying to run a BI report and get the output via this REST API: /services/rest/v1/reports/{reportPath}/run I tried running it but is getting 404 not found e…JEngalan 182 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections