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
-
Manage Supplier AuditsCan you help me in finding the above columns? -
Query/Table to find the below highlighted fields under Configure Supplier Outbound Synchronization?Can you help me in finding the above columns?
-
how to fetch historic on hand quantity correctly using new views provided?Summary: Historic On hands quantity Content (please ensure you mask any confidential information): Currently given views are not supporting historic data. Decommissioned… -
Report to show PO with its contract and RFQ detailsHello Team, I need to create a report which gives PO details and the contract / RFQ based on which those are created. I have found the below tables, please confirm if th…
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh… -
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…
-
Is there a way we can get the Approved by person in Definition step of NIR using OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Deep link not workingHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…
-
Provision for electing report parameters in OTBI Agents while subscriptionSummary: Content (please ensure you mask any confidential information): Hi Oracle, We have received a requirement from client to create agent having report with prompts.…
-
Are Sourcing Rules (Table MSC_SR_ASSIGNMENTS) available in BICC?Summary: Which is the right PVO / Dataset to use for this in BICC Offering setup? Content (please ensure you mask any confidential information): We need to extract Sourc…
-
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…
-
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…
-
Customizing Accrual Reconciliation report and status is Retrying when running ess jobSummary: Customizing Accrual Reconciliation report and create a new custom ESS job by copying standard ESS job but when running it then the status is Retrying Standard E…
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star… -
Report showing different output when logging in same environment (With SSO and Without SSO)Summary: Background A customer report is a custom report that shows all parts/items that are appended to a Machine. Parts/items will be included in the report even when … -
Sql query to get shipment method of orders in oracle fusonDear All, how will get shipment/delivery method of Orders in oracle fusion
-
How to increase time-out limit for online reportsSummary: I need to know where to increase the processing time for online reports. We have already increased the extraction limit to 2GB, but when we extract the report w…
-
Line Number and RA Document Line Number has different values in rcv_shipment_linesSummary: Line Number and RA Document Line Number has different values in rcv_shipment_lines Content (please ensure you mask any confidential information): Hello, We are …
-
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…
-
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, …
-
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…
-
Need PVO for description column corresponding to avespdescid ID column - EFFBPricing__AttributesSummary: Need PVO details for description column corresponding to avespdescid ID column Content (please ensure you mask any confidential information): Hi Team, We need t… -
Hide catalog toolbar when call analytic report from ApplicationsSummary: How Hide catalog toolbar when call analytic report from Applications Content (please ensure you mask any confidential information): Version (include the version…
-
Bare minimum roles required to view infotile dashboards for Procurement?what are the bare minimum roles required for the user to access an infotile dashboard in "Procurement Area" (Purchase Requisitions and Purchase Orders) I created a intof…
-
Do we have Out of the box OTBI report specifically for Production Scheduling?Summary: We need details on the standard Out of the box reports for Production scheduling, any lead would be highly helpful. Content (please ensure you mask any confiden… -
Oracle fusion INV_MATERIAL_TXNS table's ACCT_PERIOD_ID column not populatedSummary: We are designing a DataWarehouse for fusion SCM and we notice that ACCT_PERIOD_ID column from INV_MATERIAL_TXNS table is not populated Content (please ensure yo…
-
WIP_ENTITIES stores information about jobs, repetitive assemblies, in fusion appsfor reports where i can get the information about jobs, and repetitive assemblies in fusion apps like in ebs WIP_ENTITIES stores this information. also need the equivale…
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.
-
Is there a method to import RFQ data from legacy system to Oracle Cloud.Summary: When checked for FBDI option, the template to import only lines is available but not the header or RFQ as a whole. The requirement is to migrate Inprogress RFQs…
-
Please help me to find Location table for procurementSummary: I am trying to find a table which is having Location details showing on Manage Location page. I want to fetch highlighted fields showing in attached image. Curr…