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
-
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… -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require… -
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
In Oracle Fusion which table have items unit costContent Dear , I want items unit cost in which i used table CST_TRANSACTION_COSTS ctc table then join into CST_INV_TRANSACTION cit through ctc.CST_INV_TRANSACTION_ID = c… -
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…
-
Supplier Site EmailContent Hi, I used the column email_address from POZ_SUPPLIER_SITES_ALL_M table but could not find the email address. Attached is the screenshot please advise is there a… -
Query to get Item Name and its CategoryContent Hi, Please can you share query to get category name for a given item code. Thanks
-
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…
-
How to make a custom report available in supply planning work area?Summary How to make a custom report available in supply planning work area?Content Created a custom report. Users want it to be able to open from the supply planning wor…
-
INV_SERIAL_NUMBERS does not show some serial numbersContent Dear , I have items serial numbers in which i have transaction id in INV_MATERIAL_TXNS which is join to INV_SERIAL_NUMBERS > LAST_TRANSACTION_ID it is showing co…
-
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'… -
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data … -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…
-
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...
-
Create Link to the BIP from InfoletContent We are looking for the solution where we create a custom Infolet and that infolet should have a link to open a UI screen same as Standard infolets. For example: …
-
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…
-
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…
-
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 170 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… -
Payables invoices items detailsSummary Payables invoices items detailsContent Dear All, I need to create new OTBI report showing all details for suppliers received invoices as follows: Item number - I…User_2025-02-10-22-13-59-726 23 views 3 comments 2 points Most recent by User_2025-02-10-22-13-59-726
-
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… -
inventory - inventory transaction real timeContent i use inventory - inventory transaction real time subject area, i need to create analysis 1- open balance for each item before specific date . 2- sum transaction…