BI Publisher
Discussion List
-
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 11 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 11 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.4K 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 161 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 208 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
-
Unable to pull unencrypted bank account details through view iby_ext_bank_accounts_vWe need to share the unencrypted unmasked Bank Account data of certain suppliers. But when we use the View IBY_EXT_BANK_ACCOUNTS_V to get the CLEAR_BANK_ACCOUNT_NUMBER f…AbdulBasith 136 views 3 comments 0 points Most recent by Srinivas Nimmalapudi-Oracle Payables, Payments & Cash Management
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 892 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is …
-
Send copy/information of Printed invoices to specific recipient within the organisationContent When printing invoices and sending them through email we have a requirement for also notifying or sending the same invoice to a specific person within the organi…Stefan pettersson 185 views 2 comments 1 point Most recent by Hemal Maniar Receivables & Collections
-
Banco de Chile Electronic Payment File FormatHi, Can anybody share here "Banco de Chile Electronic Payment File Format"?CA Nirmal Choudhary 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management