Payables & Cash Management

Get Involved. Join the Conversation.

Posts

  • Anjali Bisht
    DERIVE BANK ACCOUNT NUMBER FROM IBAN- 18C Feature2
    Topic posted Yesterday by Anjali BishtRed Ribbon: 250+ Points, tagged Cash Management, Financials, Payables 
    Title:
    DERIVE BANK ACCOUNT NUMBER FROM IBAN- 18C Feature
    Summary:
    DERIVE BANK ACCOUNT NUMBER FROM IBAN
    Content:

    Hi All,

    I just wanted to understand how does the account number get derived from the IBAN code i.e. where is the feed coming from, is it internally mentioned by Oracle or some 3rd party system? We are planning to enable this feature but before opting for it would like to understand from where is the feed coming from and will only enabling the feature suffice the need or do we need to have any other integration in place for the account number to automatically get generated when IBAN is entered.

    Regards

    Anjali Bisht

  • Dhilip Kumar
    Financial OTBI / Standard report outputs in one...Answered2
    Topic posted October 14, 2019 by Dhilip KumarRed Ribbon: 250+ Points, tagged Assets, Budgetary Control, Cash Management, Collections, Financials, General Ledger, Payables, Receivables 
    Title:
    Financial OTBI / Standard report outputs in one Document/excel
    Summary:
    Financial OTBI / Standard report outputs in one Document/excel
    Content:

    I need Financial OTBI / Standard report outputs in one Document/excel and I have one excel with all the reports but that is old one.

    Need latest one up to 19D similar to this document so its easy for us to suggest customer on seeded available reports. I did not find latest list in any Oracle Site/google.

    Attached old seeded reports (till 18C) for your reference and not covered till 19D.

  • Gopal Somani
    How to Find Payment file generate for Bank account transfer
    Topic posted October 11, 2019 by Gopal SomaniRed Ribbon: 250+ Points, tagged Cash Management, Financials, Payables 
    Title:
    How to Find Payment file generate for Bank account transfer
    Content:

    Hi All,

     

    I have created a Bank Account Transfer in Cash management using 'Settle Transaction through payments". Transaction is successful. Now, i want to download the payment file. Please let me know how can i download the payment file generated for this transaction. Users do not want to go to schedule process and get the output. Is there some other way to download the payment files for bank account transfer (like the way we have in Payables payment - using "manage payment file").

    I have tried checking in Manage payment file in Payables to see if i can find the Bank account transfer payment file but it was not there.

    Please help and suggest.

    Regards,

    Gopal 

  • Carlos Urtubia
    REST /fscmRestApi/resources/11.13.18.05/invoices to POST...3
    Topic posted October 10, 2019 by Carlos UrtubiaRed Ribbon: 250+ Points, tagged Cash Management, Payables 
    Title:
    REST /fscmRestApi/resources/11.13.18.05/invoices to POST 500+ lines
    Summary:
    Rest only import randomly 500 lines and no more
    Content:
    When I submitted an invoice with 1000+ lines using the REST /fscmRestApi/resources/11.13.18.05/invoices they get cut always at 500 lines and very randomly. The upload not even tells you that only sent 500 lines. Only says :
    "count": 25,
    "hasMore": true,
    "limit": 25,
    "offset": 0,
    "links": [

    And when downloading the invoice, says this :

    "count": 500,
    "hasMore": false,
    "limit": 1000,
    "offset": 0,
    "links": [

     

    Will be good if we could send large invoices to the system.

     

    Thank you,

     

    Carlos 

     
    Image:
  • Lori Culp
    Outstanding check list2
    Topic posted October 4, 2019 by Lori CulpGold Crown: 30,000+ Points, tagged Cash Management 
    Title:
    Outstanding check list
    Summary:
    Outstanding check list is needed by check number in order to complete reconciliation process as well as monitor stake checks
    Content:

    What are folks using to support reconciliation of cash for checks that are outstanding?  I would think that this would be a delivered feature, but its not, so I am trying to figure out what others are doing to get the detailed listing of each check making up the outstanding balance.

     

  • Matthew Dluhy
    Unable to reconcile Amex cashiering deposits at a detail...5.0
    Topic posted October 1, 2019 by Matthew Dluhy, tagged Cash Management, Configuration, Setup / Administration 
    Title:
    Unable to reconcile Amex cashiering deposits at a detail level due to bank statement format
    Summary:
    We are wondering how the community handles reconciling bank statements if the bank can only send summary-level details.
    Content:

    We process many point of sale transactions each month, many of which are paid for with Amex. Monthly, Amex provides us our statement of transactions we’ve received money for, and our goal in Cash Management is to reconcile these individual statement lines with the system transaction lines that will be integrated from our cashiering system.

    According to Amex, the only file types they’re able to produce statements in are CSV and TSV, but Oracle does not support either of these out of the box. File types Oracle supports out of the box: BAI2, SWIFT MT100/103/940, EDIFACT FINSTA/ PAYMUL, and ISO20022.

    We can create an auto reconciliation rule to do a one-to-many reconciliation where we reconcile one summary-level (daily balance) bank statement to many system transaction lines, but that’s not a thorough reconciliation and would not satisfy our auditors. Other than offline manual reconciliations, what other options do we have?

    Thanks in advance for any advice/information for this!

    Version:
    Oracle Cloud Cash Management 19C
  • Dev Thota
    Unable to cancel schedule jobs.35.0
    Topic posted September 30, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management 
    Title:
    Unable to cancel schedule jobs.
    Summary:
    Unable to cancel schedule jobs
    Content:

    Hi all,

    I am trying to cancel a schedule jobs

    1. Validate Payables Invoices
    2. Import Payables Invoices

    We are unable to cancel these jobs.

     

    Thanks,

    Dev Thota

    Version:
    19C
  • Dev Thota
    Can we transmit a single payment which was created through...15.0
    Topic posted September 24, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface 
    Title:
    Can we transmit a single payment which was created through " Create Payment" option?
    Summary:
    Can we transmit a single payment which was created through " Create Payment" option?
    Content:

    Hi all,

    Can we transmit a single payment which was created through the " Create Payment" option?

     

    Thanks,

    Dev Thota.

    Version:
    19C
  • Kalpita
    Error while loading BAI2 bank statements to Oracle FusionAnswered6
    Topic posted September 20, 2019 by KalpitaGreen Ribbon: 100+ Points, tagged Cash Management, Payables 
    Title:
    Error while loading BAI2 bank statements to Oracle Fusion
    Summary:
    Processes fail while uploading statements to Oracle Fusion
    Content:

    Hello everyone,

    The process of loading the BAI2 files to Oracle Fusion cloud ends with error. Please let me know if you have come across a similar issue.

    Here is the log:

    **** Bank Statement processing program for cloud running, Request ID: 262723
    ------ Waiting on Child Process with request ID: 262724 -------
    **** Bank Statement processing program for cloud running, Request ID: 262723
    Request 262723 was resumed with pause state PausedState1
    checkSubRequestsState begin -- parent requestId = 262723
    Process ID: 262724 ended in ERROR.
    The execution status of one or more subrequests is ERROR
    START - deleting the zip file from content server.
    END - deleting the zip file from content server.
     

    Thank you!

  • Fabian Benabente
    Cash Management - Setting up BAI2 feed for Scotia and HSBC3
    Topic posted September 16, 2019 by Fabian BenabenteGreen Ribbon: 100+ Points, tagged Cash Management, Financials, Setup / Administration 
    Title:
    Cash Management - Setting up BAI2 feed for Scotia and HSBC
    Summary:
    We are running into file format issues when attempting to load Scotia and HSBC BAI2 files.
    Content:

    With an ultimate goal of building an interface between Scotia and HSBC to Oracle CM, we are first attempting to load manual BAI2 files to CM.  The files are not in the correct format and we've found ourselves manually modifying the files to load into Oracle CM.  We did not have these issues with WF, BOA, or PNC.

     

    Has anyone run into similar issues with these institutions?  If so, were you able to successfully work with the institution to modify their BAI2 files and what were those updates?

    Thanks in advance!