Sample Reports
Discussion List
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p… -
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 13 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…Tom Harris 31 views 2 comments 0 points Most recent by Sandeep Pati-Trinamix Supply Chain Planning and Collaboration
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 458 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…Bobba Anil 61 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…Isaac_s 86 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 18 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM
-
sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Rahul K-Oracle 22 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 51 views 2 comments 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service
-
abcdabcdShyam Rajbhar 11 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Query to get Roles hierarchySummary: A query to get role hierarchy by role ode Content (please ensure you mask any confidential information): Want a query where i can pass the role code, and get al…Osama_Mo 244 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
sql to fetch organizations or departments based on business unitHi Team, We are trying to write sql to fetch all organization or departments for a business unit. But we dont know how to link organizations to business unit. To tell yo…RamNarayan-Oracle 265 views 1 comment 0 points Most recent by IpsitaGhosh-Oracle Human Capital Management
-
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 62 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
hcm - document of records - flex fields and attachmenthcm - document of records - I NEED TO GET THIS SAME FIELDS TO BE AVAILABLE IN DOCUMENT OF RECORDS APPROVAERS AND IN EMAIL AS ATTACHMENT -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 104 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 94 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 214 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Best way to create reports from Oracle General Ledger data?What's the recommended approach for building custom reports from Oracle General Ledger data.I'm building a custom periodic trial balance report in Oracle. I need to incl…Omran Zeaiter 21 views 4 comments 1 point Most recent by Jagdish Kumar Arora General Ledger & Intercompany
-
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no…Lizy Lazaro 14 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM