Reporting
Discussion List
-
Payables Audit ReportSummary: I am trying to understand the different options available in the Payables Audit Report. I created an Oracle SR but Oracle Support was not familiar with this pro… -
How to disabling the approve button in the notification for certain set of usersSummary: How to disabling the approve button in the notification for certain set of users Content (required): How to disabling the approve button in the notification for… -
Invoice installment DFF not visible in OTBISummary: We have created Invoice Installment DFF and make that BI enabled but that is not coming in OTBI Installments real time subject area Content (required): We have …arpit_paliwl 71 views 3 comments 0 points Most recent by Selva -Oracle Payables, Payments & Cash Management
-
Prepayment report by Supplier As of dateSummary: Requirement of Audit for Prepayment report as of supplier wise with as of date no standard report or any way? Content (required): Payables Version (include the …Umer.Farooq 31 views 4 comments 0 points Most recent by Prabal_Agrawal Payables, Payments & Cash Management -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 31 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management -
SQL for Current approver of AP InvoiceSummary: We have requirement to find the current approver of AP Invoice if the invoice is under approval . We are using below query to find the current approver select A…Oracletechnofunctional 1.6K views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 51 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
how to purge data files from ucm server for Import Payables programSummary: We have around 2000 datafiles appearing in datafiles Lov while submitting Load Interface File for Import program. Attaching the screenshot where the datafiles c…Sachin Kr Singh 31 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
Do we have any report what are the employee expense invoices applied against the Employee advancesSummary: Do we have any report what are the employee expense invoices applied against the Employee advances Content (required): Business wanted to see which are the expe…Sangireddy-Oracle 1 view 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Adding page break to etext templateSummary: We have an etext template that we need to have a page break to. It appears that we can do this with xml, but we currently don't have any XML in our template. Is… -
Netting Settlement Letter doesn't show Payables transactionsSummary: When executing a Netting settlement and downloading the Netting Settlement Letter, the payables transactions section is not showing the information of the invoi…FiorellaLamas 21 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to setup an AP Payment term 95% inmmediate 5% on hold ?Summary: How to setup an AP Payment term 95% inmmediate 5% on hold ? Content (required): Hello I have a business requirement for one supplier 95% is due inmmediate and 5…Cesar Saveedra 21 views 2 comments 0 points Most recent by Cesar Saveedra Payables, Payments & Cash Management
-
Do we have any tax related report which shows data in functional currencies in Fusion?Summary: Our expectation is all the AP, AR or Other Tax related Transaction in Functional Currencies Report. Content (required): We have financial tax register report bu…VijayDXC 11 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
How to track changes in Approval limits in BPMSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Table that holds US 1099 payment related info.Summary: Content (required): Hi All, We are building a custom report on top of "US 1099 Report", that report the payments made to a vendor who is covered under federal r…Srikanth_K 21 views 1 comment 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 21 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management
-
Logic behind the comparison filter for invoice numbers, AR and APFor an integration and extension we are designing, we need to have a clear understanding of the logic used by the same system when the user uses the following filters fo…
-
Table details for Setup: Payment process ProfileSummary: Table details for Setup: Payment process Profile Content (required): We need table details, which stores Default Payment Document for Payment Process Profile Cr…Nishanth B Jain 71 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Configuration Required to Generate SEPA Payment File on ScheduleSummary: Configuration Required to Generate SEPA Payment File on Schedule Content (required): Hello All, We have a requirement to generate and export SEPA payment file e…Bernard T 21 views 2 comments 0 points Most recent by Bernard T Payables, Payments & Cash Management
-
How To Successfully Customize the "Disbursement Payment Process Request Status Report Formats"Summary: We are turning on payment approvals but the approvers do not like the seeded layout of the Disbursement Payment Process Request Status Report. I was attempting …Brian Burns 465 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to Generate XML and Modify the Payment Process Request Status ReportSummary: I am trying to customize the payment process request status report but am unable to generate an xml of the report in order to either make a new layout or edit t…Brian Burns 351 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Does Oracle provides any option to sign the JPK file (trusted eSignature) for Poland ?Summary: Client requirement is to have the JPK signed by the designated signature. Content (required): Client requirement is to have the JPK signed by the designated sig… -
Closing Available Balance in Bank StatementSummary: Content (required): Hi, Can someone kindly explain to me how the Closing Available balance in Bank Statement is derived as shown in the screenshot below? Versio…Sheneli98 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Check amount in words with centsContent Hi All, We have a requirement to print check amount in below format ONE THOUSAND FIVE HUNDRED USD AND 00/100 Currently xml generated from PPR is having format li…Nishanth B Jain 138 views 7 comments 1 point Most recent by SrinathD Payables, Payments & Cash Management
-
How to Check and Extend Maximum Character Limit of Line Description in Report OutputSummary: Hi, We are having Line Description of 310 Characters in Payables Payment. While Checking in Standard or Custom Journal Report output we can see description with…Nirav Vekaria 648 views 2 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management -
Multi-Period Accounting ReportsSummary Looking for reports linked to multi-period accountingContent Hi All, We want to use multi-period accounting but before we do so we wanted to ensure that we can g…User_2025-02-04-19-45-49-438 125 views 8 comments 2 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to prevent payment amount replication on Payment Details Report-multiple invoices incl in pymtSummary: Payment Details Report is duplicating Payment Amount when more than 1 invoice was included in payment. Is there a way to prevent this from happening? Or add a c…