Category 174-2
Discussion List
-
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…KDR 51 views 5 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM -
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
We have enabled Audit report for Approval changes via BPM as per oracle suggestionSummary: We have enabled Audit report for Approval changes via BPM as per oracle suggestion, is there any impact on the performance while it is enabled? Content (please …Prathyusha_reddy_maram 5 views 0 comments 0 points Started by Prathyusha_reddy_maram Reporting and Analytics for SCM
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …
-
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 18 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 39 views 0 comments 0 points Started by Prabhjeet Kaur Reporting and Analytics for SCM
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 13 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 29 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 4 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Table to get "Reference Type" in depletion layer?Summary: I am looking for a table that contains the "Reference Type" field in the depletion layer as in the screenshot below. thanks in advance! Content (please ensure y… -
Is it possible to see when a text field has been updated in Reports and analyticsThe usecase is to be able to make a filter on a text field where only items that have updated that specific field for the last 4 weeks are shown in the results.
-
Will the Redwood upgrade will impact our existing Analysis reports and/or DashboardsSummary: Will the Redwood upgrade will impact our existing Analysis reports and/or Dashboards that use Analysis reports? We are trying to schedule and prioritize project…Bill Stearns at Essex Grove Consulting 37 views 4 comments 0 points Most recent by Bill Stearns at Essex Grove Consulting Reporting and Analytics for SCM
-
Work Order DFF not visible in OTBI Subject AreaSummary: Work Order DFFs are not visible in OTBI Subject Area We have run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" also…
-
Operation Status columnSummary: Operation Status column Content (please ensure you mask any confidential information): Hi, On which Manufacturing subject area I can find operation status (Read…Muhammad_Saad 14 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…
-
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 33 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
ARCredit Memo Comments: Attribute CreditMemoComments in view object CreditMemoHeader1 cannot be set.Summary: I'm trying to update the AR Credit Memo Comment field using REST API. It is throwing, Credit Memo Comments: Attribute CreditMemoComments in view object CreditMe…
-
Custom job set not requiring custom privilegeSummary: user guide is very clear on this topic: but reality is different. Created a custom job set for cycle count alike the seeded job set but without the report. It w…Erik Jurjens-Oracle 1 view 0 comments 0 points Started by Erik Jurjens-Oracle Reporting and Analytics for SCM
-
Report is ending in errorWe have a custom BI report related to Inventort module. The report generates excel output and the file size can be of 100 MB or more. When we run the report for multiple…KabirB 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Context PO DFF does not appear in OTBI - PO real time subject areaSummary: We have a context DFF at the PO Header, and I am unable to see those DFF's in the OTBI Report (Procurement- PO Real Time). Is there any way to allow the OTBI so…diego m schenquerman 14 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Completed Quantity in One columnSummary: Completed Quantity in One column Content (please ensure you mask any confidential information): Hi, We have a requirement to add an completed quantity of work o…
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…
-
Adding Pending Approver to a ReportWe need to add the next approver to a Report. We are unable derive the next approver (to whom the requisition is not yet assigned for approval) for requisitions which ar…
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 614 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…VDM_IM 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP