BI Publisher
Discussion List
-
what are the tables where i can find project and its accouting detailsSummary: Hello , I want query or table names from which i can pick projects inofrmation of accounting like GL_date ,Account number,Account description. I am attaching th… -
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…Sourabh Patial 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
Show the postal 4 zip code on AP checkWe need to show the postal 4 zip code (postal code extension) in our AP check template, but the xml is not showing the field (Select document From iby_trxn_documents ord…Alvaro Artavia 41 views 3 comments 2 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …SERGIO BARRETO 121 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 21 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 555 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 23 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Change format date for Completion Course Certificate templateSummary: Hello all, We're modifying the data template for the Completion Certificate Course using BI Publisher. We need to change "COMPLATION DATE" data format. Analyzin… -
FA to GL Reconciliation Report at Asset Category (Capital Asset Rollforward Report)Hi Team We are building a custom report to reconcile FA cost and Accumulated depreciation balances between FA and GL, at the Asset Category level.. We are facing few cha… -
In oracle fusion Expenses in which table we will get itemization dateEmployee expenses Itemization date in which table we will get .For itemization few expenses I am getting wrong date in EXM_EPENSES table START_DATE column I considered a…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 83 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table used to store children custom objects!!Hi, We created Custom object "Proposal" and created child custom object from the parent object with name "Payment Plan" The parent custom object "Proposal" store its rec…Wesam Ibrahim 71 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊Michael Angelo Lucena 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p…Clare Murtagh 1 view 2 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for HCM -
Unable to find Ending balance column in GL balance TableI am looking for a Ending balance for a particular account in gl_balances table. Is any other table contains this value ?
-
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Birthday alert with Background imageSummary: i have a birthday alert requirement and whenever i try to put the image as background using watermark option, rtf file size is getting increased and getting bel…AshokPothula1 21 views 0 comments 0 points Most recent by AshokPothula1 Reporting and Analytics for HCM
-
How to show amount of times a report has been run?Summary: The 'OTBI usage real time' subject area can't show usage of reports - how to report on this? Content (please ensure you mask any confidential information): We h… -
CCC IMPL BICC Not Showing all FieldsSummary: Hi Team, We have application composer object created and it included number fields like ( Account Number, Site Number) looks like only id's are showing up in th…