To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report. -
Please help me to find Location table for procurementSummary: I am trying to find a table which is having Location details showing on Manage Location page. I want to fetch highlighted fields showing in attached image. Curr…
-
How to increase extraction capacity of a customized report?Summary: I need to extract the report over a 2-month interval, which would give approximately 100 000 lines. Content (required): I created a report with approximately 80…
-
Where can I find the equivalent table of Approval Rule conditions?Summary: We are creating a new Approval Rules for Cash Advance and Expense report but it is not successful using the conditions available on the Approval Workflow. We ne…
-
RTF Font not being rendered in PDF outputSummary: RTF Font not being rendered in PDF output Content (required): We are trying to use a specific font in our PO RTF template called Script MT Bold : However when w…
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…
-
OTBI REPORT from Purchase requisition to Invoice paidSummary: Report from Purchase Requisition to Invoice Paid Content (required): We need a report which show a full flow status from PR to purchase order to receipt and fin…
-
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…
-
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…
-
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…
-
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…
-
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… -
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…
-
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…
-
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…
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…
-
Need corresponding technical information on the R12 views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_VSummary: Looking for the replacement view or table information for the R12 supply chain planning views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_V. Content (required): Curr…