BI Publisher
Discussion List
-
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t…Bhupesh 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Customize CAMT.053 TemplateSummary: Hi All, We are looking to customize camt.053 template, and referring below document, but the instructions are not clear, do we have any better reference to cust…
-
-
How to use the Maximum Price field if NULL or Blank for Learning Request ApprovalSummary: We have configured this condition "(Learning Item.result.Maximum Price == null)" from Learning Request Approval rule but it is not working. Our requirement with…
-
How to map out Repeat/Recurrence in BIPSummary: Where can I find the table that could be used to pull out Repeat/Recurrence found in Scheduling Details in Offering Activity in HCM UI? -Where to find the field…
-
Extract output file name concat with the extract parametersSummary: Hi All, I am working on a HCM extract where requirement is to generate the output file name which contains the interface name concats with the parameter as ment… -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 62 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Need to fetch Score/Actual Scorein the BI ReportSummary: Need to add Score/Actual Score to the existing BI report which is coming from Manage Activities page. Can anyone please help me with table names or SQL to fetch…
-
BI table name to fetch Module from Manage common lookup screenContent Hi Experts, I have a requirement to fetch module from manage common lookup screen. Please help with relevant BI query. Thanks SandipSandip Karmakar 233 views 8 comments 0 points Most recent by User_2FZC5 Reporting and Analytics for HCM -
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …chandrakanth makam-Oracle 37 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for HCM
-
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Linking courses using an Analysis CriteriaWe are a new Oracle customer and so new to creating Analysis criteria and we want to use this functionality to create an audience for some compliance refresher training …
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 195 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Completion Certificate report not populatingSummary: After creating the report in BI Publisher and proceeding to "Configure Catalog Defaults" and enabling "certificate" for both Course and Specialization, the repo… -
Golden tax outbound processSummary: Once generate the file, what are the steps to transmit the file to Aisino system ? Content (please ensure you mask any confidential information): Version (inclu…Krupa.B 11 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way …Luke.Findex 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Learning Management Real Time RemovalSummary: Will it be removed or not anymore? Content (required): There were news way back 21A about the removal of the Learning Management Real Time Subject Area. Is it s…
-
Does oracle provided any learners reporting dashboardSummary:Does oracle provided any learners reporting dashboard ? Do we have any standard dashboard on oracle learners reporting? Content (please ensure you mask any confi…
-
Which table stores the output data of the Print Receivables Transactions Email Delivery: InvoicesHi Everyone, Can anyone point me the table which stores the output of the Print Receivables Transactions ESS job especially the child ESS job - Print Receivables Transac…A Vigneshwar 492 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 122 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa…Valerio Curzi 11 views 3 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 231 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM