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
-
Regarding po receipt invoiced is 0I need to extract those receipt line invoiced column having 0. Could anyone please help me on that. Below screenshot for reference purpose. -
SQL query to get the Item Category HierarchySummary: SQL query to get the Item Category Hierarchy Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…
-
Is it possible to access ATP DB table in AnalyticsSummary: Could access ATP DB table in Report Analytics catalog to build SQL Query data model Content (please ensure you mask any confidential information): Version (incl…
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…
-
How do I find the Submit Request Window to run a Buyer ListingI need to submit a Buyer Listing but I do not know how to get to the Submit Request Window?
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…
-
Query/Table to find the below highlighted fields Configure Supplier Outbound Synchronization ServiceCould you please in finding the above columns? -
On Update 23.R4 SQM is noted as future roadmap itemSummary: On Update 23.R4 SQM is noted as future roadmap item. Is timeline available for this functionality? Content (please ensure you mask any confidential information)… -
Period Inventory Valuation Report has no RecordsSummary: Period Inventory Valuation Report has no Records Content (please ensure you mask any confidential information): I am trying to run the Period Inventory Valuatio…
-
ORDER MANAGEMENT ANALYSISSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query to get the Serial Number of Shipment number for PO in CloudNeed to find the serial number used in shipment for purchase order when we pass shipment number. select rsl.line_num, rsh.shipment_num, poh.segment1 as po_number, pol.it…
-
BI Publisher Notification - PO ApprovalSummary: I have amended the BI Publisher approval but only certain users see the body of the notifications, others just get an attachment and approval buttons Content (p…
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…
-
How To restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…Susmitha Arepally-Oracle 198 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
How to provide a Procurement Requester access to OTBI report creation?Summary: How to provide a Procurement Requester access to OTBI report creation? Do we create a custom role and add the BI Author role? Is there a privilege which governs…
-
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…
-
SHARING OF OTBI REPORTHello and good day! Dear Oracle community friends, If a user has limited access to other modules (e.g. Procurement and Inventory Management users) and one user in that m… -
Can i get the Database lineage document for 23DSummary: Can i get the FSCM Database lineage document for 23D Content (please ensure you mask any confidential information): Version (include the version you are using, …
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…
-
where can i find posting_type columns in scm tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…
-
DIGITAL SIGNATURESSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
change orderSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query for Sales Order Contact at header and line levelSummary Query for Sales Order Contact at header and line levelContent Can you please share the query to get the customer Bill_to and Ship_to contact details at header an…
-
Need to see BPM Approval Flow in OTBISummary: I am trying to create an OTBI report and would like to see the BPM approval flow from OTBI report. When trying to figure out who approved the requisition, since…
-
AuditSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…