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
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn… -
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL … -
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query … -
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…
-
Lot Experation Date Field in Subject AreaSummary Looking for the Lot Experation Date fieldContent I am using the Inventory - Inventory Transaction Real-Time subject Area. Under Lot there is no Expiration Date f… -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 951 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045
-
Logged in UsersSummary List of Users logged into the ApplicationContent Team, Trying to find a way to pull a list of current users that are logged into the system. Any thoughts? Thanks…
-
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…
-
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...
-
Lot Number received based on POContent Hi Freinds, I am trying to get a report based on Analysis having two subject area, Inventory-Inventory Transactions Real Time and Procurement-Purchasing Real Tim… -
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…
-
OTBI - Product Management - Cross Subject Area Logical SQL giving ErrorSummary OTBI - Product Management - Cross Subject Area Logical SQL giving Error 'The selected request cannot be performed because it references an unknown subject area n…
-
logic and functional usage of table column COST_RETAIL_FLAG on fif_gl_crossref on Oracle Retail merSummary Trandata history do not have the column COST_RETAIL_FLAGContent Trandata history do not have the column COST_RETAIL_FLAG, hence it is not clear how the TDH trans…User_2025-02-10-18-59-48-267 15 views 1 comment 0 points Most recent by User_2025-02-10-18-59-48-267
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…
-
Retail merchandising system, Tran data codes and their accounting treatment - EntriesSummary tran data codes from RMS and its accountingContent where can i find any reference document or user guide consisting of RMS tran data codes / GL_REF_NO accounting…User_2025-02-10-18-59-48-267 199 views 1 comment 0 points Most recent by User_2025-02-10-18-59-48-267
-
How to navigate to Cloud Application pages using Action links on columns in AnswersSummary How to navigate to Cloud Application pages using Action links on columns in AnswersContent Hello, I have created an analysis using subject area. Currently I am w…
-
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary… -
OTBI Dashboard results in display errorSummary The dashboard contains an analysis with extensible flexfields. The flex field is deployed and working fine within OTBI but when deployed on OM Landing page via s…
-
JOb Scheduling which need a change of date on parameterSummary how to do change the parameter date of the ESS job when we schedule itContent we need to schedule a ESS job on daily basis on parameter we have start date and en… -
OTBI Reporting for Received Date & Invoice InfoSummary Receiving Date issueContent Hello: We are trying to produce a report by Item number, PO, received date and quantity, along with the invoice date, number and PO M…
-
Event Trigger not working with multiple selection and null value passedSummary Event Trigger not working with multiple selection and null value passedContent In bip report we using multiple selection and null value passed parameter type, fo…
-
get lot number queryContent i created this query select RSL.ITEM_ID, RSL.ITEM_DESCRIPTION, rct.ORGANIZATION_ID, RHI.SHIPMENT_NUM, rsh.receipt_num, rct.transaction_date receipt_date from RCV…
-
Inventory report.Summary Trying to use OTBI but some columns like cost are missing.Content A report that shows the following below; I.) Item number II.) Item description )On hand quantit…
-
Email is not going through burstingContent Hello Team, We are trying to burst the report output to email from BI publisher, but it is not working. When I schedule to report that has the bursting query to …
-
How to attach UCM document in email using bursting?Summary How to attach UCM document in email using bursting?Content Hello Team, I have a requirement where i need to attach an UCM document(Dynamic) or the send URL to do…
-
How to send the header information in email body and line information as attachment using Bursting?Summary How to send the header information in email body and line information as attachment using Bursting?Content Hello Team, I have a requirement where an email needs …
-
How to find or differentiate Internal/External Drop shipmentsSummary How to find or differentiate Internal/External Drop shipmentsContent Can you please share the query for the Internal/External Drop shipments sales order? This wi…
-
Specification for DOO_CROSS_REFERENCESummary Specification for DOO_CROSS_REFERENCEContent In the DOO, most of the views 'DOO_CROSS_REFERENCE' Pkg used to get shipment method, freight term...etc Where we can…
-
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…
-
You cannot create a link to a child group as it is having a parent group.Summary Trouble joining more than one query to a "main" one.Content Hi. I'm trying to join two queries to another one as shown in the picture. I can join G2 or G3 to G1,…User_2025-02-07-06-48-26-537 351 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537