OTBI
Discussion List
-
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 9 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 34 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 11 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 19 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 -
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 1 view 0 comments 0 points Started by Sheneli Fernando 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 1 view 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 1 view 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 30 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 11 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 1 view 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 15 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 6 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 10 views 2 comments 0 points Most recent by Sam Samaddar 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…JOHANN CHRISTIAN MORDENO 7 views 2 comments 1 point Most recent by JOHANN CHRISTIAN MORDENO Payables, Payments & Cash Management
-
Supplier Email on Print Remittance AdviceContent Hi, The Supplier Email is not showing up in the remittance advice, when printed but it does gets populated when Remittance advice is sent through email. We need …Kanika Mahajan 14 views 1 comment 2 points Most recent by Ruchika Gujral Payables, Payments & Cash Management
-
Payment Process Profile report & Payment process request template requestSummary Payment Process Profile report & Payment process request template requestContent Please provide any report or SQL query where I can get required information for …Kumar 57 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
Fusion 20C: Custom CM Dashboard not visible to some users?Summary Fusion 20C: Custom CM Dashboard not visible to some users? Cash Manager already assigned but still not able to access the dashboard.Content Hi Experts, Fusion 20…User_87I2Y 22 views 1 comment 2 points Most recent by User_87I2Y Payables, Payments & Cash Management
-
New infotileSummary Develop a custom infotileContent Hello In Payables workarea Recent infotile is provided. it only provides invoices created by the user. Can we develop a new info…User_NGD9M 20 views 2 comments 0 points Most recent by SankarBalu Payables, Payments & Cash Management