BI Publisher
Discussion List
-
How to extract data from an xmltype columnSummary: How to extract data from an xmltype column that is in the table ZX_CONDITIONS Content (please ensure you mask any confidential information): I am trying to put … -
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…Siva Gollapalle 111 views 5 comments 0 points Most recent by Nikki K Reporting and Analytics for ERP
-
How to bulk download HCM Extract/Payslip data xml files from past 1 year runSummary: For a third party integration, we need to download payslip data xml files for past 1 -2 years. Data XML is not defined as extract delivery option. The only way …
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to get the Path of Sub Templates of Total Compensation Statement Seeded ReportSummary: We have a requirement to Customize the Total Compensation Statement Seeded Report Template We are not able to get the path of the sub Templates used in it. Cont…MilanMohanty 41 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
RTF - Display hypen instead of 0 for currency amount in excelSummary: Hello, I was wondering if it is possible to display the Excel Accounting 0 value as " - $" (as below) using RTF template. I currently use this format 999G999G99…Guillaume SAVALL 41 views 2 comments 0 points Most recent by Guillaume SAVALL Reporting and Analytics for HCM
-
Link a report to a button near to the All-in-One evaluationSummary: Content (please ensure you mask any confidential information): Hi experts, I need to add a link that redirect me to a dashboard. Is it possible to achieve it th…Elena_Panniello98 11 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
When is status change type ORA_DELETE_AUTO used?Summary: Cannot find ORA_DELETE_AUTO in the HCM lookup tables despite being visible in status_change_type for WLF_ASSIGNMENT_RECORDS_F. When is this used? Content (requi…
-
23D HIDE RECOMMENDATIONS FOR COMPLETED LEARNING "No Alert Trigger"Once learners start learning items, that recommendation will get withdrawn, and there is no alert trigger for withdrawn items as well as for the recommendation. On the l… -
Which action for a DEEP LINK can I use to manage a REQUSITION in DRAFT status?I need to create a custom notification with a link that leads to the detail of a requisition that is in draft status. I've tried with this deep link: //fndSetup/faces/de…Gian Luca Triglia 31 views 5 comments 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 130 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report - Hourly/Salaried vs Rate Value for the GradeSummary Looking to crate a report to get Hourly/Salaried vs Rate Value for the GradeContent From Person Management - Get If person is Hourly or Salaried. Then navigate t…SD Acush 71 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 131 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output fileI have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the last update…Deepa Kumari 52 views 3 comments 0 points Most recent by Deepa Kumari Reporting and Analytics for ERP
-
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app…Sowdha Murugan 11 views 1 comment 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Link/tab or any option on create Journal pageSummary: Hi Our requirement is to looking to take the print out the Journal page, Is there any feature or url/link/tab to add enable at Journal level so that user can cl…MGS tech 31 views 6 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 81 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
How to join cmp_stock_details & hrc_integration_key_mapSummary: We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_ma…Niharika 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 103 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
Change in the environment from production to test in links to reportsHi, We want to change links to BI PUBLISHER reports within the dashboard. When we do P2T we need to go through all the links and change them from the production environm…Alex_Balanovsky 42 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Customize option is not visible.Summary: Content (please ensure you mask any confidential information): Cannot view customize option on talent fyi notification record. is there something i'm missing? V…Pranjal Mohla 235 views 2 comments 0 points Most recent by Pranjal Mohla Reporting and Analytics for HCM -
Need to implement digital signatureSummary: Hi Content (required): We need to implement digital signature on Invoice print pdf generating through BI Report. According to Oracle Docs, This will be only pos…Heena 41 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 132 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Receivables Aging by General Ledger Account Report - Group by Natural Account segmentRequirement is to group Receivables transactions in "Receivables Aging by General Ledger Account Report" by Natural Account segment only, not by alll Chart of Account di…
-
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
Oracle BI Tables to retrieve manager hierarchy level and Plan Access LevelSummary: Content (please ensure you mask any confidential information): Hello experts, which Oracle BI tables allow me to retrieve manager hierarchy level and plan acces…Valerio Curzi 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM