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:
W_AP_XACT_FS
(truncated)
W_AP_XACT_F
(deleted and inserted)
New columns included in base fact:
NA
Tables with records added:
NA
Metrics calculated differently:
NA
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 |
New attributes:
NA
Data model changes:
NA
Receivables (AR)
Following are the upgrade changes:
Tables truncated or records deleted:
NA
New columns added in base fact:
NA
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~%'
Metrics calculated differently:
AR Discount related metrics
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 |
New Attributes:L
NA
Data Model Change:
NA
General Ledger (GL)
Following are the upgrade changes:
W_GL_LINKAGE_INFORMATION_GS
New columns included in base fact:
NA
Tables with records added:
Inserted Fusion Apps specific application id '10036' to W_GL_LINKAGE_INFORMATION_G
Metrics calculated differently:
NA
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 |
New attributes:
NA
Data model changes:
NA
COGS/Profitability/Revenue
Tables truncated or records deleted:
NA
New columns included in base fact:
NA
Tables with records added:
NA
Metrics calculated differently:
NA
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 |
New attributes:
NA
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:
Tables truncated or records deleted:
NA
New columns included in base fact:
NA
Tables with records added:
NA
Metrics calculated differently:
NA
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 |
New attributes:
NA
Data model changes:
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
Table: W_FA_LEASE_PAYMENT_FS : Change data type of the columns LOC_EXCHANGE_RATE from VARCHAR2(10 CHAR) to NUMBER(28,10)