Data Models
Discussion List
-
How to convert User Defined Table text to date in BI PublisherHello I'm trying to work with a User-Defined Table (UDT) and am running into reporting issues working with the data in BI Publisher and am looking for help. The business… -
Is there a limit on number of parameters that can be added to a BIP report/Data Model?Hi Team, Is there any restriction to add number of parameters in a BIP Report? Thanks, SatyaChinnamsetti Satyanarayana Swamy 2 views 0 comments 0 points Started by Chinnamsetti Satyanarayana Swamy BI Publisher Learning Center
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…
-
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 8 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
How can I build an ASL report in BI Publisher with supplier, item, and organization names?Hello, I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enric…
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…Sonia Choudhary 13 views 0 comments 0 points Started by Sonia Choudhary BI Publisher Learning Center
-
bi report and otbi svswe have svs but is possible to have bi report and otbi with svs apply? how can i do?
-
Is there any table which stores Subledger balances for sources like Payables and specific accounts?I need an information about the tables through which Subledger level balances for specific sources like Payables, Receivables and Fixed Assets and specific accounts (GL_…
-
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio…
-
Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?
-
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report. -
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report.
-
What Value should be provided to Lexical parameter for Seeded Report Data modelHi All, What value should be provided to below Lexical parameter for Seeded Report Data model of Uninvoiced Receipts Accrual Report ? &ACCRUAL_ACCOUNT &CHARGE_ACCOUNT Th…
-
How do I adjust time zone ins rtf date fieldI'm configuring a RTF template to a term document, but here's my problem, in that document it must contain the from date of a compensation plan, but when I put the field…Lucas Gaspechach 1 view 0 comments 0 points Started by Lucas Gaspechach BI Publisher Learning Center -
Need the last modification date of 'Generate Audit Report'Hi Cloud Community, Currently, we don't have access to data model/report for the seeded report 'Generate Audit Report' in Oracle Cloud Fusion. Business user has a requir…Tushar_Singhania 1 view 2 comments 0 points Most recent by Tushar_Singhania BI Publisher Learning Center
-
SQL Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot -
CTE does not work for all casesI’ve received a request to create a BI Publisher report that meets the following business requirement: Given a date parameter (e.g., 31/12/2024), the report must return …
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se…
-
Bi Publisher data model parameter not displaying into Bi publisher report parameterHi Team, I observed one issue in FDI Bi Publisher environment data model created with List of Values and parameter. Data model working perfectly. But when same data mode…Indranil Basak-Oracle 13 views 0 comments 0 points Started by Indranil Basak-Oracle BI Publisher Learning Center -
BI Publisher - Obtain YTD / accumulated payroll balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…Visvanath-Oracle 2 views 0 comments 0 points Started by Visvanath-Oracle BI Publisher Learning Center
-
How to pass Request Payload for POST Method in BIP DataModelI 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 the request payload for …
-
From which table can I obtain the name of the owner of a Succession Plan?Starting from this query, i try to obtain the name of the owner plan but without results. Can you help me with one suggestion, please? SELECT HP.PLAN_NAME, HP.PLAN_TYPE,…
-
How to update a DFF field from a BI publisher report?We need to modify Generate Extensible Work Order Traveler Report and accommodate a print counter, last print date, last printed by at the top of the report. The purpose …
-
Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink SupportWe have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application p…Tauseef-Oracle 29 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
How to remove new Line from a clob column?Hello experts, I am trying to write a report which includes a CLOB column. But in the table there's blank line in every row, and getting an issue in excel output where t…
-
Columns removed while editing the dataset in Data Model for BIP reportHi All, We are editing the 'Statement Generation Data Model' ,. We have few existing columns which are available in the Structure diagram, but same is not available in D…Satyanarayan Panda 22 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center