BI Publisher
Discussion List
-
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 81 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 52 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 131 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 33 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 143 views 9 comments 0 points Most recent by AllenN Payables, Payments & Cash Management
-
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 2 views 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 23 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 265 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… -
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Can we integrate 2 LinkedIn accounts for same user with oracleSummary: Can we integrate 2 LinkedIn accounts for same user with oracle Content (please ensure you mask any confidential information): Can we integrate 2 LinkedIn accoun…
-
Do we have a delivered NACHA Format template for Fund Disbursement in Customer Payment?Summary: I am looking for a NACHA Format template for Fund Capture that can be used as a reference for customization. I am only able to see the NACHA Format available fo…Suprit 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Oracle Fusion Cloud Sustainability posibility to report via OTBI/Subject AreasThere is a module available for all ERP customers where you can store sustainability data. Created via AP invoices or imported via external systems. This is something th…AnnelizeHenskens 1 view 2 comments 0 points Most recent by AnnelizeHenskens Reporting and Analytics for ERP