Category 129
Discussion List
-
Getting Null value For Pricelist Name While Extracting CO Item from BIP report in EGUP-TESTSummary: Getting Null value For Pricelist Name While Extracting CO Item from BIP report in EGUP-TEST, what can be the reason behind this issue. Content (please ensure yo… -
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…
-
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 31 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 29 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 19 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create Bursting without linking / upload attachment to a Transaction?Summary: Hello, we are using a customized Datamodel for the Print Receivable Transactions process. We also use our own bursting which creates multiple PDFs for a transac…Frank.Steinjan 9 views 0 comments 0 points Started by Frank.Steinjan 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 60 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 798 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…Aloka Bhattacharya 6 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for ERP -
Unable to run any custom FRS report after migrating the report from Test to ProdSummary: We have created almost 20 FRS reports in the TEST environment. After completion of the UAT, we are trying to migrate the report to PROD environment. After migra…Abhash Garg 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 22 views 0 comments 0 points Started by Rocha, Diego Rodrigo General Ledger & Intercompany
-
Ability to restrict access to specific FAH Subledger tables for creating new data modelSummary: Ability to restrict access to specific FAH Subledger tables for creating new data model. This is needed to restrict personal information which is coming from so…
-
Can we customize 'Yearly Withholding Tax Report for Italy' report ?Summary: There are 2 requirements as below To add a period parameter 2. To add a new field on the report (The report uses a global temporary table, so how to know inform…Ankit Parikh 1 view 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 21 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
A report that will show the Fusion Role's last update dateGood afternoon. I wonder if there's a Fusion Report that will provide the date when the Fusion roles were last updated? Let's say a specific role was updated by Oracle d…
-
How to stop/disable email bursting from BIP reports after P2T refreshSummary: Hi All, We have multiple custom BIP reports with email-bursting queries. When the P2T happens, we want to disable the email bursting from the custom reports. Si…
-
ERP BI Publisher - HTTP Data SourceWe are planning to use an external API as a data source in BIP within Oracle ERP Cloud. Can anyone confirm if "HTTP" as a data source will be de-supported in a future re…Rohit Varma - Architect 24 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…Karun_Jain-Oracle 2.1K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 20 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reportsHi Guys I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, but would like to know if this is still relevant for the latest versions of Orac…
-
Is it possible to pull the approvers for Job Requisition Approval?Summary: We are trying to create a BI report to know with whom the Job Requisition Approval is pending with. We have used the below query to pull the details but when th…Raje 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ERP FDI - Report to identify potential duplicate payments in APThe customer is currently using ERP FDI Live and wants to implement a report to identify potential duplicate payments in AP. They have already searched in the list of Pr…Mauro Roberto Rodrigues-Oracle 41 views 3 comments 0 points Most recent by Mauro Roberto Rodrigues-Oracle Payables, Payments & Cash Management -
Issue to get PO Lines accounting details from GL sideWe need to retrieve the PO Lines accounting details along with the net balances. But we are unable to obtain the PO Lines accounting details from the GL-level tables. We…Sushan Peiris 18 views 1 comment 0 points Most recent by Priti-Oracle Reporting and Analytics for ERP -
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …Vipul_vipul 3.3K views 10 comments 1 point Most recent by Ron van Wolferen Reporting and Analytics for ERP
-
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…