OTBI
Discussion List
-
Supplier Analysis Prompt not displaying from ReportsSummary: I created Supplier ACH Verification Analysis with prompt for user to select Supplier Name prior to displaying results, however when user opens analysis from Rep…Eybrown 5 views 1 comment 0 points Most recent by Veronique Gagnon Payables, Payments & Cash Management -
Actionable Dashboard for AP Invoice Approval in Oracle Fusion CloudSummary: To approve bulk invoice all columns are not available in the worklist where the approver can view the columns and select and approve. So can we create a actiona…Jagjit Singh Arora 118 views 0 comments 0 points Started by Jagjit Singh Arora Payables, Payments & Cash Management
-
Request for Documentation on Fields Match for XML Document in IBY_TRXN_DOCUMENTS TableSummary: Hello, My team I are working on an H2H implementation for a client using the Oracle ERP Cloud system. As part of this implementation, I need to understand the s…Arturo Contreras 203 views 2 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Report Payables withholding tax and accountsSummary: Hello, We would like to know if there is a report to support the Payables withholding tax invoices and Tax Accounts Content (please ensure you mask any confiden…usr_a.nv 28 views 2 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 128 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Can we create a rule to auto reject the invoices if particular account is found?We have a requirement to not allow the invoices (PO, non PO, boundary apps invoices) to be charged to 1***** account. This account can be used in other subledgers so we …KanikaGupta 28 views 1 comment 1 point Most recent by Ravi Prakash Shukla-Oracle 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…Surya01 39 views 5 comments 0 points Most recent by Arvi Dinavahi-Oracle 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 36 views 0 comments 0 points Started by Devashish Saun 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_ 53 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 30 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… -
Setting custom check format for APSummary: I am setting up custom AP check format first time. Need to know the steps, any document showing steps. Content (required): I need to add custom layout for AP ch…
-
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…SireeshaJaladi 112 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
TAX reports output should be in Hebrew Language in Oracle FusionSummary: TAX reports output should be in Hebrew Language Content (required): Hi Team , We are looking for the TAX reports output should be in Hebrew Language, both heade…Spats 67 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Table details which stores Payment System Account name in Payment Process Profile setupSummary: We need table details which stores Payment System Account name in Payment Process Profile setup task Content (required): Version (include the version you are us…Nishanth B Jain 94 views 5 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Multiple Bank Accounts in Smartview Cash ForecastSummary Multiple Bank Accounts in Smartview Cash ForecastContent Hi I would just like to inquire if there is a way to do a multiple bank account view at the same time in…User_2025-02-11-12-30-38-982 42 views 3 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
Table details to get Additional Information for Payment MethodsSummary: Which table stores these information for Payment Method Task for Payables. Content (required): Version (include the version you are using, if applicable): Code …Nishanth B Jain 86 views 7 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Table details which holds Enable invoice account coding workflow flagSummary: Table details which holds Enable invoice account coding workflow flag in Manage Invoice Option task Content (required): Version (include the version you are usi…Nishanth B Jain 117 views 2 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management
-
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…MELISSA V 148 views 2 comments 0 points Most recent by MELISSA V Payables, Payments & Cash Management -
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…SaurabhSinghal26 94 views 1 comment 0 points Most recent by SaurabhSinghal26 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 609 views 7 comments 0 points Most recent by Swapnil Kashid 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…Sheneli98 16 views 1 comment 0 points Most recent by Beth Creapo-Support-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 46 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 75 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 46 views 1 comment 3 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
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…SBJ_PPM_1210 77 views 2 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management