Financials

New ETL content in Financials after the upgrade from 11.1.1.10.1 to 11.1.1.10.2 is listed in this topic.

Payables (AP)

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    • W_AP_XACT_FS (truncated)

    • W_AP_XACT_F (deleted and inserted)

  2. New columns included in base fact:

    NA

  3. Tables with records added:

    NA

  4. Metrics calculated differently:

    NA

  5. Issues and bug fixes covered:
    Enhancement/Bug Impacted warehouse object Impacted adapters

    To update the Validation Status (VALD_STATUS_WID)

    BUG 21923351 INCLUDE FTS_FUSION_FSCMTOPMODELAM_FINAPINVTRANSACTIONSAM_INVOICEHEADERPVO IN LP

    W_AP_XACT_F

    Fusion

  6. New attributes:

    NA

  7. Data model changes:

    NA

Receivables (AR)

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    NA

  2. New columns added in base fact:

    NA

  3. Tables with records added:

    W_XACT_TYPE_D (where INTEGRATION_ID like ['ACCT_DOC~RECEIVABLE~CASH APPLICATION~EDISC','ACCT_DOC~RECEIVABLE~CASH APPLICATION~UNEDISC'])

    W_AR_XACT_F

    Will extract the new discount distributions EDISC,UNEDISC where INTEGRATION_ID like 'R~%'

  4. Metrics calculated differently:

    AR Discount related metrics

  5. Issues and bug fixes:

    Enhancement/Bug Impacted warehouse object Impacted adapters

    BUG 20651741 REL11-Discounts are seen to be multiplying based on AR Distributions

    W_XACT_TYPE_D

    W_AR_XACT_F

    Fusion

    R12xx

  6. New Attributes:L

    NA

  7. Data Model Change:

    NA

General Ledger (GL)

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    • W_GL_LINKAGE_INFORMATION_GS

  2. New columns included in base fact:

    NA

  3. Tables with records added:

    Inserted Fusion Apps specific application id '10036' to W_GL_LINKAGE_INFORMATION_G

  4. Metrics calculated differently:

    NA

  5. Issues and bug fixes covered:

    Enhancement/Bug Impacted warehouse object Impacted adapters

    Bug 22199884 - OTBI-E V3: SOURCE_DISTRIBUTION_ID not correctly populated for Project Rev rows

    Bug 20525667 - Error in logic for DISTRIBUTION_SOURCE and SOURCE_DISTRIBUTION_ID in linkage

    W_GL_LINKAGE_INFORMATION_G

    Fusion

  6. New attributes:

    NA

  7. Data model changes:

    NA

COGS/Profitability/Revenue

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    NA

  2. New columns included in base fact:

    NA

  3. Tables with records added:

    NA

  4. Metrics calculated differently:

    NA

  5. Issues and bug fixes:

    Enhancement/Bug Impacted warehouse object Impacted adapters

    Bug 21490311 - FIN R10: INIT: PSR: SDE_ORA_GLREVENUEFACT session failed with ORA-12899

    W_GL_REVN_FS

    W_GL_REVN_F

    W_GL_REVN_RECON_FS

    W_GL_REVN_REV_RECON_FS

    ALL

  6. New attributes:

    NA

  7. Data model changes

    Change the data type of column SALES_ORDER_DOC from varchar2(30) to varchar2(50) in the following tables:

    • W_GL_REVN_FS

    • W_GL_REVN_F

    • W_GL_REVN_RECON_FS

    • W_GL_REVN_REV_RECON_FS

Fixed Asset (FA)

The following are the upgrade changes:

  1. Tables truncated or records deleted:

    NA

  2. New columns included in base fact:

    NA

  3. Tables with records added:

    NA

  4. Metrics calculated differently:

    NA

  5. Issues and bug fixes covered:

    Enhancement/Bug Impacted warehouse object Impacted adapters

    Bug 22888791 - REL11.1:EBS122:INCR:SIL_FIXEDASSETLEASEPAYMENTFACT-Invalid number

    W_FA_LEASE_PAYMENT_F

    W_FA_LEASE_PAYMENT_FS

    ALL

  6. New attributes:

    NA

  7. Data model changes:

    1. Table: W_FA_LEASE_PAYMENT_F : Change data type of following columns from VARCHAR2(10 CHAR) to NUMBER(28,10)

      • LOC_EXCHANGE_RATE

      • GLOBAL1_EXCHANGE_RATE

      • GLOBAL2_EXCHANGE_RATE

      • GLOBAL3_EXCHANGE_RATE

    2. Table: W_FA_LEASE_PAYMENT_FS : Change data type of the columns LOC_EXCHANGE_RATE from VARCHAR2(10 CHAR) to NUMBER(28,10)