Reporting and Analytics for SCM
Discussion List
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…
-
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…
-
how to use BICC for extracting large data from cloudSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Where to look for seeded reports in Cloud application?Hi, I am looking for information about seeded reports. Could some one point me to the place where seeded/out of the box reports available? I have managed to get the SCM …
-
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…
-
how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real TiSummary: how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real Time? Content (required):n/a Version (include the version you …
-
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoicedSummary: Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue. Content (required): select p… -
What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and S&OP?Summary: What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and Sales and Operations Planning? Content (required): What BICCs are…
-
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…
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
How to filter out duplicate value for multi-rows attributes in OTBI analysisSummary: The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis. Content (required): I have two multi-rows attrib…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
Field names in several subject areas are changed. Where to find this in documentsSummary: Field names in several subject areas seem to have been changed as a result of 23B release. We've reviewed the documents and can see no mention of this in any of…
-
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
How to schedule a custom job to run twice a day?Summary: How to schedule a custom job to run twice a day? Content (required): Is there a way we can schedule a job twice daily with the same set of parameters at 6am and…
-
What will be the expression to calculate duration between two timestamps ?Summary: While Creating the Downtime Custom Page using Application Composer, a field named "Calculated Duration" is defined with data type as "Formula". So, an EL Expres…
-
Standard Contract Print customization to separate Contract Terms template Clauses on language basisSummary: Content (required): We have to customize the contract print report to customize the contract terms template clauses should be separated based on the language li…
-
Link between DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERSContent Hi All, We need a header level information for these tables 1) DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERS 2) inv_transfer_order_headers and INV_PICK_SLIP_NUMBERS …
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…
-
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 (…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity WIP_FLOW_SCHEDULESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity WIP_FLOW_SCHEDULES? Content (required): Version (include the v…
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real timeSummary: Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real time OTBI report using a custom role. Currently these are added …
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …
-
Equivalent Oracle Cloud table/view for the EBS 11i entity WIP_ACCOUNTING_CLASSESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity WIP_ACCOUNTING_CLASSES? Content (required): Version (include t…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity MTL_MATERIAL_TRANSACTIONS_TEMPSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity MTL_MATERIAL_TRANSACTIONS_TEMP? Content (required): Version (i…
-
Days Ref for Unprocessed days in Procurement-Requisition Real Time -Req Line Detail Subject AreaHi, We are making some changes in Purchasing KPI metric which is using Unprocessed days column from Procurement-Requisition Real Time subject area under Requisition Line…
-
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…