To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…
-
Column label not showing in ArabicSummary: Column label not showing in Arabic Content (please ensure you mask any confidential information): Hi All, We got a requirement to change the company name in iSu…
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …
-
How to enable send icon in ESS job outputSummary: I have a question of how to enable the send icon in the ESS job output. Content (please ensure you mask any confidential information): Version (include the vers…
-
How to migrate OBIEE12c Agents as-is from old environmentSummary: We need to move over 1000+ automated agents from our test system (DEV) to our live system (PROD) in OBIEE 12c on Linux. Normally, when we move these agents, the…
-
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …
-
Subject Area to get details related to Maintenance Work definitionSummary: We try to create an analysis in Maintenance module to capture the Maintenance program with Work definition and operations and materials required for the Work or…
-
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…
-
Unable to access data from content serverI have a text attachment in work order operation level. I would like to print the contents of the text in work order traveler report. I would like to know how can I acce…
-
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …
-
Deleted contacts in AR Customer still appearing in TableSummary: Hi, I have created AR Customer and Customer Account, Site and Contact. When checking in Table using below query, it is working as expected. select * from HZ_REL…
-
BICC Not showing DFF FieldsSummary: Hello Team, BICC extracts are not showing the Shipment header and line DFFs which are configured in the system for the following seeded PVOs: - FscmTopModelAM.S…
-
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…
-
how to trigger seeded version of the report if we have customization in BI reportswe customized Print Movement Request Pick Slip Report, and it's getting printed when we submit Pick Materials for Work Orders Report process. we have a requirement to ge…
-
Web serivce API/SOAP to retreive item current cost and transaction cost by cost elementsSummary: Is there any API/SOAP to retrieve the item current cost and transaction cost by cost elements and not only total unit cost? Also, is the below API generated by …
-
Can a dynamic hyperlink be programmatically embedded within text in BI publisher report?We have a requirement to print attachments links in PO PDF report. The report should have the attachment name as a text, upon hovering over the text the hyperlink to the…
-
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the…
-
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that.
-
OTBI report timeout error how to schedule OTBI reportHi All, In the OTBI report, we have a large number of records. It was running for 25 minutes successfully with my user credentials, but when using another user's credent…
-
How can your report on Back dated receiptsDoes anyone know how you can report on back dated receipts FIN has allowed receivers to receive into the new year on orders for the previous year. the instruction is to …
-
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
OTBI is not showing Safety Stock Quantity values from Supply PlanningSummary: OTBI is not showing Safety Stock Quantity values from Supply Planning when using Supply Chain Planning Real Time subject area. Content (please ensure you mask a…
-
Subject Area 'Sourcing - Supplier Negotiations Real Time' Supplier Name absentSummary: A supplier negotiation has 5 invited suppliers listed under the section Suppliers. The indicator 'Restrict to invited suppliers flag' is YES. We would like to p…
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
Query for Workflow Details of NIRHi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Repor…