Category 129
Discussion List
-
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana… -
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
QUERY TO GET ESS JOB AND SCHEDULE JOB HISTORYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mohan Gawade 41 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
Limit rows displayed on template in Bi Publisher.Summary: We have a rtf contains 3 paragraphs. The second paragraph should display a maximum of 10 employees per page, and the third paragraph should be displayed on all …Salma Mohamed Salem 231 views 5 comments 0 points Most recent by NagarajuKunchala Reporting and Analytics for ERP
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad…
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
Time Lag when changes in Procurement appear in OTBIChanges made to PO's, Requisition do not appear immediately in OTBI but after a number of Hours? Is there a process that pushes through the Changes to OTBI?
-
How restrict custom BI report data based on flexfield segment valueSummary: How restrict custom BI report data based on flexfield segment value Content (please ensure you mask any confidential information): Hi All, We want to restrict c…
-
Can someone please help me know the table names for the below PVO's?RSI GL Config Job TopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalPeriodExtractPVO FscmTopModelAM.Fin…Srilatha Boddu 21 views 6 comments 0 points Most recent by Srilatha Boddu Reporting and Analytics for ERP
-
How to create a formatted CSV outputHi, The current CSV output format of any BIP Report Layout support only non-formatted CSV. Is there a possibility to get a formatted CSV as per the template designed, Pl…
-
How to export XML sample file from Purchase Order PDF data modelI am trying to export the XML from the standard Oracle Purchase Order PDF Data Model, so that I can import that XML Sample into the RTF Document (using the BI Publisher …Richard Nagle 33 views 3 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 31 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m…Alex Glose 11 views 4 comments 0 points Most recent by James McBride Reporting and Analytics for ERP -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 12 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Getting Null value For Pricelist Name While Extracting CO Item from BIP report inSummary: Getting Null value For Pricelist Name While Extracting CO Item from BIP report in , what can be the reason behind this issue. Content (please ensure you mask an…
-
How to concatenate elements with same name in etext templateSummary: How to concatenate elements with same name in etext template Content (please ensure you mask any confidential information): We are working in etext template for…
-
Does anyone know about what X-invoices format? or ZUGFeRD format? how we can adapt with RTF TemplateCurrently we are using RTF Format template for invoices, and we are sending Invoice details in PDF. But recently Germany business users asking the invoices details in ZU…Srikanth Doodapaka 41 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 21 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 61 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 1.5K views 11 comments 0 points Most recent by User_2Y0JM Reporting and Analytics for ERP
-
cashflow statement report querySummary: Hi All, Does any one have 'Cashflow Statement Report' query?? if you have could you please share. Thanks in Advance. Content (please ensure you mask any confide…Amarnath Podaralla 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad…
-
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be…
-
Hide Catalog Menu from OTBI reportSummary: we open a report from application by the following URL: https://xxxxxxx.oraclecloud.com/xmlpserver/Custom/xxxxx/SCM/Procurement/Purchase disbursement report/PO_…
-
submit multiple HCM Extract from OICWhen I submit multiple HCM extracts from an OIC flow using a while loop for incrementing (1 corresponds to extract 1, 2 to Extract 2 and so on), sometimes I get a SOAP f…