FTP Process Fails With Error 'ORA-01476: divisor is equal to zero' Running Ledger Migration in 8.1 (Doc ID 2807997.1)

Last updated on MAY 06, 2023

Applies to:

Symptoms

After upgrading to FTP 8.1, you are getting an "ORA-01476: divisor is equal to zero" when running an FTP Process that migrates results to Management Ledger.  The following error exists in the Transfer Pricing Engine log in /<ftpshare>/logs/<AsofDate>/<Infodate>/Transfer Pricing Engine:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 1476 ORA- 01476:
    divisor is equal to zero SQL:
insert into FSI_D_MANAGEMENT_LEDGER (identity_code, as_of_date,
    iso_currency_cd, FINANCIAL_ELEM_ID, ORG_UNIT_ID, GL_ACCOUNT_ID,
    COMMON_COA_ID, PRODUCT_ID, LEGAL_ENTITY_ID, BSP_COA_ID,
    CHANNEL_ID, TRANSACTION_TYPE_ID, SOURCE_ORG_UNIT_ID ,
    fiscal_month, fiscal_year, consolidation_cd, strategy_id,
    balance_type_cd, entered_balance, functional_balance)
select *
etc.....

The data records do contain zero balances in AVG_BOOK_BAL but, in version 6.1.1, the FTP Process did not fail and stop the batch processing.

You expect the FTP Process to complete successfully even if it outputs a zero transfer rate value.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.