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 create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS… -
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee… -
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 865 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 -
Need organization inventory data unit cost wiseContent Dear , We have 11 Inventory Organization in which we want inventory unit cost as per org id. so we created customized query join cst_transactions ct into inv_mat… -
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…
-
Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableSummary Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableContent Hi , We have a report created which fetches order,Order charge component , pricin… -
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…
-
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...
-
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…
-
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… -
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'… -
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
-
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…
-
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
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: …
-
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
-
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…
-
Item issuance report with CostSummary Item Issuance report required with Cost.Content Hi, Is there any report for Inventory issuance including the Cost ( Item list price * Quantity issue ) Month or w… -
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 113 views 1 comment 0 points Most recent by User_2025-02-10-18-59-48-267
-
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…
-
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…
-
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…
-
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… -
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…
-
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… -
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…