Category 174-2
Discussion List
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …Astrid Ferrao-Oracle 370 views 11 comments 0 points Most recent by Kaustubh Sawant Inventory Management -
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… -
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi…
-
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different … -
Subject Area 'Sourcing - Supplier Negotiations Real Time' Supplier Name absentSummary: A supplier negotiation has 5 invited suppliers listed under the section Suppliers. The indicator 'Restrict to invited suppliers flag' is YES. We would like to p…VDM_IM 34 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-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 60 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…Tapas_Sathua 23 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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…Muhammad_Saad 8 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…VDM_IM 35 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25DSuresh Kannan Saminathan 19 views 2 comments 2 points Most recent by SankarBalu 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 44 views 1 comment 1 point Most recent by Andrada-Oracle 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 159 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte…
-
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 14 views 1 comment 0 points Most recent by Andriampeno Odilon Reporting and Analytics for SCM -
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…
-
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 159 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
Where is Business Classifications information are stored?Summary: We want to build a custom report which shows the Supplier Registration requests where we need to display the Classifications along with the attachment names. We…Mateen Khan 48 views 5 comments 0 points Most recent by Jaya Simha Reddy 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 9 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …Gefen 19 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 16 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 18 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 30 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a function accepted in OTBI to print FIRST ROW of values?Summary: Summary: I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first…VDM_IM 18 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…Rajesh7d 9 views 2 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 10 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-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…Edgar11 7 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle 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 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 15 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 11 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 15 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM