BI Publisher
Discussion List
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.4K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Generate SAFT Data ExtractHi, We got some of the requirement for SAFT data extract report. For that we need to customize the SAFT extract. But we observed this report is of JAVA job type and we n…
-
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
Expense Approval Report - how to show stops in between destinationSummary: Content (please ensure you mask any confidential information): Hi all, I have been trying to modify the seeded Expense Approval Report by adding any stops taken… -
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 1 view 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 28 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Third-Party Control Account Balances Report - Include Zero Amount BalancesHello, In the Third-Party Control Account Balances Report there is a parameter with name "Include Zero Amount Balances", you can select either Yes or No in this paramete… -
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 255 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
BIP Report timing out for select Associates in-consistentlySummary: This report is run by about 165 associates. Almost 80% of runs are successful where others are getting “Time out error” for rest. It’s not consistent, though. C…RajeshPatil-67 12 views 0 comments 0 points Started by RajeshPatil-67 Reporting and Analytics for HCM
-
Report to identify employees with corruption in "PER_PERSON_NAMES_F" tableSummary: Hello, We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused er…
-
Table/query to get Corporate Card Transactions payment and expense report detailsSummary: I am looking for a query/table details where I can get to know whether the corporate card transactions are in expense report or not and the transactions are pai…
-
Restricting BIP Data Model to signed in userSummary: Trying to use the data model to restrict the signed in user to only their information in projects. I'm trying to do this so that project managers when the open …
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
how to restrict person details post Global transfer in extractWe have an HCM extract with PER_EXT_PAY_EMPLOYEE_UE. After a global transfer of any record, there may be changes in person address, SSN of a person. for example, US to C…
-
how to rename column name with column values from another table in SQLSummary: Hi, I am looking for a way to update the column names of table a with column values from table b. For example: How to achieve this Content (please ensure you ma…
-
BIP Security - Need to restrict user from deleting the Folders from Shared FoldersSummary: Hello All We would like to restrict the users from deleting the folders from shared folders and user should be able to run and schedule the reports and data mod…ROHIT NAYAK_120 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Bullet points formatting getting changed during output of bursting BIP reportSummary: We have bursting report which sends email notifications. We have designed the RTF template and providing some instructions like below format. But while sending … -
Customization of Bank Statement ISO Processing Report (CE_ISO20022_2) CLOB FileSummary: Content (please ensure you mask any confidential information): We would like to customize the seeded bank statement template to include an additional attribute …
-
New record character in eText Template does not workI am creating a BIP report using etext template and filled in the format setup table in the template like the image below. (New record character: Carriage return) But wh…
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 767 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…Tamseel Aijaz 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…User_6U8NQ 399 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM
-
Transactions Print Data Model Lexical ReferencesSummary: Content (please ensure you mask any confidential information):In the data model Transactions Print, we added a custom line of code to the Header data set and up…Rory Mullin 40 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
../ directory path reference tag in RTF is not working properly in BI Analytics.Summary: ../ directory path reference tag in RTF is not working properly in BI Analytics. Content (please ensure you mask any confidential information): We are using the…
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin…Valerio Curzi 21 views 7 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 21 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM