Financials

This section lists the upgrade changes after 11.1.1.9.2 to 11.1.110.1 upgrade.

General Ledger (GL)

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    • W_GL_OTHER_F

    • W_PSFT_BAL_SEGMENT_DH_PS

    • W_BALANCING_SEGMENT_DH

    • W_PSFT_NAT_ACCOUNT_DH_PS

    • W_NATURAL_ACCOUNT_DH

    • W_PSFT_GL_SEGMENT_DH_PS

    • W_GL_SEGMENT_DH

  2. New columns included in base fact:
    • W_GL_OTHER_F

      • GL_JOURNAL_DT (applicable only to PeopleSoft (PSFT) for now)

      • JOURNAL_LINE_REFERENCE (applicable only to PSFT for now)

  3. Tables with records added:

    Added the following tables in 10.1 and populate mapping information of Ledger, GL account, and Periods for Fusion Accounting Hub Co-existence:

    • W_LEDGER_MAP_G

    • W_GL_ACCOUNT_MAP_G

    • W_MCAL_PERIOD_MAP_G

  4. Issues and bug fixes covered:

    PSFTxx

    • Bug 20893695 - When a PSFT tree is a summary tree and if the detail table and the corresponding node table are different but the Node ID has the same value as one of the detail nodes, then the current extract causes duplicates.

    • Bug 20012739 - Populate Created_On_Dt for PSFT ChartField PS tables so that incremental runs update data correctly.

  5. New attributes:
    • Financials - GL Detail Transactions

      • Financials - GL Detail Transactions > Document Details > GL Journal Date

      • Financials - GL Detail Transactions > Document Details > Journal Line Reference

      PSFTxx

      • Populate GL Journal Date. Sourced from PS_JRNL_HEADER.JOURNAL_DATE

      • Populate Journal Line Reference. Sourced from PS_JRNL_LN.JRNL_LN_REF

    • Financials - GL Balance Sheet

      • Financials - GL Balance Sheet > Ledger > Target Ledger ID

      • Financials - GL Balance Sheet > Ledger > Source ID

      • Financials - GL Balance Sheet > Time > Target Fiscal Period ID

      • Financials - GL Balance Sheet > GL Account > Target GL Account ID

      Sourced from GL_XFR_LEDGER_MAPPINGS, GL_XFR_CCID_MAPPINGS, and GL_XFR_PERIOD_MAPPINGS for the ledger, the GL account, and the period respectively. Only applicable for EBSR12.2+.

      EBSR122

      Populate setup mappings of Ledger, GL account, and Periods for Fusion Accounting Hub Co-existence. These tables are empty when this functionality is not used.

  6. Data model changes:

    W_GL_OTHER_F
    Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    145 GL_JOURNAL_DT DATE(7) New
    246 JOURNAL_LINE_REFERENCE VARCHAR2(30) New
    W_LEDGER_MAP_G
    Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    1 TRG_LEDGER_ID VARCHAR2(80) New
    2 ROW_WID NUMBER(10) New
    3 W_INSERT_DT DATE New
    4 W_UPDATE_DT DATE New
    5 DATASOURCE_NUM_ID NUMBER(10) New
    6 ETL_PROC_WID NUMBER(10) New
    7 INTEGRATION_ID VARCHAR2(80) New
    8 TENANT_ID VARCHAR2(80) New
    9 X_CUSTOM VARCHAR2(10) New
    W_GL_ACCOUNT_MAP_G
    Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    1 TRG_INTEGRATION_ID VARCHAR2(240) New
    2 TRG_GL_ACCOUNT_ID VARCHAR2(2000) New
    3 ROW_WID NUMBER(10) New
    4 W_INSERT_DT DATE New
    5 W_UPDATE_DT DATE New
    6 SRC_EFF_FROM_DT DATE New
    7 SRC_EFF_TO_DT DATE New
    8 DATASOURCE_NUM_ID NUMBER(10) New
    9 INTEGRATION_ID VARCHAR2(80) New
    10 TENANT_ID VARCHAR2(80) New
    11 X_CUSTOM VARCHAR2(10) New
    12 ETL_PROC_WID NUMBER(10) New
    W_MCAL_PERIOD_MAP_G
    Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    1 TRG_MCAL_PERIOD_ID VARCHAR2(80) New
    2 ROW_WID NUMBER(10) New
    3 W_INSERT_DT DATE New
    4 W_UPDATE_DT DATE New
    5 DATASOURCE_NUM_ID NUMBER(10) New
    6 ETL_PROC_WID NUMBER(10) New
    7 INTEGRATION_ID VARCHAR2(80) New
    8 TENANT_ID VARCHAR2(80) New
    9 X_CUSTOM VARCHAR2(10) New

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:
    • W_AP_XACT_F

      • APPR_STATUS_WID

      • VALD_STATUS_WID (*applicable only to Fusion and EBS R12xx)

  3. Tables with records added:

    • W_STATUS_D (where W_STATUS_CLASS in ['FIN_AP_APPR_STATUS','FIN_AP_VALD_STATUS'])

      (* FIN_AP_VALD_STATUS applicable only to Fusion and EBS R12xx)

  4. Metrics calculated differently:

    • Fact - Fins - AP Transaction > # Payments

    • Fact - Fins - AP Transaction > AP Count Payments without Invoice

    • Fact - Fins - AP Transaction > AP Payment Count

  5. Issues and bug fixes covered:
    Enhancement/Bug Impacted warehouse object Impacted adapters
    Bug 18510561 REL10 -RFA - AP TRANSACTION STATUS SHOWS AS __ERROR__ IN BI APPS 11.1.1.7.1 W_STATUS_D

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 14648685 INCLUDE APPROVAL STATUS IN THE AP STATUS DIMENSION

    W_STATUS_D

    W_AP_XACT_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 10648786 ENHANCEMENT: HOW DO WE IDENTIFY AND EXCLUDE UNVALIDATED INVOICES FROM REPORTING

    W_STATUS_D

    W_AP_XACT_F

    EBS R12xx

    Fusion
    Bug 16672435 "# PAYMENTS" AND "AP COUNT PAYMENTS WITHOUT INVOICE" EXPRESSION CHANGES W_AP_XACT_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx
    Bug 18545104 THE METRIC "AP PAYMENT COUNT" IS CONSIDERING CANCELLED PAYMENTS W_AP_XACT_F

    EBS 11510

    EBS R12xx

    Fusion
    To update Approval status wid and Validation status wid to 0 for records other than schedules W_AP_XACT_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 20577706 - OTBIE REL10: Some rows have null value for recon_proc_wid in w_ap/ar_xact_f W_AP_XACT_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 20652852 - W_AP_HOLDS_F, HELD_BY_WID and RELEASE_BY_WID will always be 0 W_AP_HOLDS_F Fusion
    Bug 20978353 - REL10 - AGING_METHOD_CODE is null in JDE AP W_AP_AGING_BUCKETS_D JDExx

  6. New attributes:

    Financials - AP Transactions > Document Details >

    Financials - AP Invoice Aging > Document Details >

    Source AP Approval Status

    Source AP Approval Status Name

    Source AP Approval Status Description

    AP Approval Status

    AP Approval Status Name

    AP Approval Status Description

    Following are applicable only to Fusion/EBS R12xx)

    • Source AP Validation Status

    • Source AP Validation Status Name

    • Source AP Validation Status Description

    • AP Validation Status

    • AP Validation Status Name

    • AP Validation Status Description

  7. Data model changes:

    W_AP_XACT_FS

    W_AP_XACT_RECON_FS

    W_AP_XACT_REV_RECON_FS

    W_AP_AGN_INV_BKP_A

    W_AP_AGN_INV_ENT_BKP_A

    Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    APPR_STATUS_ID VARCHAR2(80) New
    VALD_STATUS_ID VARCHAR2(80) New

    W_AP_XACT_F

    W_AP_AGING_INVOICE_A

    W_AP_AGING_INVOICE_ENT_A

    Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
    APPR_STATUS_ID NUMBER(10) New
    VALD_STATUS_ID NUMBER(10) New

Receivables (AR)

Following are the upgrade changes:

  1. Tables truncated or records deleted:

    • W_AR_XACT_FS (truncated)

    • W_AR_XACT_F (deleted and inserted)

  2. Tables with records added:

    W_XACT_TYPE_D (where INTEGRATION_ID like ['ACCT_DOC~RECEIVABLE~CASH APPLICATION~%','ACCT_DOC~RECEIVABLE~PAYMENT~%'])

  3. Metrics calculated differently:

    • Fact - Fins - AR Transaction > AR Applied Amount

    • Fact - Fins - AR Transaction > AR Count Payment Transactions

    • Fact - Fins - AR Transaction > AR Total Payment Amount

    • Fact - Fins - AR Transaction > AR Unapplied Payment Amount

  4. Issues and bug fixes:

    Enhancement/Bug Impacted warehouse object Impacted adapters
    Bug 18510561 REL10 -RFA - AP TRANSACTION STATUS SHOWS AS __ERROR__ IN BI APPS 11.1.1.7.1 W_STATUS_D

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 17412308 EBS/FUSION: AR PAYMENT AMOUNT TO BE FURTHER CATEGORIZED

    W_XACT_TYPE_D

    W_AR_XACT_F

    EBS 11510

    EBS R12xx

    Fusion
    Bug 14536773 - PS1-FIN-AR-PSFT90- W_AR_XACT_F.UOM_CODE NOT LOADED FOR INVOICE ITEMS W_AR_XACT_F PSFTxx
    Bug 20577706 - OTBIE REL10: Some rows have null value for recon_proc_wid in w_ap/ar_xact_f W_AR_XACT_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

    JDExx
    Bug 20516845 - PSFT - RECEIPT_NUM and amount sign are incorrect for PAYMENT type in W_AR_XACT_F W_AR_XACT_F PSFTxx
    Bug 20990173 - REL9 TO REL10 UPG - Incorrect Domain mapping for AR Transaction Subtype-PSFT

    W_XACT_TYPE_D

    W_DOMAIN_MEMBER_MAP_G

    		 PSFTxx
    Bug 19802482 - Rel10AR_AGING_METHOD_CODE is displaying Companycode instead of AgingMethodcode W_AR_AGING_BUCKETS_D JDExx

Profitability (Revenue / COGS)

Following are the upgrade changes:
  1. Tables truncated or records deleted:

    • W_GL_REVN_FS (records deleted)

    • W_GL_REVN_F (records deleted and re-inserted)

  2. Issues and bug fixes:

    Enhancement/Bug Impacted warehouse object Impacted adapters
    Bug 20917665 - Special Character in EBS Table Fails SDE_ORA_GLREVENUEFACT

    W_GL_REVN_FS

    W_GL_REVN_F

    EBS 11510

    EBS R12xx

    Fusion

    PSFTxx

  3. New attributes:

    COGS: New RPD Subject Area Financials – GL Cost of Goods Sold Analysis. The new subject area is used to support GL Subledger drill down functionality. This subject area contains the attributes which are exposed from BMM layer attributes that exist in prior releases.

  4. Data model changes

    Table Name Column Name Change
    W_GL_REVN_FS SALES_ORDER_ITEM

    Existing column

    Data Type changed from NUMBER to VARCHAR2(30)
    W_GL_REVN_F SALES_ORDER_ITEM

    Existing column

    Data Type changed from NUMBER to VARCHAR2(30)