OTBI
Discussion List
-
How to pull invoice distribution lines in PayablesSummary: I am trying to pull a report of invoice posting date vs. accounting date. I also need to show all the distributions. In OTBI I am only receiving the invoice inv… -
Number of invoices processed per FTE that performs the process “Process accounts payable (AP)”Summary: Number of invoices processed per FTE that performs the process “Process accounts payable (AP)” Content (required): We are making an attempt to calculate the per…SaurabhSinghal 21 views 1 comment 0 points Most recent by SaurabhSinghal Payables, Payments & Cash Management -
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 88 views 7 comments 0 points Most recent by Swapnil Kashid 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 3 views 0 comments 0 points Started by AVorster-Oracle Payables, Payments & Cash Management -
How to reconcile MPA invoices vs GL Trial Balance ?Summary: How to reconcile MPA invoices vs GL Trial Balance ? Content (required): Hello We have several invoices in AP that were transfered to GL in summary hence I was w…Cesar Saveedra 2 views 0 comments 0 points Started by Cesar Saveedra Payables, Payments & Cash Management
-
ap_invoice_distributions_all not capturing prepayment application gain/lossSummary: Content (required): Hi, We have come across a scenario where the gain/loss arising from prepayment application not being captured in the above table even though…Sheneli Fernando 2 views 1 comment 0 points Most recent by user713823-Oracle Payables, Payments & Cash Management
-
Payables Trial Balance OTBISummary: Payables Trial Balance OTBI Content (required): How to create Payables Trial Balance from OTBI? How do I get the as at date? How do I get the Original Amount an…CraigX 13 views 1 comment 0 points Most recent by Nagaraju-Oracle Payables, Payments & Cash Management
-
How to derive number of working/Businessdays in Fusion AP OTBI reportsSummary: How to derive number of working or Business days in Fusion AP OTBI reports while selecting data items via AP subject area
-
Autoapproved invoices showing Initiated in AP_INV_APRVL_HIST_ALLSummary: Since 22C we are seeing all of our invoices that hit an autoapproval rule showing as Initiated status in AP_INV_APRVL_HIST_ALL table. Content (required): Since …James McBride 32 views 4 comments 2 points Most recent by James McBride Payables, Payments & Cash Management -
OTBI Payment reportDeal all : I have a payment report when I log in it from the catalog and search for it an open it there's a criteria Payment date that appear But this same report if i s…mickel rmeily 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Combining two Subject areas - SQLSummary:Trying to combine two subject areas in Payable subject areas. Getting Error Content (required):Hi I am trying to combine two subject areas and have the sql. I am…
-
OTBI Subject area- 'Trail Balance Accounting Date' vs Liability Account As-of DateSummary: What is equivalent date for Liability Account As-of Date on the Payables Trial Balance report in OTBI. I have tried 'Trial Balance Accounting Date' in 'Payables…Shriraag_Cloud 11 views 2 comments 0 points Most recent by Shriraag_Cloud Payables, Payments & Cash Management -
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 44 views 3 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management
-
Does Invoice Imaging support Payable Invoice coming in Chinese Language?Summary Does Invoice Imaging support Payable Invoice coming in Chinese Language?Content Does Invoice Imaging support Payable Invoice coming in Chinese Language? Apprecia…Sam Samaddar 13 views 4 comments 1 point Most recent by Raj Bhakta Payables, Payments & Cash Management -
Payables Invoice Audit by Voucher Number ListingWhich role is required to run "Payables Invoice Audit by voucher number listing report" in oracle cloud in scheduled processes?Kanika Mahajan 4 views 0 comments 1 point Started by Kanika Mahajan Payables, Payments & Cash Management
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 3 views 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management
-
PGP Payment File Encryption and Decryption of MT940Summary Need to sign payment files generated via BI Report with Oracle PGP private key and encrypt the payment file using Bank public PGP keyContent We have this require…User_9YT5L 33 views 1 comment 1 point Most recent by User_5XX7A Payables, Payments & Cash Management
-
Remittance Advice for Manual PaymentsHey, Separate Remittance Advice ESS process do gets triggered when we run a payment through Submit Payment Process Request and can also be manually triggered by selectin…Kanika Mahajan 14 views 1 comment 0 points Most recent by Kanika Mahajan Payables, Payments & Cash Management
-
User GUID populated for field Created byHi All, We would like to understand why user GUID is captured for few records in GL_CODE_COMBINATIONS table and for few records we have username populated. We could see …Swapnil Kashid 2 views 0 comments 0 points Started by Swapnil Kashid Payables, Payments & Cash Management -
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 1 view 1 comment 0 points Most recent by Alexandra Leanca-Oracle Payables, Payments & Cash Management
-
Payables to Ledger ReconSummary: Payables to Ledger Recon Content (required): Are there any improvement in this report, for, instance to add approvers or reviewers. How to treat differences ari…CraigX 1 view 1 comment 0 points Most recent by Alexandra Leanca-Oracle Payables, Payments & Cash Management
-
Report to show GRN has more than one invoice with sum Qty and Sum AmountSummary: Report to show GRN has more than one invoice with sum Qty and Sum Amount Content (required): Business wants seeded report/query to show GRN has more than invoic… -
How to know what AP invoice approval rule was triggered for a particular invoice?Summary: How to know what AP invoice approval rule was triggered for a particular invoice? Content (required): How to know what AP invoice approval rule was triggered fo…
-
Payables to Ledger ReconSummary: Payables to Ledger Recon Content (required): Payables to Ledger Recon Payables Ending Balance differ from the Payables Trial Balance. Is there a Report to valid…
-
Is supplier audit report available in fusion payables?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…User_L2IG5 1 view 4 comments 0 points Most recent by User_L2IG5 Payables, Payments & Cash Management
-
Holds, Approval and Due payables infotile displaying data for all available BUsSummary Holds, Approval and Due payables infotile displaying data for all available BUsContent Team, User can able to see all available BUs information on the Holds, App… -
Need Supplier Ledger Report with Debits and Credits(Posted/Unposted) to Supplier AccountSummary Need Supplier Ledger Report with Debits and Credits(Posted/Unposted) to Supplier AccountContent Hi Experts I am looking for a Supplier Ledger Report with Debits …Dharmendra Shukla 14 views 2 comments 1 point Most recent by Dharmendra Shukla Payables, Payments & Cash Management -
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 12 views 7 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Approval Remarks for Completed Bank Reconciliation in Oracle Cash ManagementContent Hi I would just like to inquire if there is a way to mark the completed bank reconciliation in oracle cash management as "Approved"? because currently, what i ca…JOHANN CHRISTIAN MORDENO 7 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
Payables Matching Hold Report is not picking any hold gains invoice not PO matchedSummary Payables Matching Hold Report is not picking any hold gains invoice not PO matchedContent do we have any hold report in AP module which will pull all invoices re…Sam Samaddar 13 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management