BI Publisher
Discussion List
-
Data missing in xla_transaction_lines tableWe could see the data available from 07-Nov-2024. Previous dates data are missing. Is there a automatic purging happening ? -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
How to output of a BIP Report in multiple excel sheets in XLSX format?Hi we would like to know if there is the way to output of a BIP Report in multiple excel sheets in .XLSX format. Currentry we can see only .XLS format is avaiable when E…Karen Ito-Oracle 71 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 541 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Standard report to see the default expense account of an employeeSummary: The client is looking for any standard reports to check the default expense account assigned to an employee Content (please ensure you mask any confidential inf… -
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 31 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 448 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to default invoice template on collection dashboard preview screenIn collection dashboard when you select customer delinquency there is option of preview, when i click on preview it;s picking INFUSION default template . How to default …charanjeet 1 view 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
How to auto increment the date parameters of the seeded report?Summary: I need to schedule the report on a monthly basis and will auto increment the said parameters. Payables Invoice Register: -From Entered Date -To Entered Date -Ac…Mikee Tamonan 54 views 5 comments 1 point Most recent by Venk Kudire- Support-Oracle Payables, Payments & Cash Management
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 352 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Meaning of Obsolete Status in WLF LEARN EVENT tableSummary: Meaning of Obsolete Status in WLF LEARN EVENT table Content (please ensure you mask any confidential information): Hi Team, Greetings! It has been observed that… -
Referencing parent and parent of parent xml data for bip templateSummary: I want to call a parent two and three levels up from my main for-each statement. How do I achieve this? Content (required): This is my xml layout My code is bas…
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 101 views 3 comments 0 points Most recent by Ranveer.Tiwari-Oracle Reporting and Analytics for ERP
-
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 737 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Required REST API to get Predefined Validations undern Manage Payment MethodsSummary: Hi Team, We need REST API to get Predefined Validations and their parameters undern Manage Payment Methods setup and attached screenshot for reference. Content …
-
Link between ZX_RULES_B and ZX_STATUS_B in oracle fusion TaxSummary: Got a requirement to link these two tables to generate report for Tax Rate and Rule Content (please ensure you mask any confidential information): Version (incl…
-
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar…
-
Dunning Letter email - missing body text messageHi, We are implementing advance collection and setup all items for dunning letter email. We are able to get the email with PDF as attachment but email body message is bl…
-
Custmization on AR Transaction Image ,error occurred File name must end with .xdoz / .xdmz / .xssz /Hi Team , when I changing the query, system asking for Lexical parameter . For this issue , I found below documentHow To Work With the Lexical Parameter Value When Custo…Sandeep.kumar2454 21 views 4 comments 0 points Most recent by Sandeep.kumar2454 Reporting and Analytics for ERP