Business Intelligence
Discussion List
-
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…Martin Hutchison 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Enable Context Sensitive Contract Header DFFs in OTBISummary: We have setup and deployed both Global and Context Sensitive DFFs on Contract Header. The Global Segments appear in OTBI (e.g. for selection in an Analysis obje…
-
Locate an EL Expression Value for inputComboboxListOfValuesSummary: Locate an EL Expression Value for inputComboboxListOfValues Content (please ensure you mask any confidential information): Hi , We have a requirement to write E…Hitha Harikumar 21 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Item attribute values by revisionsHello, we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item. This means that we want to extract data with the following st…
-
Can Subject of a Negotiation Award Approval Bell notification be customized?Content Can Subject of a Negotiation Award Approval Bell notification be customized? Like have supplier name and description? Version Oracle Fusion 13, 19C
-
How to pick po line level attachment columnHello. I want to pck an column in custom BI report of PO line level attachment on serial number attachment sign is coming when we click on that new pop up opens in which… -
Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tabSummary Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tab What formula does the system/dashboard uses to calculate the On Time Delivery in …Maria Angelica Mendoza 51 views 2 comments 0 points Most recent by Maria Angelica Mendoza Purchasing -
Extracting Requisition and Purchase Order Rule Details defined in BPMSummary Extracting Requisition and Purchase Order Rule Details defined in BPMContent I am looking if anyone know if there is a way to run a query/report or table name wh…
-
Contracts Deliverables ReportContent Hello, Does anyone have a Contracts Deliverables Report that they can share? When I am building a report using OTBI Subject Area - I am getting many different st…
-
Sample Oracle BI Reports for Spend Authorization RequestsSummary Dashboard for Spend Authorization RequestsContent This dashboard will allow you to view the following key details: * Number of spend authorization requests by St…Aishwarya Pawar-Oracle 68 views 1 comment 1 point Most recent by Marcela Narváez Supplier Management
-
How to customize supplier registration workflow notifications?Summary: How to customize supplier registration workflow notifications? Content (required): Hi Experts, We got a requirement to customize the supplier registration appro…
-
How to get last issued Document Number for a bank account through REST APISummary: We need to create a Manual payment through Integration (REST API). In order to create a manual payment, we need to send Payment Number in the payload. We would …
-
Task details not required while association of projects in contractsHi, While associating a project to the contract, task details are not required by the client for one BU and it is required by another BU. So can we restrict these detail…
-
query to get program name and program code in supplier channel managementIn Procurement, we have supplier channel management. Under this, we have manage supplier programs,. I need few details like program code, program name etc from this scre…
-
Query Supplier Site Payment TermsSummary: Content (please ensure you mask any confidential information): Does anyone know what the SQL query is to pull the payment terms associated at the supplier site …
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
need a query to get the unit price of subscription invoiceSummary: need a query to get the unit price of subscription invoice Content (please ensure you mask any confidential information): Version (include the version you are u…Sai Divya Kolachana 23 views 4 comments 0 points Most recent by Sai Divya Kolachana Subscription Management
-
Perform Bulk Export feature in Enterprise ContractSummary: We have a requirement of exporting contract attachment in bulk, I read some oracle support note, it looks like as per this Bulk Export Contract Attachments (Doc…Sam Samaddar 11 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts
-
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
Error on the The contract owner role ID during the creation contractSummary: Hi , during the creation contract , I have the error : This error appeared right after i saved the setup i made on the party role, linked to the type of contrac…Michela A. Morgillo 34 views 1 comment 0 points Most recent by Andrei Ursachel-Support-Oracle Enterprise Contracts
-
how to Setting Up an Automated Contract Lines Descriptive Flexfield based on Contract Type?Summary: Hi , I added a new Context with the Sensitive Segments in the Contract Lines Descriptive Flexfields: But , after the deploy these flexfields don't visible on th…Michela A. Morgillo 11 views 1 comment 0 points Most recent by Anil Fogat-Oracle Enterprise Contracts
-
Approval history (Pending and Approved) report for ContractsDear All, We are looking to get approval history for approved and pending contract approvals. I am trying to use the below table but could not get the proper output as I…
-
The contract don't visible the flexfields added on the contract lineSummary: Hi , I added the flexfields on the Descriptive Flexfields :contract lines . But after deploy , these flexfields they are not present in the contract lines. How …Michela A. Morgillo 41 views 3 comments 0 points Most recent by Daniel Bossier-Oracle Enterprise Contracts