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:
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
W_GL_OTHER_F
GL_JOURNAL_DT
(applicable only to PeopleSoft (PSFT) for now)
JOURNAL_LINE_REFERENCE
(applicable only to PSFT for now)
Tables with records added:
W_LEDGER_MAP_G
W_GL_ACCOUNT_MAP_G
W_MCAL_PERIOD_MAP_G
Issues and bug fixes covered:
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.
Financials - GL Detail Transactions > Document Details > GL Journal Date
Financials - GL Detail Transactions > Document Details > Journal Line Reference
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 > 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.
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:
W_AP_XACT_FS
(truncated)
W_AP_XACT_F
(deleted and inserted)
W_AP_XACT_F
APPR_STATUS_WID
VALD_STATUS_WID
(*applicable only to Fusion and EBS R12xx)
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)
Fact - Fins - AP Transaction > # Payments
Fact - Fins - AP Transaction > AP Count Payments without Invoice
Fact - Fins - AP Transaction > AP Payment Count
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 |
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
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
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:
W_AR_XACT_FS
(truncated)
W_AR_XACT_F
(deleted and inserted)
Tables with records added:
W_XACT_TYPE_D
(where INTEGRATION_ID
like ['ACCT_DOC~RECEIVABLE~CASH APPLICATION~%','ACCT_DOC~RECEIVABLE~PAYMENT~%']
)
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
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)
W_GL_REVN_FS
(records deleted)
W_GL_REVN_F
(records deleted and re-inserted)
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 |
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.
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) |