BI Publisher
Discussion List
-
How to check the date when we enabled audit trail in Oracle ?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… -
Has anyone has experience with updating the 1099 NEC Copy B template?We are looking to make some changes to our 1099 NEC Copy B pdf template. Does anyone has some experience editing the pdf template?Jay Ruthiran 2 views 2 comments 0 points Most recent by Jay Ruthiran Payables, Payments & Cash Management
-
SQL Query to get the AP Invoice Validation DateHi, We have a requirement to determine the Invoice validation date . Please help us to get the query for the same. We tried using creation_date of xla_events by joining …Hitha Harikumar 883 views 5 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management -
How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…
-
Need a SQL Query Help To Fetch Non-PO Matched Invoice Lines (Account Payables)Summary: Our requirement is to fetch the Non-PO matched invoices, the query should even exclude Invoice lines which are associated with PO. Only Invoices without PO (at …Jayaram AnuPriya-Oracle 32 views 2 comments 0 points Most recent by Jayaram AnuPriya-Oracle Payables, Payments & Cash Management -
Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 207 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 22 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP
-
ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management -
Table Name for Approver's Data of BPM Worklist along with History of Approver'sSummary: Issue : Table Name for Approver's Data of BPM Worklist along with History of Approver's for a Person whose Task are Completed Now We want Table Name's for Appro…Roy Aniket 55 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Payables, Payments & Cash Management
-
Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML FileSummary: Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML File Content (please ensure you mask any confidential information): We are …Christian Roxas 24 views 2 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management -
disable custom BIP report parameter once it's been selectedSummary: Content (please ensure you mask any confidential information): I have a custom BIP report it has parameter (list of value), say Invoice Number from AP table the…Support Team NAKAMOTO 3 views 0 comments 0 points Started by Support Team NAKAMOTO BI Publisher Learning Center
-
Bursting Report QuerySummary: I want to build report something like below: payment advise to supplier - Subject : Invoice ----- is paid mail body : Dear (supplier name)-->Got it , your invoi…Amit Saraf 13 views 2 comments 0 points Most recent by Mona Mantry Payables, Payments & Cash Management
-
How to enable BI for document fiscal classification fieldTeam, We are looking to enable BI for the field Document Fiscal Classification in invoice creation under the tax details. Enabling BI for the requested field will help u…
-
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 49 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Is it possible to customize data model for check print reportIs it possible to customize data model for check print report to add additional fields.vikram khengare 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
AP Aging The report will present the invoices payed and unpaid status as of the date selected?Parameter As Of date = Due date The report will present the invoices payed and unpaid status as of the date selected But we are facing an issue with the invoices that ha…Mohammad Hussein 21 views 3 comments 0 points Most recent by Mohammad Hussein Payables, Payments & Cash Management
-
Projects and Accrue at Period EndMorning all, I'm working on a client where we have configured Accrue at Period End but need to get accrual info into Projects (without switching to Accrue at Period End)…
-
Help me to get the documentation for the standard extracts available in fusionSummary: We are getting the standard extracts which are all available in the fusion. But unable to get the extract details. like any documentation. Please help us to get…RANJITH KUMAR S 22 views 3 comments 0 points Most recent by RANJITH KUMAR S Payables, Payments & Cash Management
-
Customize Bank Transfer Approval email notification to show recipient's nameVersion: Oracle Fusion Cloud Applications24A (11.13.24.01.0) Within Cash Management / Cash Balances / Transfer Funds Details: When a transfer is created, it needs to be …NZ-user999 33 views 3 comments 0 points Most recent by Ramesh Thati-Oracle Payables, Payments & Cash Management
-
Sandbox- AP invoice,If any GL code otherthan “****” is used under multiperiod, user receive popupSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Stephen Sushanth Alexander 13 views 1 comment 0 points Most recent by Elena Vlad-Oracle Payables, Payments & Cash Management
-
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…
-
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 14 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 740 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 1 view 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 14 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 …