BI Publisher
Discussion List
-
How to get party tax profile third party and third party site?We would to get a query to extract party tax profile third party and third party site but but with the one we used we can only extract third parties: Select zxp.PARTY_TY…Ylenia Gentile 172 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global -
Table name to join course with competency/skill/certification details direclySummary: Hi Team, I have one requirement where we need to fetch course wise skill/competency/certification details. Please help to apply direct join to the skill/compete…
-
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
emergency contacts reportsSummary: Hello, I've created report to get emergency contacts for employee below this only part of it. I'm getting error message that subquery return more then one row. …
-
ap_holds_all.last_updated_by as "HOLD_RELEASED_BY"This is related to the AP Invoice tax hold release. We are looking for the table details where the hold released by name will be captured for the AP Invoice. Currently w…POOJAJSINGH 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…
-
Query to fetch the CURRENT and PROPOSED manager for failed transactions in BIP reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can anyone tell which table has USER_PERSON_TYPE column?Summary: I need to access data under USER_PERSON_TYPE column for a report query, the same information we can see from Person Management screen, can anyone tel me which t…
-
Pending worker conversion date in OTBISummary: Pending worker conversion date in OTBI Content (required): Hi, we would like to know where (Subject Area - Folder - Field) we can have the possibility to extrac…
-
Getting "Check Reason" from person managementGood day, Is anyone familiar with the "Check Reason" field in person management? Please refer to the screenshot image below… I'm trying to fetch the values via SQL, I'm …notautomni9 11 views 1 comment 0 points Most recent by TudorV-Oracle Payroll and Global Payroll Interface (GPI) -
Need to create a BI report for AP Invoice Account Coding Status,Coder Name,Comments,Completion DateSummary: We have requirement to create BI report to give invoice level information along with the account coding status, coder name, coder comments and its completion da…Chowdari Malapati Monika 158 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
I am transposing the columns into rows in Excel templateI am transposing the columns into rows in Excel template and also splitting each Employee into separate sheet, but values against rows are not coming up correctly and al…Pavan AlixPartners 1 view 1 comment 0 points Most recent by Pavan AlixPartners Reporting and Analytics for HCM
-
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 1 view 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM -
Query Invoice Group via BI ReportSummary: Content (please ensure you mask any confidential information): Is the business object Invoice Group available as column in one of the AP tables? Its available f…Rory Mullin 164 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Deep link to Invoice attachment in Approval Email Notification is not workingSummary: We are trying to add a link to the Invoice attachments in the PPR approval notification. But the link is not working and an additional URL of the instance is ap…Karishma Mungara-Oracle 111 views 2 comments 0 points Most recent by Mak Sahil-Oracle Payables, Payments & Cash Management
-
Oracle HCM BIP Report - Employee Hierarchy querySummary: I have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 report…
-
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su…
-
Query to get Approver Details of Ad-hoc payment in Cash managementSummary: Need Query or Joins to get Approver Details of Ad-hoc payments in Cash Management Content (please ensure you mask any confidential information): Hello Experts, …Nalsoft Pvt Ltd 184 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management
-
Edit Print Receivables Transactions ESS Job parameterSummary: Edit Print Receivables Transactions ESS Job parameter Content (required): I would like to be able to edit the Default 'Invoice Template Name' in the 'Print Rece…
-
A HCM BI Report is giving extra duplicate pages but the output is valid (the o/p is 1 page gives 2)Summary: A HCM BI Report is giving extra duplicate pages but the output is valid. If the output is 1 page it gives 2 pages of same data only in production environment. I…Chandan M-Oracle 1 view 0 comments 0 points Most recent by Chandan M-Oracle Reporting and Analytics for HCM
-
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationSummary: One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target serve…JEngalan 249 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 RA_CUSTOMER_TRX_ALL from SubscriptionSummary: Need help in understanding how DFF Fields INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 in RA_CUSTOMER_TRX_ALL Table populated for transactions hav…
-
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, …Jessica L. 175 views 3 comments 0 points Most recent by Jennifer-Leung Reporting and Analytics for ERP -
Payslip with custom attachment nameHi All, We are trying to change the payslip attachment name to a different format (emp_name.effective_date.pdf or emp_name.effective_date.pdf). Please let me know if tha…GopalS 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
How can we get attachment to a BI report to be send through e-mail?Summary: Send attachment which is on invoice as part of email with the BI report over email through schedule Report Content (please ensure you mask any confidential info…
-
jg_zz_vat_trx_gt load from JG_IT_TAX_REPORTING_PKGSummary: for extend a standard report in saas I need to know how load semantically the fields of the temporary table Content (required): I would like to know how that pa…