Category 174-2
Discussion List
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 125 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Reporting and Analytics for SCM -
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
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 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 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a query to fetch planned order and demand due datesSummary: Hello, We need a query to fetch planned order due dates and corresponding pegged sales order/forecast need by dates for a certain category of items. We would li…SharathBiz 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…
-
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…Rahul_M8SG8 24 views 4 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
What all standard reports are available in oracle fusion for Procurement and Supply Chain ManagementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to restrict IBLPN TI-HI receiving at certain Volume/weight/QTY.Summary: We are looking for restriction in receiving, on IBLPN at Volume/weight or QTY basis. Content :- Hi, We are looking for restriction in receiving process, on IBLP…
-
need a query to get the unit price of subscription invoiceSummary: we need a query to get the unit price of subscription invoice. Content (please ensure you mask any confidential information): Version (include the version you a…Sai Divya Kolachana 47 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management
-
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…Anurag Kumar Pandey 31 views 2 comments 0 points Most recent by Anurag Kumar Pandey Reporting and Analytics for SCM
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…Naresh313 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …Prakash Shetty 11 views 2 comments 0 points Most recent by Prakash Shetty Reporting and Analytics for SCM
-
Adding more contract variation details (list of updated things) to Approval of Contract NotificationSummary: Adding more contract variation details (list of updated things) to Approval of Contract Notification Content (please ensure you mask any confidential informatio…Muhammad Amir Imran 41 views 2 comments 0 points Most recent by Muhammad Amir Imran Enterprise Contracts
-
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 32 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
System Performance Health CheckSummary: We are seeking a solution that will help us monitor the health of our ESS Jobs. Something that would alert us of long run times, threads getting hung up etc. We…Schneider.Mark 21 views 3 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
Accessing "EGP_SYSTEM_ITEMS_B_V" table PythonAccessing "EGP_SYSTEM_ITEMS_B_V" table Python Hello Experts, I need access to the EGP_SYSTEM_ITEMS_B_V (Or any back-end table through Python. Is there any method for tha… -
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…Mohammad Hussein 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…Sumiran Maheswari 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…
-
Columns from View Billing Extension Event Details page not found in the backend tablesNeed backend tables or reference code for the below listed columns. Navigation: Navigator >> Contract Management >> Revenue >> Task >> Manage events >> query a contract …
-
Does anyone have any prebuilt Order Management aging OTBI analysis to share?Summary: I am looking for any prebuilt OM Aging OTBI analyses that can be used as a starter file. I am new to using OM and trying to build an OTBI analysis grabbing very…Teresa Meyerhoeffer 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
SCM seeded report including bin location and on order countI'm needing a SCM report that has the bin location, and also the on order count. Does anyone know of a report that includes these two fields or know of what table I can …JWilliamson 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need BICC PVO which lists Items details with Item ClassAre there any BICC PVOs that lists Item Class as part of Item details. We are able to get most of the Item data from "FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemEx…Suman D 272 views 1 comment 0 points Most recent by Hari Kurra-Oracle Reporting and Analytics for SCM
-
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…
-
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 20 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 21 views 3 comments 0 points Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 125 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
BICloudConnectorJobDefinition Errors with ORA-01476: divisor is equal to zeroSummary: Experts, We are running "Prepare Supply Chain Planning Data for Export" to export data to BICC. However BICloudConnectorJobDefinition fails with this error Caus…Sudeep VS 12 views 1 comment 0 points Most recent by AkashV-Oracle Supply Chain Planning and Collaboration