Data Models
Discussion List
-
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 108 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 150 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 14 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 259 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center
-
Custom SQL Returns Only One RecordI am working on a new report using the below SQL and I am only seeing one Record when running it. I have confirmed that there are many users with no additional assignmen…Nathaniel.Wilcox 2 views 0 comments 0 points Started by Nathaniel.Wilcox BI Publisher Learning Center
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…P.S.Nikhitha Muduliar 22 views 1 comment 0 points Most recent by Shrikant Nene-Oracle BI Publisher Learning Center
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Do all view tables hold data constantly or is there a process to get the information to showHello, I'm using the view FND_BPM_TASK_HISTORY_VL to see the history of tasks and approvals for transactions. This is to create a report to show the approval workflow fo…
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI?
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
query to get the tax liability account of the tax rateHi, Could you please advise in which SQL table can I find the natural account of the tax rate. Setup and Maintenance → Financials → Manage Tax Rates and Tax -Recovery Ra…Elyse Meouchi 110 views 1 comment 1 point Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax)
-
Is There an way to Default BI report Text parameter to logged in user person id like in Date typeIs There an way to Default BI report parameter to logged in user person id like we default System data in Date type parameter {$SYSDATE()$}. We have a Text parameter whi…
-
How to find redline change data in the OBI tablesHi Experts/Team, Is there any OBI table that stores if any attribute is redlined on a change order, redline information i'm looking for a specific attribute is redlined …
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor…
-
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
query to get the due date in payment under invoices to payHi, Could you please advise in which SQL table can I find the Due Date in Payables → Payments → Create Payment under Invoices to Pay. Thank you.Elyse Meouchi 1.1K views 2 comments 0 points Most recent by Stephen Westerfield-Oracle BI Publisher Learning Center
-
how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not RESTsome apis require the GUID to update a record , not the id or rowid We can retrieve that value using REST api (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoic…
-
Query to get the tax name and rate from a draft invoice under contractI need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists a…
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sqlSravan Kumar Meka 1 view 0 comments 0 points Started by Sravan Kumar Meka BI Publisher Learning Center
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Thulasi Ram 113 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center