BI Publisher
Discussion List
-
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme… -
Regarding "SEPA Credit Transfer Initiation" paymentHello gurus, Good day! 1. I would need the original copy of "ABBL XML FORMAT" the xsl template for the "SEPA Credit Transfer Initiation (with unstructured remittance det…viji_r 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
How to fetch "Check Payment Status" and "Check Issued State" in HCM for US Payroll ?Summary Hi All, Kindly help me to fetch the details of the Check payment as in HCM. As I required a few below columns: Check Payment Status: What is the current status o…abhjkum-Oracle 27 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Check Printing IssueSummary: Overflow in Check Printing Content (please ensure you mask any confidential information): We have to customize the out of the Box Check Printing report. Above t…KetanDoshi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' ?From which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' screen in Oracle Fusion Payables as attached?Nirosha Yelicherla 61 views 4 comments 0 points Most recent by lkarthik-Oracle Payables, Payments & Cash Management -
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 35 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…LE 16 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
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 23 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
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 120 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 95 views 2 comments 0 points Most recent by Mak Sahil-Oracle Payables, Payments & Cash Management -
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 125 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management -
The value of the attribute Bank Name isn't valid.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Pazhanivel 38 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Need the exact table in Fusion for the column "STAGE" in the Manage Payment Process Requests screenHi Everyone's I am having difficulty finding the 'Stage' column in the Fusion tables under the navigation: Payables → Payments → Manage Payment Process Requests → Stage …lkarthik-Oracle 31 views 3 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management -
How to get IDR details for a Payable invoiceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nepal Bhumireddy 11 views 3 comments 0 points Most recent by Nepal Bhumireddy Payables, Payments & Cash Management -
How to JOIN AP_CHECKS_ALL table with per_all_people_f or per_all_assignments_m table in Oracle HCM ?Summary: Hi All, I was preparing a report which required all the check payment of US employee. In order to complete this I have to join a table which contains the check …abhjkum-Oracle 52 views 1 comment 0 points Most recent by Kishore S Payables, Payments & Cash Management -
Setup required to transmit Positive Pay File for payments/checks created via Quick PaymentSummary: Could someone please provide assistance on how to transmit a Positive Pay file to our bank's SFTP if the check payment is made via Quick Payment? Content (pleas…Christian Roxas 135 views 6 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management -
How to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header?Summary: We want to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header since our invoice approvals are based on this field and mos…AkashAgarwal 33 views 2 comments 0 points Most recent by Harsh Masharu Payables, Payments & Cash Management -
How can I find AP invoice Accounted by for my custom BI report?Please help with the queryAditi Agrawal2650 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Invoice Document RecognitionSummary: When we run the schedule process - Invoice Document Recognition , we just want one column i.e subject. Is there any way or any report available which I can use …Sujatha Kumari 41 views 6 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management -
How to import a data from Oracle cloud to OTBISummary: Hi, we try to create a analysis in OTBI using a Payables Invoices - Installments Real Time Subject area, but we didn't get the any results, In ERP we have roles…Alex Pagliarini - Ninecon 13 views 1 comment 0 points Most recent by Abi Osborn Payables, Payments & Cash Management -
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…daniel4u2uk 509 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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 34 views 3 comments 2 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Withholding Tax for Offest TaxSummary: Need to apply Withholding Tax on AP Invoice that has a Tax Rate + Offest Tax Rate (Gross Amount = Net Amount). System doesn't consider the offset tax rate for w… -
Cheque specimen signature to be updatedSummary: Need to update the cheque specimen from one person to other. As the last day is August 29th; the next payment run is scheduled for September 5th so the cheque s…Gifty V 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management -
Audit Receipt Accrual Clearing Balances ReportIn receipt accounting you have this report that can be run from the screen. I have not been able to find a way to do this without exporting the data from the screen. Is … -
Can we customize the standard report with Internal tables provided by oracle? I found them empty.Summary: CCC-Internal tables provided by oracle do not have the data and unable to verify our customizations Content (please ensure you mask any confidential information… -
we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 7 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Static IP for sftp connectionSummary: Do you know if Oracle can use a specific IP address to transfer data to the SFTP server? We have configured a connection to the sftp server via OTBI/BI Publishe…Daniel Sobotka 26 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
Creation of positive pay files with bank account appending to the file nameSummary: Creation of positive pay files with bank account appending to the file name Content (please ensure you mask any confidential information): Creation of positive …Arun0130 42 views 3 comments 1 point Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management