Category 174
Discussion List
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 157 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM -
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 143 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for SCM
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA…Andriampeno Odilon 7 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for SCM -
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…MayurM 4 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to make the report link variableSummary: Sandbox-How to make the report link variable Content (please ensure you mask any confidential information): Hi Team We have customized a report and use sandbox …Carol Tang 10 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query…Deepak Bhatt 9 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …MayurM 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Conversion UOM columns From and To Code from INV_UOM_CLASS_CONVERSIONS Showing Interchanged ValuesHi, I have observed an interchanged outputs in column- FROM_UOM_CODE, TO_UOM_CODE in table INV_UOM_CLASS_CONVERSIONS. What could've been the cause of this? Regards, Mikamikaromo 15 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul…Deepak Bhatt 6 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …Sheetal VBCS 24 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Availability of sales order tax information (DOO_ORDER_TAX_DETAILS) in PVOs?For SCM analytics, I am looking for information on tax details at the sales order level (which table-wise seems to be in DOO_ORDER_TAX_DETAILS), for calculations pertain…Or Shoham 9 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle 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…Alok5Kumar 7 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot.Ramsha Zameer 4 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 13 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 38 views 0 comments 0 points Started by Ankana Bhattacharya Reporting and Analytics for SCM
-
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 …
-
not able to locate any PVOs that expose the DFFs for Transfer Order Header and LineSummary: In the 25B release, I’m trying to create a BICC data extract job for Transfer Order Headers and Transfer Order Lines, including their Descriptive Flexfields (DF…User_CK3H0 23 views 2 comments 0 points Most recent by Janakrm-Oracle Reporting and Analytics for SCM
-
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 25 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 8 views 2 comments 0 points Most recent by Prasanth Senthivel-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 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…PrasadN 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…MichaelV823 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Lexical parameter values for Movement Request Pick Slip Report data model changesSummary: We are working on the SQL query for Oracle Seeded Data Model - Movement Request Pick Slip Report Data Model where it shows some lexical parameters and asks to p…Suyog Dhongade 17 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 11 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 32 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 45 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
Redwood: Purchase Document E-mail ReportSummary: Redwood: Purchase Document E-mail Report Content (please ensure you mask any confidential information): Hi Team, We are getting new feature in 25D :Redwood: Use…Nidhi Chhajed 23 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
BIP report use '_vl' view cannot switch language by user language preferenceUse '_vl' view to extract data in BIP report, but it didn't display in correct language based on user's BIP preference session language. Given that, I selected :xdo_user…Skye Liu 34 views 4 comments 0 points Most recent by Rajasekhar Bandaru-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 12 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…Anand P 30 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM