BI Publisher
Discussion List
-
Generate Purchase Withholding Report for Colombia report is not showing any OutputSummary: While we are submitting the above subjected report, its not showing any output and we have Invoice and WHT and Payment data for this country. Report is blank. C… -
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 91 views 2 comments 0 points Most recent by Linga Murthy Payables, Payments & Cash Management
-
Possibly changing from CCD to CCD+. Where do we store additional data?Summary: We are looking at changing our ACH remittance from CCD to CCD+. I'm wondering where the information we'd put in the Addenda record (Record 7) would be stored in…
-
Unable to find Legal entity infomration at document sequce category tablesSummary: Hi Team, Any one have sql query on same requirment in your experiance. I used below tables. FND_DOCUMENT_SEQUENCES FND_DOC_SEQUENCE_ASSIGNMENTS FND_DOC_SEQUENCE…Koppala Hari 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Payables Matching Detail report blankSummary: Hi Gurus, Payable Matching Detail report is not returning any data inspite of nominating BU & PO# parameter. I do have 'Accounts Payables Manager' role assigned…Amrish_Amradkar 11 views 3 comments 0 points Most recent by Amrish_Amradkar Payables, Payments & Cash Management
-
Need Standard Report or Table details for AP approver and each approver limit detailsSummary: Need Standard Report or Table details for AP approver and each approver limit details Content (please ensure you mask any confidential information): Hi, We want…CHIR 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 520 views 9 comments 1 point Most recent by ShrutiSood Payables, Payments & Cash Management
-
For Disbursement Positive Pay File Formats Report; below ETEXT format is requirement.Summary: In the Disbursement Positive Pay File Formats Report output file, we want a single payment header 'A' type record and single payment trailer 'Z' record even tho…MANI SATYA SAI CHERUKURI 3 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
RTF template doing sorting by name is there any data restrictWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Payment File submission to Natwest Bankline using BI Publisher deemed now as non compliantSummary: Natwest Bankline contacted us late 2023 to state that the OracleCorp XML Publisher software that is used to SFTP the payment file across as being Non-Compliant …
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 31 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 160 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
is there any rest api to get all rejected ap invoices?Summar Summary: Is there a REST API available for fetching all rejected AP invoices? If yes, how can it be utilized? Content: [Please provide any relevant information] V…Nikhil Pande 11 views 1 comment 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management
-
Is there a way to add field in Edit distribution feature on the BPM notificationIs it possible to pull the accounting date field into the BPM notification and make it editable when using the edit distributions feature on an invoice notificationAkanksha Bhardwaj 32 views 5 comments 0 points Most recent by Tara Ebarb Payables, Payments & Cash Management -
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 37 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to get organization ID and name of bank statement data?Summary: We are trying to create custom BIP report that would output the bank statement import errors and successful data. Among the fields required by client was to add…Patricia Azucena 9 views 1 comment 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Test Changes to AP ChecksSummary: Is there an easy way to test the formatting of AP checks? Content (please ensure you mask any confidential information): We recently had to make a change to our…Raz Baboorian 35 views 4 comments 0 points Most recent by Raz Baboorian Payables, Payments & Cash Management
-
Table with error messages and warnings of Supplier Bank Accounts FBDI ImportContent Does anyone know if the error messages and warnings of the Supplier Bank Accounts FBDI Import are stored in a base table of which we can report through BI Publis…
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma…
-
Printing the check number at the bottom of the physical AP Check reportSummary: We have created a custom AP Check RTF template based on the client's requirements. The custom RTF template is used in the Disbursement Payment File Formats repo…shrikardixit 23 views 1 comment 0 points Most recent by Trang Tran UCD Payables, Payments & Cash Management
-
Send Separate Remittance AdviceSummary Send Separate Remittance Advice process completes successfully but mail notification not receivedContent Hi All, We have Setup the Separate Remittance Advice and…Surya Muralidharan-185000 125 views 10 comments 1 point Most recent by Velsy Payables, Payments & Cash Management
-
SUPPLIER BALANCE AGING REPORT Showing invoices in Unallocated AmountSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (please ensure you mask any confidential information): The accounting event…
-
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…Shraddhha Namde 161 views 11 comments 0 points Most recent by B Sekhar Reporting and Analytics for ERP
-
Generate ISOXML Payment Files in non-EnglishSummary: All our data entered for Suppliers and Bank Accounts were in English. We have countries like China, Taiwan, Japan and Korea requiring to send the files in local…Mani.Kumar 2 views 3 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
SQL for Invoice Status based on As-of DateHi Team, Can you please help provide a sample SQL where I can select the invoice amount and status based on as-of date. For example, as of 24th Jan 2024.. invoice 001 wa…Kaz 42 views 2 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 136 views 8 comments 1 point Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
Payment infotile on the Invoices landing pageSummary: Starting Update 22C, the Payment infotile on the Invoices landing page is no longer be available. Has anyone recreated the Infotile, and can share? Content (req…AVorster-Oracle 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is there a way to index a DFF Attribute?Summary: Our solution calls for use of DFF attributes to capture data from boundary applications that should be used as parameters and filtering in BIP/OTBI reports and …
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your knowledge or experience here. Content (please ensure you mas… -
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs …