Category 174
Discussion List
-
Need SQL query to extract Agreements and the assigned Requisitioning Business unit namesSummary: Purchase agreements with assigned Requisitioning Business unit names extract Content (please ensure you mask any confidential information):Need SQL query to ext… -
BICC DFF extract sales order header and linesNeed to extract Sales order header and line data from tables DOO_HEADERS_ALL and DOO_Lines_ALL. I am able to get this using BICC extract into UCM server. But DFF columns…Alok K Gupta 224 views 10 comments 0 points Most recent by Aniket Jadhav Reporting and Analytics for SCM
-
Not seeing 'Create Infotiles' button in sandbox and edit pagesSummary: Not seeing 'Create Infotiles' button in sandbox and edit pages Content (please ensure you mask any confidential information): Created a sandbox 'Page Template C…Viswanadham Sighakolli 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 14 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
sending email for bursting not workingHi . I create the Bursting process for an user. In the first step i created the query bursting in the data model : In particulary the parameters for my the Bursting quer…Michela A. Morgillo 72 views 5 comments 0 points Most recent by Michela A. Morgillo Reporting and Analytics for SCM -
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
Access the standard BIP report extracts via APISummary: Hi Team, We have a requirement to fetch and place the standard BIP extracts from UCM to some file server. example, once the ap invoices import process is comple…
-
Label printing on Brady Printer shrinking the size of labelSummary: Label printing on Brady Printer is shrinking the size of label. We successfully printed a label, but the printer scaled down the dimensions. It printed only 3 c… -
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 37 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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 133 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 21 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 55 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 16 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 35 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 2 views 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 22 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 21 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 12 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 …