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
-
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 16 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 24 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 141 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…
-
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…
-
Function in Formula Column like Report Builder(RDF)Summary Function in Formula Column like Report Builder(RDF)Content In BI Publisher do we have an option to build a function(PL/SQL) in the formula column. In RDF report …
-
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…
-
How to find last_modified_by for reportsSummary How to find last_modified_by for reportsContent Hi Team, We have reports with multiple templates and same has been modified by someone. so would like to find the…
-
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…
-
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 …
-
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…