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
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord…
-
How to deliver the OTBI report content to a destination server ex - A FTP serverSummary: Hi, Pl let me know how to deliver the OTBI report content (anlaysis) to a destination server ex - an on-premise FTP server. Where can we setup this in agent con…
-
Has anyone tried adding the cost to the INV_MATERIAL_TXNS table before?Summary: Hi, I'm trying to add the cost to the INV_MATERIAL_TXNS table. Has anyone tried this before? I'm using the cost from CST_LAYER_COSTS table but I'm getting dupli…
-
How to identify the Fusion Cloud user, how he/she has login through (REST API/OIC/URL)Summary: We used FND_Session table to identify the user, who has been logged in to cloud. but this does not tell about, how the user has been logged in. Manually( URL lo…
-
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Is it possible to give OTBI analysis access to Department Managers without any job role?Summary: Hello, We have a requirement to see PR-related analysis by department managers. These managers are not having roles or data access related to SSP module. Simila…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
Report of units that cannot be reserved due to low stockSummary: The business requires knowing the information of order line units that cannot be reserved due to low stock and in consequence the customer's order cannot be ful…
-
How to modify the alignment in the PO Terms and condition setupSummary: Term and condition pulling from the purchasing setup in PO PDF report but We needs to do the alignment changes as per the business requirement. Please let us kn…
-
Can we customize the Award Negotiation Spreadsheet?Summary: Is is possible to customize the Award Negotiation spreadsheet? Also , is this report a BIP report in OTBI? If yes can you share the location? If it is not what …
-
Multiple join in Procurement - Purchasing Real Time subject area - Need helpSummary: I am trying to create a very simple analysis from the start. But when I add colums from other folders, the rows multiply and the data is convoluted. Content (pl…
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…
-
Is it possible to fetch historic On hand balances with it's costsSummary: We have a requirement that the business user wants to see backdated on-hand balances (Opening balances) with it's associated costs, i couldn't find any document…
-
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…
-
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…
-
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 configure Process Payment Request to trigger custom DM for Disbursement Payment File Format?Summary: We have created a custom Data model and added custom template to Disbursement Payment File Format. Please help us to configure the Process Payment Request to tr…
-
DFF details are not found in Install base Subject AreaSummary: By default the DFF on IB will show up in OTBI reporting ? Content (required): I have DFF created on IB asset, When I tried to add the DFF to a OTBI analysis I d…
-
how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real TiSummary: how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real Time? Content (required):n/a Version (include the version you …
-
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…
-
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 …
-
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…
-
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…
-
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…
-
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…
-
OTBI Procurement - Requisitions Real Time Subject areaSummary: Procurement - Requisitions Real Time Subject area doesn't show Requisition with Source Inventory, Only showing Data for Supplier Source so which Subject area ca…
-
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…
-
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…