Category 174-2
Discussion List
-
How can I add filters for members in planning table?Hi, I'm trying to show the filters on material plan table for my supply planning (example below ) tried to Use Advanced Options in the Selector Tool but shows nothing. I… -
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? https://us.v-cdn…Prathyusha_reddy_maram 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need the base table/Query to extract the number of Open Production Exceptions in Work ExecutionSummary: Need the base table to understand the list of Open Production Exceptions in the Work Execution > Manage Production Exceptions Content (please ensure you mask an…Vignesh Subramanian 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
The .xls output format is missing on Scheduled process Advanced Options tabHi Community, When we try to run a BIP report from Scheduled Process and use the Advanced Options tab to select Output format, the .xls format is missing and only mhtml …Ankana Bhattacharya 19 views 0 comments 0 points Started by Ankana Bhattacharya Reporting & Analytics for Fusion Service
-
How can we customize the Receivables customer statement report with new parametersSummary: we have a requirement where we have to add a couple of dffs as parameters to the standard Customer statement report. Is this possible? Also, the customer wants …
-
How to bulk create item structure from "Create from common" using FBDISummary: How to bulk create item structure from "Create from common" using FBDI Content (please ensure you mask any confidential information): In our project there is re…Sujay Parab-Oracle 5 views 0 comments 1 point Started by Sujay Parab-Oracle 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…
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In…PeterBridge 26 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas…Jai.S.Chavan 6 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 3 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
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…Eddie Zucker 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha…missy_21 5 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Can we fetch tax classification code using subject areas under supplier address levelHi , We are trying to add tax classification field in otbi report using subject area Supplier - Supplier Real Time, we can get the details of tax classification code und…Vinay414 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Parameter names with values does not appear on the custom ESS jobSummary: We've created a custom job mirroring the standard ESS process - Release Pause Tasks. The only change is that we have made the order field as a required field an…Mary Jane Sariba 29 views 2 comments 0 points Most recent by Mary Jane Sariba Reporting and Analytics for SCM -
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…Cameron Campbell 38 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
Item number update in PROD for existing item having transactionsSummary: Is it advisable to update item number of existing item already in use in PROD? Content (please ensure you mask any confidential information): Customer has exist…Sujay Parab-Oracle 11 views 0 comments 0 points Started by Sujay Parab-Oracle Reporting and Analytics for SCM
-
How to reuse RTF of Packing slip report in BOL report which has different data models and parametersWe have one requirement with below 2 reports 1 . Packing Slip report -------- /Supply+Chain+Management/Warehouse+Operations/Shipments/PackingSlip.xdo 2. BOL report. ----…ManuYal 10 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl…Shamsul_Wzd 98 views 2 comments 0 points Most recent by Sachin SCM-Oracle Reporting and Analytics for SCM -
Does account analysis report has PO Number?Summary: Does account analysis report has PO Number in data model? Content (please ensure you mask any confidential information): Version (include the version you are us…
-
Can REST API be used to run ESS BIP Job Type? It returns Request Id = -1Summary: Can REST API be used to run ESS BIP Job Type? Why does the REST API return Request Id = -1? Content (please ensure you mask any confidential information): Oracl…Catherine Alequin 41 views 1 comment 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM -
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 796 views 6 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
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 58 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…
-
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 13 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 50 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 16 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…