OTBI
Discussion List
-
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 24 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 54 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…JOHANN CHRISTIAN MORDENO 10 views 3 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
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…
-
Is there any available CFO and payables dashboard in reports and analytics?Summary: Is there any available CFO and payables dashboard in reports and analytics? Content (required): Version (include the version you are using, if applicable): Orac…Zeinab Nabil 47 views 2 comments 0 points Most recent by Zeinab Nabil Payables, Payments & Cash Management
-
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 18 views 0 comments 0 points Started by salma_essam Payables, Payments & Cash Management
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 38 views 2 comments 0 points Most recent by Nishanth B Jain 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 64 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 47 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 30 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…SaurabhSinghal 24 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 87 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 6 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 4 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 4 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 14 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 36 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 16 views 1 comment 3 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 14 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 57 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 17 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 5 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 34 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 28 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 4 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 4 views 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 4 views 1 comment 0 points Most recent by Alexandra Leanca-Oracle Payables, Payments & Cash Management