Category 174-2
Discussion List
-
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…Reetika Chaudhary 22 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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…
-
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…Mariyam129 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
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…Sudhan-Oracle 12 views 2 comments 1 point Most recent by Catherine Raes Reporting and Analytics for SCM
-
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…Ripendra Kumar-Oracle 1.3K views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Is there a table that holds Impact AnalysisSummary: Content (required): we need to extract information from the tab "Impact Analysis" (which is available, for instance, in Change Order objects). Is there any tabl…
-
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…kalyan gade 12 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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…
-
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…Bratati 83 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
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…Nagendrababu Kanuru 62 views 3 comments 0 points Most recent by vikram khengare Reporting and Analytics for SCM
-
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 …User_BEGVH 165 views 3 comments 0 points Most recent by Marc Vermeulen Reporting and Analytics for SCM
-
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…Nagendrababu Kanuru 21 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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…Nagendrababu Kanuru 22 views 1 comment 0 points Most recent by Vikash Tiwary 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 32 views 3 comments 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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…
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 179 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…Lucky Sharma 42 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows SCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …Ibrar Hussain 42 views 1 comment 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 32 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_V? Content (required): Version (in…Nagendrababu Kanuru 52 views 2 comments 0 points Most recent by Nagendrababu Kanuru Reporting and Analytics for SCM
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 46 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…
-
Equivalent Oracle Cloud table for the EBS 11i table WIP_LINESSummary: Could you please help us to provide the equivalent Oracle Cloud table for the EBS 11i table WIP_LINES? Content (required): Version (include the version you are …Nagendrababu Kanuru 42 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, Julia