BI Publisher
Discussion List
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana Kondaveeti 6.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Getting insufficent privledges error when executing SQL in Data ModelWe are trying to create a report that shows bursting queries scheduled in our system. The code was found here: Document 2210437.1 The SQL code we are trying to execute i…Christopher Hitchcock 35 views 4 comments 0 points Most recent by Christopher Hitchcock Reporting and Analytics for HCM -
Not receiving emails from bursting querySummary: We are trying to develop a bursting query to send email notifications, but are not receiving any emails though the report job shows to be successful. Content (p…
-
Report or table details for Chart of account listing values for natural account in General LedgerSummary: Hi Team, I have to create BIP report for COA listing values for Natural Account in General Ledger as per attachment. I am looking for table details or query to …ManishaPatil 34 views 3 comments 0 points Most recent by ManishaPatil Reporting and Analytics for ERP
-
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 92 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
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…
-
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing? https://us.v-c…Harish B Choctaw 46 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 148 views 6 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…
-
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh…
-
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View…
-
Report to view unprocessed IDR InvoicesSummary: I have a requirement to create a report to show all unprocessed IDR invoices. Is there a table that provides this information? Content (please ensure you mask a… -
Best Practices for OTBI Reports Handling Large Data VolumesSummary: Hi everyone, I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data. Is there a recommended st… -
Clarification needed for VAT Liquidation Report ItalySummary: Hello All, We are looking for a solution to customize the seeded report 'VAT Liquidation Report for Italy'. The report requires certain modifications/additions.…
-
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…Sean-B-01 14 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP report only bursting to default printerHi Team, I have bursting logic in my BIP report to burst the output to different printers based on a lookup. If the selected printer is set as default printer in Adminin…
-
in Payment Files using SWIFT MT103 file format, how do I get 2 zeroes for the Decimal?I have an issue with regards to the decimal of the PaymentAmount/Value field. Below are the details of the field. Length - 2 Format - Number, Decimal Data - PaymentAmoun…
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 1 view 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Data Roles and Security Profiles - Unable to find 'STATUS' column for BI reportsHello, I’m currently working on a report related to Data Roles, and I was wondering if anyone here has worked on something similar or knows which table/column stores the…
-
Help with this error when trying to create offer "There was a problem creating the job offer..."What is the solution to fix this error when trying to create new offer? Have already tried reloading the template.Sara EW 126 views 1 comment 0 points Most recent by Erika B-Oracle Recruiting, Opportunity Marketplace
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 1K views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 2K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Goal Approval workflow notification issue with CLOB type data which have > or < symbol ?Summary: Goal approval workflow notification is having success criteria field where field is having below combination of text : 7800 and when notification triggered and …Ankur Jain--Oracle 1 view 0 comments 0 points Started by Ankur Jain--Oracle Reporting and Analytics for HCM
-
Add a document outside fusion which can be sent to customers using Print Receivables Transactions.Summary: We have a requirement where an additional document is required to be sent to customers along with the AR Invoice. This document is outside Oracle Fusion. Need t…Shefali Lakhani 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Public IP Address?Summary: Hello, our data team is interested in using SFTP to have the ability to automate reports from Oracle to our dashboard and have real-time updates. However, our I…B_Meiling 57 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration