Category 174
Discussion List
-
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
-
ESS job is running longtime in JobsetWe have created a Jobset with 2 ESS jobs. First ESS Job is completed fast and second ESS Job is running longtime and not completing. When we run the second Job independe…Lakshmi Bandlamudi 31 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for SCM
-
Performance considerations while doing Bulk Email BurstingSummary: At a time, need to send around 5K email notifications to supplier/supplier sites belongs to country . Content (please ensure you mask any confidential informati…Busireddypolimera 22 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
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 decide if a report to be developed in BIP or FAW?Summary: Content (please ensure you mask any confidential information): Based on what criteria should we use to determine if a report can be developed in BIP or FAW? Ver…Merlin Rajesh Avery 11 views 1 comment 0 points Most recent by Gayatri Chappalli-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
-
which privilage is needed to run 'Item Txn with Average Cost report'Summary: Hello experts , Our customer wants to give access to the user for 'Item Txn with Average Cost report' . They don't want to give the entire access of inventory s…Shalini Singh-Oracle 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Sql query to get shipment method of orders in oracle fusonDear All, how will get shipment/delivery method of Orders in oracle fusion
-
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
-
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 2 views 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 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM -
How to add page break for a HTML output of BIP Report. Please Advise.Summary: Page Break not working in HTML output of BIP Report. Content (please ensure you mask any confidential information): Version (include the version you are using, …Satya.Munagala 15 views 4 comments 0 points Most recent by Satya.Munagala Reporting and Analytics for SCM
-
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 11 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Report Bursting CapacitySummary: Hi Team, We have a business requirement to send an email with a PDF attachment via bursting. Here are the specifics: Delivery Method: Email via Bursting Attachm…Sai Sreeram Gundepudi 11 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
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 11 views 0 comments 0 points Started by Andres De la Ossa-Oracle Integration -
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 45 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
We need to extract all the sales Order data in excelSummary: Hi Team, Can we have a report which can help to extract all the sales orders which are open same like the fulfilment view export functionality. Currently the ex…Navneet909 23 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Please provide SQL query to get UCM file name,owner and upload date based on the UCM pathSummary: Kindly provide me the SQL query to get file name, owner and upload date from UCM based on the UCM path. Need this to create a parameter based LOV for ESS job. '…Lakshmi Bandlamudi 406 views 1 comment 0 points Most recent by Lucky Sharma 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 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 32 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 42 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
Behavior in PO_HEADERS_ARCHIVE_ALL recordsSummary: Behavior in PO_HEADERS_ARCHIVE_ALL records Content (please ensure you mask any confidential information): I am looking for an explanation of PO_HEADERS_ARCHIVE_…KDR 21 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 21 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 5.1K views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Unable to find Oracle R12 Inventory tables in Oracle FusionHi, We are working on Fusion Implementation project. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficu…Chaitanya KM 41 views 2 comments 0 points Most recent by Chaitanya KM Reporting and Analytics for SCM
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 114 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM