BI Publisher
Discussion List
-
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…Neha_C-Oracle 111 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to execute BIP report and get a PDF file by calling SOAP web service ?Summary: How to execute BIP report and get a PDF file by calling SOAP web service ? Content (please ensure you mask any confidential information): BIP reports were run u…
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 1 view 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 91 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 82 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 50 views 12 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req…Sunil Pradhan 134 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Chinese letters turning to special character when extracting via CSV BIPHello Oracle, Is there a way to adjust the output character set when extracting a BIP Report (Oracle BI EE Data Source) to CSV? We are having issues when extracting Chin…Ralph Aldrich Magno 21 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…PrerakKhandelwal 31 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
SQL Query to get Scanned Invoices as mentioned in UI PageWe would like to get SQL query for Scanned, Hold and Paid Invoices as mentioned in UI Page. Please find the below screenshot for more details. Also, we have SQL queries …Chandana Priya-Oracle 141 views 9 comments 0 points Most recent by AllenN Payables, Payments & Cash Management
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.3K views 6 comments 1 point Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…Ellen Manthei 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas…Dae 91 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL TableHi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle…
-
Need API for Lookup type PAY GROUP in Manage payables lookupsSummary: Hi Team, Do we have any REST API to get data for the lookup type for PAY GROUP under Manage payables lookups ? We found one API for this is not working to get f…
-
How to link xla_distribution_links with fa tables to get the catchup depreciationSummary: How to link xla_distribution_links with fa tables (Depreciation, Transactions, Adjustments) to get the catchup depreciation (link other than event_id) to find d…
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Transfer Customer Payment on Bill Management Portal to BankSummary: We are looking to transfer Customer Payment (Bank Method) on the Bill Management Portal to the Bank. Does anyone have any such integration experience with Wells…Suprit 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there …Parag Hiremath 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 261 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
Export Learning Certificate using APISummary: Hi, We have requirement to export the learning completion certificate from oracle and send it to a third party system via integration. Content (please ensure yo…