Category 129
Discussion List
-
UNSPSC Code HierarchyDoes there exist within ERP a full listing of available UNSPSC codes and its potential hierarchy? I am assuming this data is available within ERP but I can't see it if i… -
How to get Amount in Words in Arabic language in excel template with Saudi currencySummary: I have total eg: 21113.75 and it should show in output arabic of 'Twenty-One Thousand One Hundred Thirteen Saudi Riyals And Seventy-Five Halala'. I am able to g…Rahul K-Oracle 21 views 0 comments 1 point Started by Rahul K-Oracle Reporting and Analytics for ERP -
How to Restrict downloading URL Attachments by other Supplier in Fusion OracleSummary: My scenario is PO Lines are attached with documents for Supplier, using supplier portal login users are able to view/download other(supplier) attachments. This …
-
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 2 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be…
-
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 13 views 0 comments 1 point Started by Siva BVP-Oracle Reporting and Analytics for ERP
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …
-
how to use SQL to create otbiI have Created an sql query for BI report , but I want to convert it to OTBI analysis is there any way to achieve this ?Mohamed Abdelbar 31 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create a dashboard for a cash control budgetSummary: This document provides an overview of how to install and use the Cash Control Dashboard Content (please ensure you mask any confidential information): The Cash …Teresa McGoldrick-Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
sql query to fetch sales order(export order) related details from oracle fusionhow to get delivery mode(FOB,DDP etc), Exporter(To ship) address,fumigation status(YES/NO) and type of certificate required for a sales order export compliance from orac…
-
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 32 views 2 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP -
PVO DetailSummary: Im trying to get the detail of what this PVO is including (HcmTopModelAnalyticsGlobalAM.HcmRecSrcTrackingAM.SourceTrackingViewAllPVO ) , is there a good documen…
-
Query to get all item attachments in OTBISummary: I need a query to get all item attachments (images and documents) in OTBI. Also it's necessary to show item number associated to the attachments. I ask which it…
-
how to add multi line text using interface text in sandbox in oracle fusion applicationReplace multi line text using interface text in sandbox in oracle fusion application. output: Expectation: it should print 2 lines with a line gap i. Attach supporting d…Pooja K-Oracle 11 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime…Michael_B 31 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 2.7K views 16 comments 0 points Most recent by Charan K Reddy Reporting and Analytics for ERP
-
OTBI AP invoice report for approver, approval action date, payment dateSummary: We tried to build one, but the payment date is coming in incorrectly where it says it was paid before the invoice was even created. Anyone successfully build su…Alex Glose 1 view 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
FRS YTD HTD instead of Month/QuarterSummary: We are designing a new report with BU Assets and its balance. We see the dimension as Year, Quarter and Month. Is there any way we could use the option HTD (His…
-
BICC 24 Version BICC Mapping DocumentSummary: Please share the Rel13_24.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zip Mapping Document Content (please ensure you mask any confidential information):…SYARABOLU 32 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 41K views 126 comments 29 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
What tablle gives the solicitation response historyI am looking for data under analyze →view response history on the solictation page
-
Oracle BIP Report Not SummingI need your help in my RTF template that has a sum for every each segments. I added the field in the cell, set the Calculation to Sum and checked the Grouping. Generated…Sofia Danielle Sarmiento 11 views 0 comments 1 point Started by Sofia Danielle Sarmiento Reporting and Analytics for ERP
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …Octavio Aguirre 11 views 6 comments 0 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Connect GL Location Segment to Location AddressHi, we have Locations in Oracle we need to associate with the Location Segment in the GL Account String. Scenario: We have Account Aliases we are using to decrement our …Becca Edwards 34 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …
-
Which Oracle DB packages are provided in BIP datamodels?Summary: Hello, actually we are looking for an Oracle provided db package with a standard function to convert item weights between item_weight uom codes. I want to use t…Frank.Steinjan 52 views 5 comments 3 points Most recent by Frank.Steinjan Reporting and Analytics for ERP