Category 174
Discussion List
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Customising Datamodel of (seeded) Sales Order ReportSummary: How can we customise the Datamodel of the (seeded) Sales Order Report? Content (please ensure you mask any confidential information): The Sales Order Report is …Frank.Steinjan 117 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
ODI Marketplace integration with SharepointSummary: Team, do we have any possibility of connecting ODI with SharePoint for data exchange. Has anyone on the team encountered this need before? can you please share …Viswanath-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Serials in Transaction History for PO Receipt Number – SQL Query Adjustment NeededSummary: Hi Oracle Support, I am using the query below to retrieve serial numbers for receipt 30148, but it does not show all four serials as seen in the Transaction His…
-
How to import a Order Management data to Fusion Data Intelligence from Oracle cloudSummary: We have a FDI installed in a customer, but we don't find the Order Management data to load in the FDI We found only Financial Analytics, Procurement Analytics, …Alex Pagliarini - Ninecon 23 views 2 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 53 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
QR CODE not WORKING in SCHEDULE ESS job BUT WORKS WELL in report.Summary: qr code not working i get blank data when i scan qr in scheduled ess job for report but works well when i run report through open button in report in oracle fus…Raoof Ahmed 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
qrcode with blank data printed while report is in bursting workes well without burstingSummary: scheduled report and qr code in it works well when the output is not bursted but when we burst the output qrcode with blank data printed whole report output and…Raoof Ahmed 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ESS Job to default the output to Email address when submitting the job on demandSummary: Hello ! We have a BI report as an ESS Job, the requirement is to default the email address and the subject and the BI report output (XLS) in this case needs to …vivek.clement 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Date and Timestamp Datatypes from metadata for PVOSummary: We are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata). However, some columns are labeled a…Alex25 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can we get ZPL output for Zebra Printer from Oracle BI PublisherSummary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidentia…Sandipan_Chakraborti07 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Need a Query to build a BI report to get the details on exceptions table from supply planning cloudSummary: I am trying to build a BI publisher report to extract data from exception table as per our requirement. Could you please help to find a way to get the query/tab…NaveenBellam 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
where can i find receiving and inbound quantity's for on hand reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_3KQOD 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Purchase requisition and purchase order Comparison ReportSummary: I want to create a query to retrive PR Amount and PO Amount Associated with It and return difference between them Content (please ensure you mask any confidenti…Mohamed Adel53 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
DFF field should autopopulate based on the other field(actual field from UI)Summary: We have created a DFF field in Invoice header page under additional information tab. The business requirement is , we need to populate the list of values for th…Chandana Priya-Oracle 13 views 1 comment 0 points Most recent by Chandana Priya-Oracle Payables, Payments & Cash Management
-
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…Ramya Dev 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobsSummary: Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobs Content (please ensure you mask any confidential information)…
-
Query to get Inventory valuation quantitiesSummary: I am looking for the query to get the inventory valuation quantities based on inventory organization. When we view the data for a period for a cost organization…
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
You can add the item description in landed cost when associating the line with the purchase order,Summary: You can add the item description in landed cost when associating the line with the purchase order, although when managing the columns to add that description fi…
-
OTBI REPORT data retrieval for certain fields is not functioning as expected.Summary: I have developed an OTBI report for movement requests. I didn't get any data for the column "LEDGER AMOUNT". how to resolve this Subject Areas Utilized for OTBI… -
Need Unmasked Bank Account Number in Supplier PVO in BICCSummary: There are two columns in Bank Account tables, one for masked bank account number and another for unmasked bank account number. But in BICC, Supplier/Supplier Si…Sreeram Tadepalli 47 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to access and print attachments in Quality Action/Issue ReportSummary: We have a new business requirement where they want a report that lists/print all the attachments of each Quality Action/Issue available in Attachments section. …
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …KTbsa1234567 92 views 2 comments 0 points Most recent by KTbsa1234567 Reporting and Analytics for ERP
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 64 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 178 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
ORA-00932: inconsistent datatypes: expected DATE got NUMBER in SQL data model per KM 2888420.1Summary: When trying to use the SQL provided in KM Fusion CST: SQL Running Behind Analyze Standard Purchase Cost Variances (Doc ID 2888420.1) i am getting an error in th…Maria Angelica Mendoza 193 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 122 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM