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
-
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…
-
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…
-
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… -
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…
-
Query/Table to find the below highlighted fields Configure Supplier Outbound Synchronization ServiceCould you please in finding the above columns?
-
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…
-
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…