BI Publisher
Discussion List
-
sql query for description details in Manage description rules taskHi Team, Need the sql query for description details in Manage description rules task.Here we have attached the screenshot for your reference We are unable to find table … -
PGP Encryption is producing a .tmp file at vendor's endWe are using the public key provided by the vendor to encrypt the file being sent to the SFTP using the HCM Extracts vis BIP delivery. When the vendor is decrypting the … -
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to add Days to Worker Hire Date in HCM Alert TemplateDear Team, Need help in rectifying below expression. ${AlertUtils.addDays(workers.workRelationships.StartDate, 10)} I need this add 10 days to hire date of an employee t…
-
Sample Attendance ReportSummary: Sample Attendance Report with a placeholder to capture signatures Content (please ensure you mask any confidential information): Could someone please share an A… -
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
Filter PER_EXT_PAY_EMPLOYEES_V2_UE to get the assignments of employees with payroll results onlySummary: Our custom HCM Extract contains the following UEs (per hierarchy): 1. PAYROLL ACTIONS RANGE UE (Root Data Group) 2. PAYROLL REL ACTIONS RANGE UE (Connected to #…
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 41 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Join XCC_BALANCES with PO tablesContent Hi all, I need to retrieve the budget available amount (see screenshot below) I found the amounts in the table XCC_BALANCES. But I can't find a way to join it wi…
-
Oracle Fusion Applications HCM Learning Deprecated PVO'sHello Oracle Learning Community, As part of the Oracle Fusion Applications Cloud R13 update, we noticed that several HCM Learning Public View Objects (PVOs) used for dat…
-
Using Multiple SSL Certificates for Different PrintersDear All, I have multiple printers and multiple SSL certificates. I need to use a different SSL certificate for each printer. However, when I enter the Delivery configur…George Mattar 21 views 0 comments 0 points Most recent by George Mattar Payables, Payments & Cash Management
-
Tax Box Allocation Data Model - Sample XMLSummary: Are you able to share sample XML for the "Tax Box Allocation Data Model", in order to support template customization. As the main source table (JG_ZZ_VAT_TRX_GT… -
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Query Supplier Account Bank Information TableSummary: I Want to export all information about supplier account bank via BI Report Content (please ensure you mask any confidential information): Supplier on Procuremen…Muhammad Fahmi 133 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management
-
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 21 views 0 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…GaneshSKulkarni 2 views 0 comments 0 points Most recent by GaneshSKulkarni Reporting and Analytics for HCM
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 123 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 31 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 51 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 42 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
Request to Exclude Zero-Amount Records from Standard Customer Statement ReportHi Team, We have requirement in the standard customer statement report output and require a solution or workaround to exclude zero-amount records from the report. For re…Raman_Balasubramaniam 41 views 3 comments 0 points Most recent by User_VQFGM Receivables & Collections
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …