BI Publisher
Discussion List
-
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 1 view 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM -
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de…
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 53 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
Back-end table for Vacation Rule delegation and Task delegationHi Cloud Community, We have an audit requirement to get details on the Vacation Rules set by the user and based on the certain criterion it will be marked as compliant /…Tushar_Singhania 57 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 8.4K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM
-
Are there any fusion tables that store the Daily Amount and Days on ExpensesAs in "Expenses - Expense Transactions Real Time" Subject Area Daily Amount and Days these fields are not present so is there any fusion table where we can get these det…
-
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data …
-
Feasibility to update the path of the customized report in HCMSummary: Hi, Actually, there is a functional configuration done in HCM where we have option to select the templates basically report templates to generate the report. In…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 21 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP
-
Does SFTP setting done in Production is copied over to non-production environment during P2T?Dear Experts, Can someone let me know if SFTP setting done in Production is copied over to non-production environment during P2T? Please share oracle documentation for r…B S Rafatullah-Oracle 14 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex…
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 162 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP
-
How to use round and sum in ctrlsum tag in oracle payment fileSummary: We need to show total in ctrl sum below. ex. payment1 : $100.1 ,payment2 : 100.4 the payment amount to show 100 and 100 as we doing round off. ctrl sum should s…harshalda 61 views 1 comment 0 points Most recent by Lakshmi Reddy Kishtipati Payables, Payments & Cash Management
-
Manually uploaded attachments to invoice is not showing in UCM , even though have all the privilegesSummary: Manually uploaded attachments to invoice is not showing in UCM with CS attachment ID, even though have all the privileges and roles. For IDR invoices am able se…sindarapu 14 views 2 comments 0 points Most recent by Aleksandra Bykhan Payables, Payments & Cash Management
-
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for…Shikha Agarwal 1.6K views 6 comments 0 points Most recent by user11977061 Reporting and Analytics for HCM -
Custom LOV search in ESS JOB is not case insensitiveSummary: Hi All, Is there a way to make the LOV search case-insensitive? I have an LOV for Supplier Name. When the LOV popup appears, users can enter a name in the searc…RupaliGahalot 174 views 16 comments 1 point Most recent by Ashwani Kumar Mallia Reporting and Analytics for ERP
-
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 41 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
What would cause a journal batch to go from STATUS_VERIFIED='Y' to STATUS_VERIFIED='N'Hi Guys We have a BIP report based on journal batches/headers/lines developed by an outside consultancy that has the filter below on it: GJB.STATUS_VERIFIED='Y' All good…
-
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST …
-
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 201 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
packages for extending attributesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raj Koppanathi 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we set up the course completion certificate, for specific courses .Summary: Can we set up the course completion certificate in a way where, the employee is awarded the certificate for specific courses . Content (please ensure you mask a…
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 11 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany