OTBI
Discussion List
-
Is there any possibility to get the user name who is executing the report otmHi Team, Is there any known way to reliably fetch the user ID of the person executing a report in otm ? I am currently using the following SQL to retrieve the user's pre…Mrugen Sunil Munshi 41 views 7 comments 0 points Most recent by Mrugen Sunil Munshi Transportation Management -
Can I query the values of a fixed list field created in OTM?Hello, We have a user-generated fixed list field in OTM's Order Releases, and I'd like to know if it's possible to query the values in that fixed list field, be it throu…
-
OTM BI Publisher - Run Report using Rest API or any other mediumDear Community We have a requirement where 3rd party application would like to run a report using REST API or any other medium (e.g. Webservices). We would like to know …
-
RTF file ConfigurationSummary: Dynamically Present non null column in table Content (please ensure you mask any confidential information): I am creating an RTF file using Word table with 3 fi… -
Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them?Summary: Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them? Content (please ensure you mask any confidential information): Version (include the ver…
-
How to configure Web Service Data Source Options in OTMSummary: I want to use Web service as a Data source in OTBI Content (please ensure you mask any confidential information): Hello, I am trying to paste the WSDL URL from …
-
Report ParametersSummary: Facing 2 Issue in OTM Parameters 1-How to insert Fixed List as I tried to insert text value, but report didn't run and showed up error. 2-When inserting query i…Tag Ahmed Elsharkawy 52 views 10 comments 0 points Most recent by AkshayThakur Transportation Management
-
How to link a parameterized BIP report into the OTM screenSummary: How to link a parameterized BIP report into the OTM screen Content (please ensure you mask any confidential information): we would like to link a parameterized …BALAJI K 12 views 1 comment 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Deleted order releasesSummary: I want to create a report of order releases that were deleted the previous day. Is this possible in BI Publisher? Content (please ensure you mask any confidenti…
-
Data Visualization: Is it possible to filter a Detail page starting from an Action?Summary: We created a Dashboard with Data Visualization which has a KPI section (Monitoring) and a details' section (Monitoring Detail). After that we created an action … -
Can't find DFF's Fixed values TableManager Layout > Choose the defined layout > Details (Tab) > Add Field > choose attribute > finish > select the field and click edit > check the fixed list value > add t…Ahmed Matar 14 views 2 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Convert the column in the report to a numeric datatype from VARCHAR.Summary: I have a requirement: the output of the report, including columns like net_amount_due, should have a data type in number format after extraction in excel. Conte…DataWhiz 42 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
BI Consumer role is not giving access to create data model in my folderWe are trying to give read only access to BI reports in OTM. We provided BI Consumer role to user by using which we able to access the reports and able to run. But we ar…vikram khengare 38 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
OTM Report extract as multiple tabs of a single Excel WorkbookWe have a requirement to generate an automated In-Transit Report using OTM for supplier ASNs. Since different suppliers have different in-transit mapping, we have create… -
Schedule a report with a hardcoded parameter for a parameterized report.Summary: I have a report with a parameter for start and end dates. Now, the user wants to have a scheduled report with hardcoded values, like April 1, 2024, as the start…
-
OTM-How to get dump of tables periodicallySummary: How can we get dump of followinbg tables on regular basis into our reporting environment which is outside of Oracle OTM? This is needed for reporting purpose. W…Hitesh Vashishtha 93 views 9 comments 0 points Most recent by Hitesh Vashishtha Transportation Management
-
How to find port of exit which is available on shipment table in transportation intelligenceHi, I am looking for port load or port exit date field which is available on shipment table of OTM in Transportation Intelligence analytics, but I was not able to find t…Kishore_Kumar 22 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Email From Address for Transportation IntelligenceSummary: Is there any way to configure the From Address for schedule reports/analysis sent from Transportation Intelligence? Content: We configured an Agent in the Trans…
-
Can we show OTM data in OTBISummary: Dear all, We were asked to evaluate the connectivity between OTM and OTBI. I.e., can we create a report in OTM FTI and call that in OTBI Content (required): NA …
-
Replay Event: SCM – OTM: New Analytics Subject Area - Transportation Operational IntelligenceSummary: SCM – OTM: New Analytics Subject Area - Transportation Operational Intelligence Content (required): Location: Replay Event Version (include the version you are …Maria Matheny-Oracle 52 views 2 comments 1 point Most recent by AnandSharma Transportation Management -
On the new OTM Transportation Intelligence Tool OAS (Oracle Analytics Sever) - QR Code generation?Summary: Can we generate a QR Code based on the shipment Id using OAS - within OTM transportation Intelligence. Customer is asking that the shipment id - should be conve…