Category 129
Discussion List
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the … -
BICC Extract using Web Services returns only headersSummary: We are invoking a BICC Extract using Web Service call. The web service is successfully submitting the job. The job is successful and it generates the files in U… -
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont…
-
Drill Down from BI Publisher to another BI Publisher (Summary to Detail)Summary: Trying to navigate from a summary report to detailed report. I am following the documentation. https://docs.oracle.com/middleware/11119/bip/BIPRD/BIPRD.pdf This…
-
Fusion ERP - Roles x Privileges ReportHi everyone, Do we have a report that lists all the privileges for all roles (including both predefined and custom roles) in Fusion ERP? Something like this: Role | Priv…Jorge Gutierre 61 views 4 comments 1 point Most recent by Jorge Gutierre Reporting and Analytics for ERP
-
possibility to build OTBI analytics report from Cash Management bank statement + Accounting dataSummary: Hi, would like to ask for any hint and help, if OTBI analytics tool is suitable to build report from Cash Management bank statement + Accounts from Primary and …
-
Requirement to add Custom fields on EDI856 in Collaboration Messaging FrameworkSummary: We have done the setups in Collaboration Messaging Framework(CMK) in ERP Cloud Fusion for EDI 856 (Advance Shipping Notice). Our client is looking for few of th…Amit Sutar 151 views 6 comments 0 points Most recent by Datta Ghuge Acn Reporting and Analytics for ERP
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…Bo Tøpgaard 121 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
We need to perform a mass update of the Taxpayer Identification Number (TIN) for customers in OracleWe need to perform a mass update of the Taxpayer Identification Number (TIN) for customers in Oracle ERP, as per the requirement. We attempted to accomplish this using O…
-
Is there a way I can concatenate addresses in HZ_LOCATIONS?In EBS, you could call a package (hz_format_pub.format_address()) which would concatenate the address elements when passed the location_id as an argument respective to t…Innovate.Matt 61 views 2 comments 1 point Most recent by Innovate.Matt Reporting and Analytics for ERP
-
How to find Parameters passed for scheduled ESS jobSummary: ESS job 'Purge interface tables' was scheduled 4 years back for AP invoice, due to some issue we cancelled the schedule and now we want to find the parameters u…Nidhi Chhajed 3.5K views 28 comments 0 points Most recent by PaulaPraska Reporting and Analytics for ERP
-
Which table does PO notification report extract data fromDear support, I found in Purchase Order Notification report, sometimes the data is extracted from table PO_HEADERS_ALL and PO_LINES_ALL, sometimes the data is from table…
-
Payment History Transaction amount getting doubled OTBISummary: We are selecting columns (Supplier Number, PPR Name, Payment method, Payment number Payment status, Payment History Transaction amount, Payment History Transact…Panduleni Kadhepa 34 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Data Migration from EBS to Fusion strategySummary: Could you please provide me with the steps for migrating data from EBS to Fusion? We are planning to move supplier lifecycle management and contract lifecycle m…
-
List of all seeded reports navigation path required for procurement contracts, SCM, ProcurementI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…Santosh Kumar,Rayudu 148 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Getting 403 Forbidden calling BI Pulisher service (ExternalReportWSSService) ?Summary: While calling BI Publisher soap service (ExternalReportWSSService) using JAVA API (jax-ws), we are getting 403 forbidden error. This was working fine earlier, Q…User_ZVJPC 62 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Sorting in eText templateSummary: We have a requirement to sort data based on a tag from XML using eText template Content (required): In eText we can sort based on tags but here we have to sort …
-
Is there a way to predefine calculations in oracle cloud ERP for FRS reportsMost of our Financial reports built using Oracle FRS Web studio are driven by calculations. Managing custom reports becoming more and more difficult whenever there is a …Priya Mandava 31 views 2 comments 0 points Most recent by Priya Mandava Reporting and Analytics for ERP -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 51 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP
-
How to join requisition and purchase order tablesI am using POR_REQUISITION_HEADERS_ALL and PO_HEADERS_ALL to get requisition data and related po data if present. But there is no join between given tables. Please sugge…
-
TIP: Dynamic deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 479 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
I have the following error (PER-1531492) at Enterprise Resource Planning (ERP)The documentation shows me this description : “You cannot create a work measure record for the selected unit because future records exist for the same unit. Delete the f…
-
TSA SQL filter not working when field has date AND timeSummary: Report requirement for all supplier sites set up in last 30 days - issue with TSA SQL filter Content (please ensure you mask any confidential information): I ha…
-
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from…Patrick Chrabieh 91 views 3 comments 2 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
Is there a Supplier Open Balance Letter report in Fusion Payables?Summary: I need a report to list supplier's invoice amount, payment amount, discount amount, prepayment amount applied and remaining balance. Content (please ensure you …Dennis_0427-Oracle 101 views 2 comments 0 points Most recent by Sigrid B. Reporting and Analytics for ERP
-
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb…
-
Issues with Expense Report DFF's in BI Publisher?Summary: In our expense reports, we have several DFF's set up to pull information regarding miles travelled for airfare, car and rail. The fields show up in OTBI, but no… -
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…Venkata Jagan Mohan Vendra 65 views 3 comments 0 points Most recent by Venkata Jagan Mohan Vendra Reporting and Analytics for ERP
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP