Category 174-2
Discussion List
-
Query to get the Serial Number of Shipment number for PO in CloudNeed to find the serial number used in shipment for purchase order when we pass shipment number. select rsl.line_num, rsh.shipment_num, poh.segment1 as po_number, pol.it…User_K040A 741 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 12 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 11 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
where can i find posting_type columns in scm tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…B V LAVAN Salivahan 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…Viswanath-Oracle 115 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Need to see BPM Approval Flow in OTBISummary: I am trying to create an OTBI report and would like to see the BPM approval flow from OTBI report. When trying to figure out who approved the requisition, since…mohamed_shahud 48 views 3 comments 0 points Most recent by Logan - HCG Reporting and Analytics for SCM
-
How to default an Inspection plan when entering inspection details ?Summary: How to default an Inspection plan when entering inspection details Content (please ensure you mask any confidential information): How to default an Inspection p…
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 51 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 329 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to restrict the Subject areas against specific Module with a roleSummary: Hi Team, We have a requirement to restrict the subject areas against each area, like inventory, procurement, and order management, using a specific role, as the…Support 23 views 4 comments 0 points Most recent by Vijay Bhaskar Koti Reporting and Analytics for SCM
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
How can we generate an OTBI report with receipt Number with received Quantity/AmountSummary: We have a requirement to create an OTBI report with Receipt Number and the corresponding Received Quantity or Amount. We tried using Purchasing Real Time data b…Asutosh Mishra 194 views 1 comment 1 point Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to add attachment column in bank account creation page of register supplier pageSummary: How to add attachment column in bank account creation page of register supplier page Content (please ensure you mask any confidential information): How to add a…Venkatesan 32 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset…Suresh Kampati 112 views 4 comments 0 points Most recent by Suresh Kampati Reporting and Analytics for SCM -
Can we create multi language records in AP_TERMS_TLSummary: Can we create multi language (i.e. English, French, German etc.) records in AP_TERMS_TL Content (please ensure you mask any confidential information): The table…YaronF 12 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
MSC_BOMs_VSummary: When queried it results no data and when the code is viewed it says "undefine" Content (please ensure you mask any confidential information): Is this a bug that…Mike.Myers.CDIPRODUCTS.COM 11 views 2 comments 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM
-
Where can I find the list of all seeded reports (OTBI and BIP) provided by OracleSummary: Where can I find the list of all seeded reports (OTBI and BIP) provided by Oracle for Procurement and Contracts? Content (required): Where can I find the list o…Asutosh Mishra 3.4K views 5 comments 0 points Most recent by SharathBiz Reporting and Analytics for SCM
-
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include…Larry Sherrod 1 view 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Product Development Start and End DateSummary: Set the add/remove date of codes on future dates with respect to effectivity date of the revision. Content (required): We have a question about the behaviour of…
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord…Ankit.Mahajan 22 views 1 comment 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM
-
Temporary Side Table and Reporting FunctionalitySummary: Hello experts, I have a question, perhaps a bit naive, but I would appreciate your guidance and assistance. In Oracle EBS (E-Business Suite), my client has a Bu…
-
How to deliver the OTBI report content to a destination server ex - A FTP serverSummary: Hi, Pl let me know how to deliver the OTBI report content (anlaysis) to a destination server ex - an on-premise FTP server. Where can we setup this in agent con…
-
Is it possible to give OTBI analysis access to Department Managers without any job role?Summary: Hello, We have a requirement to see PR-related analysis by department managers. These managers are not having roles or data access related to SSP module. Simila…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
Report of units that cannot be reserved due to low stockSummary: The business requires knowing the information of order line units that cannot be reserved due to low stock and in consequence the customer's order cannot be ful…Fabian Castillo 11 views 1 comment 0 points Most recent by Fabian Castillo Reporting and Analytics for SCM