Reviewing Bank Statement Processing Results

You can review the bank statement processing results in the Bank Account Reconciliation work area. Any unreconciled transactions can be manually reconciled.

When Embedded Banking Services is enabled, bank statement processing is automatically initiated by Oracle Cloud ERP. When the bank posts a bank statement for the company, Oracle Cloud ERP retrieves the file, places it in the Universal Content Management (UCM) directory for Cash Management, and initiates the Load and Import Bank Statement process for the retrieved file. When the bank statement load is completed, the process automatically initiates the bank reconciliation process.

Because Oracle Cloud ERP automatically initiates bank statement import and reconciliation processing, Cash Management users can not view the related processes in the Bank Account Reconciliation work area by default.

To enable Cash Management users to view these processes in the Bank Account Reconciliation work area or the Scheduled Processes work area, provide read privileges for these processes:
  • JobDefinition://oracle/apps/ess/financials/cashManagement/bankStatements/BankStatementsProcessingForCloud
  • JobDefinition://oracle/apps/ess/financials/cashManagement/bankStatements/BankStatementsProcessing
  • JobDefinition://oracle/apps/ess/financials/cashManagement/cashPosition/integration/CashPositionDataExtraction

    For more information, see Example for granting a user privileges to see output of specific ESS job processes in Knowledge Article KB96503.

Note: The Load and Import Bank Statement process is initiated by the system user urn_opc_resource_fusion_<pod name>_erp_APPID.

Security

If you don’t use the predefined Financials Administrator or Application Implementation Consultant roles, add the FUN_MANAGE_PARTNER_CONFIGURATIONS_PRIV privilege to your custom role to access the Manage Embedded Banking Configurations page.