Category 174-2
Discussion List
-
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 22 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… -
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 41 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
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 2 views 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 12 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 181 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 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 79 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 12 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 22 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 24 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 14 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 821 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
OTBI Report - Hyperlink Path Not Found ErrorI'm getting a "path not found" error when clicking a hyperlink on a graph in my OTBI report. The hyperlink is supposed to open a customer profile report when I click on …Omran Zeaiter 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 4 views 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Need to create a Job set which call Min Max Job 600 times with different parametersSummary: We need to create a Job set which will trigger the Min-Max planning report 500 times for different Inventory Organizations. We are able to create the job set th…
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want…Abdur Rehman 13 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Is there a way to publish data from a report to an OIC service?Summary: Is there a way to publish data from a report to an OIC service? Content (please ensure you mask any confidential information): Is this architecture achievable? …Andres De la Ossa-Oracle 12 views 0 comments 0 points Started by Andres De la Ossa-Oracle Integration -
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 22 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 31 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM