Data Models
Discussion List
-
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. -
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 3 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 3 views 0 comments 0 points Started by Visvanath-Oracle BI Publisher Learning Center -
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…
-
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 21 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
-
What values should be provided to lexical parameters for seeded data model for Asset Register ReportWhat values should be provided to lexical parameters for seeded BIP data model for Asset Register Report - *&L_INVOICES *&L_SOB_INV *&d_category_segs *&d_asset_key_segs … -
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 1 view 0 comments 0 points Started by Manu Krishna T M BI Publisher Learning Center
-
Custom UCM datasource To Retrieve The Text Attachments for PDFHi. I used this document: How to create Custom UCM datasource To Retrieve The Text Attachments for PDF ? ( Doc ID 2643214.1 ). I was able to follow all of the steps and …Paul H - Terillium 66 views 3 comments 0 points Most recent by Narasimha Raju BI Publisher Learning Center -
How to call fast formula using procedure call sql typeHow to call fast formula using procedure call sql type such that i can use for the remaining calculation to build BI report.
-
How to keep rich text format bip report in Excel output.We are using rich text format for Questionnaire answer format. can we possible to fetch below like links & Bold format in excel output.
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
How to call one particular data model query into another report's Data Model without repeat query.We had a requirement that I have to use the query written in report-1 in report -2 without writing the whole query. I just want to refer that report-1 query and will bui…
-
What does the asterisks in table comments mean?Hi all When reading the table definitions, for example here: https://docs.oracle.com/en/cloud/saas/project-management/25a/oedpp/pjcexpitemsall-24862.html#Details there i…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm BI Publisher Learning Center
-
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIPHarikumar S - NetApp 21 views 0 comments 0 points Started by Harikumar S - NetApp BI Publisher Learning Center
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…Parthiv_Patel 57 views 3 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa…Varun Dhondea 112 views 2 comments 0 points Most recent by Varun Dhondea BI Publisher Learning Center -
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…Aditi Agrawal2650 19 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?Aditi Agrawal2650 1 view 0 comments 0 points Started by Aditi Agrawal2650 BI Publisher Learning Center
-
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…
-
Unable to retrieve Reviewer's data for an employee in Talent review meeting using TablesWe are unable to make an BI Report on Reviewer's data using oracle tables. We got the list of participants for an particular review meeting but unable to fetch the Name …
-
How ESS Job Parameters are mapped to BIP Data ModelI would like to know how ESS Job Parameters are mapped to the BIP Data Model? I have a BIP Data Model with some mandatory and optional parameters. I would like to use a …
-
which tables stores interview evaluation feedbackHi Team, May I know which tables stores interview evaluation feedback ? If possible can I get a snippet of SQL code ? Regards, Harish
-
How can we send a file at UCM on "prc/supplier/export" folder location?Hi I want to send a supplier report at UCM on "prc/supplier/export" folder location using bursting, but I'm not able to find this location. There is only "prc/supplier/i…
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …Kratika Sharma 199 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center