Category 174-2
Discussion List
-
![Alex[REPLY]](https://us.v-cdn.net/6034893/uploads/defaultavatar/nUDT79VNNXZBX.jpg)
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 29 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 41 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 11 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 12 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 23 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 11 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 251 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 4 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 25 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 126 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 13 views 1 comment 0 points Most recent by AkashV-Oracle Supply Chain Planning and Collaboration
-
How To auto Schedule ESS Job?I want "Send Pending LDAP Requests" process to get auto scheduled in Oracle Fusion. Like in every 1 hour this process should be Auto Scheduled in oracle fusion.Khan.Unzela 13 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Human Capital Management
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 21 views 1 comment 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for SCM
-
How to print label to printer using rest api when running the BIP report?Summary: How to print label to printer using rest api, currently I'm using the erp integration endpoint from the fusion rest api guide to generate the label in XML. Howe…mayank_tripathi 22 views 1 comment 0 points Most recent by Saranya Sounderrajan Warehouse Management
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
SQL query to find the task for a specific tableSummary: Hi everyone, is there a query in which it will show the specific task of a table name? for example: table name = QA_INSPECTION_PLAN_B task name = Manage Attachm…Franz Marcelo 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 1.1K views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM