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
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are… -
System should pop a message to remind transaction date should be prior to current system dateIn oracle fusion, Work Execution->Report Material Transactions we are able to add a message here to say that transaction date should not be today's date. But we are unab…
-
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …
-
Reports and Analytics AccessSummary: Production Supervisor Role unable to see Reports and Analytics under tools Content (please ensure you mask any confidential information): Production Supervisor …
-
Unable to find database tables for Manage Terms and Conditions SetupHi Team We have the requirement to use the terms and conditions created under manage terms and conditions setup but not able to find out the related table or lookup. ple…
-
How to setup FTP server on PDH and send files from PDH to PDH FTP serverSummary: We have a requirement of sending Item and Cost master information from PDH to CPQ via SOA middleware. We need to enable and setup FTP server on PDH so that SOA … -
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…
-
Need to know Job scheduler setting detailsHi Team, We are looking for BIP job scheduler setting details like job queue size , priority etc. Could you please guide on the same. If we can fetch the details from so…
-
Can we get Accrual Account details from "Distribution Detail by Account" seeded OTBI reportSummary: Business needs to view Accrual Account details from "Distribution Detail by Account" seeded OTBI report is that possible. If I query I can not view the details …
-
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c… -
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include… -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …
-
Unable to find Oracle R12 Inventory tables in Oracle FusionHi, We are working on Fusion Implementation project. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficu…
-
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…
-
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…
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t… -
access to reports and analytics tileSummary: User does not see "Reports and Analytics" tile in Tools which role, data access needs to be given, user has Production Supervisor and Production Operator roles.…
-
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
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…
-
In OTBI Report Date is not displaying correctly as per the date mentioned in front endSummary: In OTBI Report Date is not displaying correctly as per the date mentioned in front end Content (please ensure you mask any confidential information): Subject Ar…
-
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…
-
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…
-
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…
-
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…
-
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…
-
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …
-
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… -
Query/Table to find the below highlighted fields for Configure Negotiation Award Outbound Service?Can you help me in finding the above highlighted fields? -
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…