Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12 Release 12.1 Part Number E13482-03 | ![]() Contents | ![]() Previous | ![]() Next |
This appendix covers the following topics:
This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for Asia/Pacific Release 12.
Feature Area | Description of Change |
Additional Thailand Information (JA.TH.APXPAWKB.CHECKS) | Thai feature is obsolete and the context is disabled. The context had the following segments:
|
Feature Area | Description of Change |
Thai Additional Expense Information (JA.TH.APXXXEER.REPORT_HEADERS) | Thai feature is obsolete and the context is disabled. The context had the following segments:
|
Feature Area | Description of Change |
Singaporean Additional Invoice Information (JA.SG.APXINWKB.INVOICES) | GA1: Supplier Exchange Rate is now a named column: AP_INVOICES.SUPPLIER_TAX_EXCHANGE_RATE. |
Taiwanese Additional Invoice Information (JA.TW.APXINWKB.INVOICES) | Following segments are disabled and are now named columns:
|
Thai Additional Invoice Information (JA.TH.APXINWKB.INVOICES) | Thai feature is obsolete and the context is disabled. The context had the following segments:
|
Feature Area | Description of Change |
Taiwanese Additional Invoice Information (JA.TW.APXIISIM.INVOICES_FOLDER) | Following segments are replaced with named columns:
|
Thai Additional Invoice Information (JA.TH.APXIISIM.INVOICES_INTF) | Thai feature is obsolete and the context is disabled. The context had the following segments:
|
Feature Area | Description of Change |
Korean Additional Information (JA.KR.APXTADTC.WITHHOLDING) | GA1: Location Code is now a named column, ZX_REPORT_CODES_ASSOC.KR_BUSINESS_LOCATIONS. |
Taiwanese Additional Tax Code Information (JA.TW.APXTADTC.TAX_CODES) | GA1: Government Tax Type is now named columns:
|
Thai Additional Tax Code Information(JA.TH.APXTADTC.TAX_CODES) | GA1: Tax Invoice Location is replaced by ZX_RATES_B.DEF_REC-SETTLEMENT-OPTION_CODE |
Feature Area | Description of Change |
Korean Additional Information (JA.KR.ARXSUVAT.VAT) | GA1: Location is replaced with ZX_REPORT_CODES_ASSOC.KR_BUSINESS_LOCATIONS/ KR_LOCATION. |
Taiwanese Additional Tax Information (JA.TW.ARXSUVAT.VAT_TAX) | GA1: Government Tax Type is now named columns: ZX_STATUS.TAX_STATUS_CODE, ZX_REPORT_CODES_ASSOC.TW_GOVERNMENT_TAX_TYPE, and ZX_RATES.TAX_STATUS_CODE. |
Feature Area | Description of Change |
Korean Additional Information (JA.KR.PERWSLOC.WITHHOLDING) | The following segments are replaced by named columns:
|
Singaporean Additional Information (JA.SG.PERWSLOC.LOC) | The following segments are replaced by named columns:
|
Taiwanese Additional Location Information (JA.TW.PERWSLOC.LOC) | The following segments are replaced with named columns:
|
Feature Area | Description of Change |
Taiwanese Additional Transaction Information (JA.TW.ARXTWMAI.RA_CUSTOMER_TRX) | Following segments are disabled and are now named columns:
|
Feature Area | Description of Change |
Thai Additional Transaction Information (JA.TH.RAXSUCTT.CUST_TRX_TYPES) | Thai feature is Obsolete, and the context is disabled. |
This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for Europe Release 12.
Feature Area | Description of Change |
Belgian EFT Payments (BE.EFT Payments) | JGZZ_INVOICE_INFO1: IBLC Code is replaced by AP_INVOICES_ALL.PAYMENT_REASON_ID. |
Invoice Reference Text (FI.Vapaa viite) | JGZZ_INVOICE_INFO1: JEFI_REFERENCE_TEXT is replaced by AP_INVOICES_ALL.REMITTANCE_MESSAGE1. |
Invoice Reference Number (FI.Konekielinen viite) | JGZZ_INVOICE_INFO1:JEFI_REFERENCE_NO is replaced by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER. JGZZ_INVOICE_INFO2: JEFI_REFERENCE_CHECK is replaced by AP_INVOICES_ALL.URI_CHECK_DIGIT. |
Long Text (FI.Viesti) | The following segments are replaced by named columns:
|
Netherlands EFT Information (NL.Foreign Payments) | The following segments are replaced by named columns:
|
Norwegian EFT Information (NO.Norway) | The following segments are replaced by named columns:
|
Swedish EFT Bankgiro Inland (SE.Bankgiro Inland),Swedish EFT Postgiro Inland (SE.Postgiro Inland) | The following segments are replaced by named columns:
|
Swedish EFT Bankgiro SISU (SE.Bankgiro SISU) and Swedish EFT Bankgiro UTLI (SE.Bankgiro UTLI) | The following segments are replaced by named columns:
JGZZ_INVOICE_INFO3: Invoice Charge Code and JGZZ_INVOICE_INFO4: Future Contract are obsolete. |
Swedish EFT Postgiro Utland | The following segments are replaced by named columns:
JGZZ_INVOICE_INFO3: Future Contract Postgiro is obsolete. |
Swiss DTA EFT Invoice Format (CH.Swiss DTA Payment)Swiss SAD EFT Invoice Format (CH.Swiss SAD Payment) | JGZZ_INVOICE_INFO1: ESR Number is replaced by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER. |
Tax (FI.Vero) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Additional Bank Account Information (JE.DE.APXSUMBA.DD_CODE) | GA1: DD_CODE is replaced by IBY_EXT_PAYERS_GLB.DIRECT_DEBIT_BANK_INSTRUCTION. |
Additional EDI Information for Denmark (JE.DK.APXSUMBA.INT.EDI_INFO) | The following segments are replaced by named columns:
|
Additional EDI Information for Denmark (JE.DK.APXSUMBA.SUP.EDI_INFO) | The following segments are obsolete:
The following segments are replaced by named columns:
|
Swedish EFT Processes (JE.SE.APXSUMBA.PAYMENT_TYPE) | GA1: Payment type is replaced by a named column, IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID. |
Feature Area | Description of Change |
Bank Taxpayer ID Info (JE.ES.APXSUMBA.BANK_INFO) | GA1: Taxpayer ID is replaced by a named column, HZ_PARTIES.JGZZ_FISCAL_CODE. |
Feature Area | Description of Change |
Additional Info. for Spanish Invoice Distributions (JE.ES.APXINWKB_DISTS.INV_DIST) | The following segments are obsolete:
|
Additional Invoice Distribution Information (JE.HU.APXINWKB.STAT_CODE) | The following segments are obsolete:
GA6: STAT_CODE is replaced by PRODUCT_FISC_CLASSIFICATION in the following tables:
GA6: STAT_CODE is replaced by STATISTICAL_CODE, in the following tables:
GA6: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
|
Additional Invoice Distribution Information (JE.IT.APXINWKB.DISTRIBUTIONS) | GA1: Taxable Amount is replaced by a named column, ASSESSABLE_VALUE, in tables:
|
Additional Invoice Distribution Information (JE.PL.APXINWKB.STAT_CODE) | GA1: STAT_CODE is replaced by a named column, STATISTICAL_CODE, in the following tables:
GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables: ZX_FC_TYPES_B ZX_FC_CODES_B ZX_FC_CODES_DENORM_B |
Czech Invoice Distribution Information (JE.CZ.APINXWKB.FINAL) | GA1: Final VAT Register Request ID is obsolete. |
Hungarian Invoice Distribution Information (JE.HU.APINXWKB.FINAL) | The following segments are obsolete:
|
Feature Area | Description of Change |
Czech Invoice Distribution Information (JE.CZ.APXIISIM.FINAL),Hungarian Invoice Distribution Information (JE.HU.APXIISIM.FINAL),Polish Invoice Distribution Information (JE.PL.APXIISIM.FINAL), andSlovak Invoice Distribution Information (JE.SK.APXIISIM.FINAL) | GA1: Final VAT Register Request ID is replaced by the named column, JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID. |
HungarianAdditional Invoice Distribution Information (JE.HU.APXIISIM.STAT_CODE) | The following segments are obsolete:
GA5: Statistical Code is replaced by AP_INVOICE_LINES_ALL.PRODUCT CATEGORY and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY. |
Italian Invoice Distribution Information (JE.IT.APXIISIM.DISTRIBUTIONS) | The following segments are replaced by named columns:
|
Polish Invoice Distribution Information (JE.PL.APINXWKB.FINAL) and Slovak Invoice Distribution Information (JE.SK.APINXWKB.FINAL) | GA1: Final VAT Register Request ID is obsolete. |
Polish Additional Invoice Distribution Information (JE.PL.APXIISIM.STAT_CODE) | GA1: Statistical Code is replaced by AP_INVOICE_LINES_ALL.PRODUCT CATEGORY and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY. |
Feature Area | Description of Change |
Additional EDI Information for Denmark (JE.DK.APXINWKB.EDI_INFO) | The following segments are obsolete:
The following segments are replaced by named columns:
|
Additional Invoice Information (JE.CZ.APXINWKB.INVOICE_INFO) | The following segments are obsolete:
GA1: TAX_DATE is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE. GA3: IMPORT_DOC_NUM is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_NUMBER. |
Additional Invoice Information (JE.HU.APXINWKB.TAX_DATE) | GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE. |
Additional Invoice Information for France (JE.FR.APXINWKB.TAX_RULE) | GA1: Deduction Tax Rule is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE. |
Additional Information for Spanish Invoices (JE.ES.APXINWKB.INVOICE_INFO) | The following segments are obsolete:
|
Additional Tax Information (JE.PL.APXINWKB.INVOICE_INFO) | GA2: VAT_REGISTER is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE |
Slovak Additional Invoice Information (JE.SK.APXINWKB.INVOICE_INFO) | GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE. |
Social Insurance Information (JE.PL.APXINWKB.INSURANCE_INFO) | GA1: Insurance Premium Type is replaced by AP_INVOICES_ALL.PAYMENT_REASON_ID. |
Spanish Payables Operations with Third Party Extract - Modelo 347 (JE.ES.APXINWKB.MODELO347PR), Spanish Payables Inter-EU Operations Summary Data Extract - Modelo 349(JE.ES.APXINWKB.MODELO349), Spanish Payables Canary Islands Annual Operations Data Extract -Modelo 415(JE.ES.APXINWKB.MODELO415), Spanish Payables Operations with Third Party Extract − Modelo 347 and Spanish Payables Canary Islands Annual Operations − Modelo 415 (JE.ES.APXINWKB.MODELO415_347), Spanish Payables Operations with Third Party Extract − Modelo 347 and Spanish Payables Canary Islands Annual Operations − Modelo 415 (JE.ES.APXINWKB.MODELO415_347PR), and Spanish Receivables Invoice Type : Other (JE.ES.ARXTWMAI.OTHER) | GA1: Invoice Type is replaced by TRX_BUSINESS_CATEGORY in the following tables:
|
Feature Area | Description of Change |
Additional EDI Information for Denmark (JE.DK.APXIISIM.EDI_INFO) | The following segments are obsolete:
The following segments are replaced by named columns:
|
Additional Invoice Information (JE.CZ.APXIISIM.INVOICE_INFO) | GA1: TAX_DATE is replaced by AP_INVOICES_ALL.TAX_INVOICE_RECORDING_DATE.GA3: IMPORT_DOC_NUM is replaced by AP.TAX_INVOICE_INTERNAL_SEQ The following segments are obsolete:
|
Additional Invoice Information (JE.HU.APXIISIM.TAX_DATE) | GA1: TAX_DATE is replaced by AP_INVOICES_ALL.TAX_INVOICE_RECORDING_DATE. |
Additional Invoice Information for France (JE.FR.APXIISIM.TAX_RULE) | GA1: Deduction Tax Rule is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE. |
Additional Tax Information (JE.PL.APXIISIM.INVOICE_INFO) | The following segments are replaced by named columns:
|
Belgium EFT Payments (JE.BE.APXIISIM.EFT) | GA1: IBLC Code is replaced by named column, AP_INVOICES_INTERFACE.PAYMENT_REASON_ID. |
Invoice Reference Number (JE.FI.APXIISIM.KKL_VIITE) | The following segments are replaced by named columns:
|
Invoice Reference Text (JE.FI.APXIISIM.VAPAA_VIITE) | GA1: JEFI_REFERENCE_TEXT is replaced by AP_INVOICES_INERFACE.REMITTANCE_MESSAGE1. |
Netherlands EFT Information (JE.NL.APXIISIM.FOREIGN) | The following segments are replaced by named columns:
|
Norwegian EFT Information (JE.NO.APXIISIM.NORWAY) | The following segments are replaced by named columns:
|
Slovak Invoice Interface Information (JE.SK.APXIISIM.INVOICE_INFO) | GA1: Tax Date is replaced by AP.TAX_INVOICE_RECORDING_DATE.GA2: Check VAT Amount Paid is obsolete. |
Spanish Invoice Type: Modelo 347 (JE.ES.APXIISIM.MODELO347), Spanish Invoice Type: Modelo 347 - Property Rental (JE.ES.APXIISIM.MODELO347PR), Spanish Invoice Type: Modelo 349(JE.ES.APXIISIM.MODELO349) | GA1: Invoice Type is replaced by TRX_BUSINESS_CATEGORY.ZX_LINES_DET_FACTORS. |
Spanish Invoice Type: Modelo 347 (JE.ES.APXINWKB.MODELO347), Spanish Invoice Type: Modelo 349(JE.ES.APXINWKB.MODELO349), Spanish Invoice Type: Other (JE.ES.APXINWKB.OTHER) | GA1: Invoice Type is obsolete. |
Spanish Invoice Type: Modelo 349 (JE.ES.APXINWKB.MODELO349) | GA2: Correction Year and GA3: Correction Period are obsolete. |
Social Insurance Information (JE.PL.APXIISIM.INSURANCE_INFO) | GA1: Insurance Premium Type is replaced by AP.TAX_INVOICE_RECORDING_DATE |
Swedish EFT Bankgiro SISU (JE.SE.APXIISIM.BANK_SISU) Swedish EFT Bankgiro UTLI (JE.SE.APXIISIM.BANK_UTLI) | The following segments are replaced by named columns:
GA3: Invoice Charge Code and GA4: Future Contract are obsolete. |
Swedish EFT Postgiro Utland (JE.SE.APXIISIM.POST_UTLAND) | The following segments are replaced by named columns:
GA3: Future Contract Postgiro is obsolete. |
Swiss DTA EFT Invoice Format (JE.CH.APXIISIM.DTA) and Swiss SAD EFT Invoice Format (JE.CH.APXIISIM.SAD) | GA1: ESR Number is replaced by named column, AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER. |
Feature Area | Description of Change |
Reporting Entity Information (JE.PT.APXTRDRE.TAX_INFO) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Italian Additional Information (JE.IT.APXCUMSP.SYS_PARAMETER) | GA1: EXEMPTION_LIMIT_TAX_TAG is obsolete. |
Netherlands Additional Information (JE.NL.APXCUMSP.SYS_PARAMETER) | GA1: EFT_PAYMENT_SEPARATION is obsolete. |
Feature Area | Description of Change |
Additional Swiss Tax Code Information (JE.CH.APXTADTC.TAX_INFO) | GA1: Tax Regime is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.CH_VAT_REGIME. |
Additional Tax Information (JE.CZ.APXTADTC.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, Z ZX_TAXES_B.TAX and X_REPORT_CODES_ASSOC.CZ_TAX_ORIGIN. |
Additional Tax Information (JE.HU.APXTADTC.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.HU_TAX_ORIGIN. |
Additional Tax Information (JE.PL.APXTADTC.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PL_TAX_ORIGIN. |
Portuguese Tax Box Information (JE.PT.APXTADTC.TAX_INFO) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Additional Memo Line Information (JE.HU.ARXSTDML.STAT_CODE) and Additional Memo Line Information (JE.PL.ARXSTDML.STAT_CODE) | GA1: STAT_CODE is replaced by STATISTICAL_CODE in the following tables:
GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
|
Feature Area | Description of Change |
Additional Tax Information (JE.CZ.ARXSUVAT.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.CZ_TAX_ORIGIN. |
Additional Tax Information (JE.HU.ARXSUVAT.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.HU_TAX_ORIGIN. |
Additional Tax Information (JE.PL.ARXSUVAT.TAX_ORIGIN) | GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PL_TAX_ORIGIN. |
Portuguese Tax Box Information (JE.PT.ARXSUVAT.TAX_INFO) | The following segments are replaced by named columns: GA1: Location by ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PT_LOCATION. GA2: Periodic Taxable Box by ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PT_PRD_TAXABLE_BOX. GA3: Periodic: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_PRD_REC_TAX_BOX. GA4: Annual: Total Taxable Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_TTL_TAXABLE_BOX. GA5: Annual: Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAXABLE. GA6: Annual: Non Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_NON_REC_TAXABLE. GA7: Annual: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAX_BOX. |
Feature Area | Description of Change |
Greek Asset Information (JE.GR.FAXASSET.ASSET) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Greek Journal Information (JE.GR.GLXJEENT.HEADER) | GA1: Accounting Sequence Name and GA2: Accounting Sequence Number are obsolete. |
Feature Area | Description of Change |
Czech Journal Lines Information (JE.CZ.GLXJEENT.SEQUENCE), Hungarian Journal Lines Information (JE.HU.GLXJEENT.SEQUENCE), Poland Information (JE.PL.GLXJEENT.SEQUENCE), and Slovak Journal Lines Information (JE.SK.GLXJEENT.SEQUENCE) | GA3: Final Vat Register Request Id is replaced by JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID. |
Poland Information (JE.PL.GLXJEENT.SEQUENCE) | GA1: Journal Line Sequence and GA2: Journal Line Country are obsolete. |
Turkey Information (JE.TR.GLXJEENT.SEQUENCE) | GA2: Journal Line Country is obsolete. |
Feature Area | Description of Change |
Czech Set of Books Information (JE.CZ.GLXSTBKS.BOOKS), Hungarian Set of Books Information (JE.HU.GLXSTBKS.BOOKS), Poland Set of Books Information (JE.PL.GLXSTBKS.BOOKS), Slovakia Set of Books Information (JE.SK.GLXSTBKS.BOOKS) | GA1: VAT Reporting Calendar is replaced by JG_ZZ_VAT_REP_ENTITIES.TAX_CALENDAR_NAME.GA2: VAT Register Sequencing is replaced by JG_ZZ_VAT_REP_ENTITIES.ENABLE_REPORT_SEQUENCE_FLAG. |
Greek Set of Books Information (JE.GR.GLXSTBKS.BOOKS) | The following segments are obsolete:
|
Feature Area | Description of Change |
Greek Location Information (JE.GR.PERWSLOC.LOC) | The following segments are replaced by named columns:
|
Italian Location Information (JE.IT.PERWSLOC.LOC) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Spanish Customer Information (JE.ES.ARXCUDCI.RA) | GA1: Charges Bearer is replaced by IBY_EXT_PAYERS_GLB.BANK_CHARGE_BEARER. |
Feature Area | Description of Change |
AX NPI Organization Accounts (JE.IT.INVSDOIO.NPI parameters) | GA19: Invoices to be received and GA20: PO Mirror are obsolete. |
Feature Area | Description of Change |
Additional Item Information (JE.HU.INVIDITM.STAT_CODE) and Additional Item Information (JE.PL.INVIDITM.STAT_CODE) | GA1: STAT_CODE is replaced by a named column, STATISTICAL_CODE, in the following tables:
GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
GA1: STAT_CODE is replaced by MTL_CATEGORIES.SEGMENT1. |
AX NPI Item Accounts (JE.IT.INVIDITM.NPI_SYSTEM_ITEM) | The following segments are obsolete:
|
Feature Area | Description of Change |
Addition Vendor Site Information for Israel (JE.IL.APXVDMVD.TAXPAYER_ID) | GA1: TAXPAYER_ID is obsolete. |
Additional Information (JE.CZ.APXVDMVD.PO_VENDORS) | GA1: SPECIFIC_SYMBOL is obsolete. |
Additional Supplier Site Information for Italy (JE.IT.APXVDMVD.DOC_CATEGORY) | GA1: JEIT_DOCUMENT_CATEGORY_NAME is obsolete. |
Feature Area | Description of Change |
Additional Information for Spanish Invoices (JE.ES.ARXTWMAI.INVOICE_INFO) | The following segments are obsolete:
|
Additional Transaction Information (JE.CZ.ARXTWMAI.TAX_DATE) | GA2: VAT_REGISTER_TRX is obsolete |
Additional Transaction Information (JE.HU.ARXTWMAI.TAX_DATE), Additional Transaction Information (JE.SK.ARXTWMAI.TAX_DATE), Additional Transaction Information (JE.PL.ARXTWMAI.TAX_DATE), and Additional Transaction Information (JE.CZ.ARXTWMAI.TAX_DATE) | GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE. |
Additional Transaction Information (JE.PL.ARXTWMAI.TAX_DATE) | GA2: VAT_REGISTER_TRX is obsolete |
Spanish Receivables Invoice Type : Modelo 347 - Property Rental (JE.ES.ARXTWMAI.MODELO347PR), Spanish Receivables Invoice Type : Modelo 349 (JE.ES.ARXTWMAI.MODELO349), Spanish Receivables Invoice Type : Modelo 415 (JE.ES.ARXTWMAI.MODELO415), Spanish Receivables Invoice Type : Modelo 415 & Modelo 347 (JE.ES.ARXTWMAI.MODELO415_347), and Spanish Receivables Invoice Type : Modelo 415 & Modelo 347 - Property Rental (JE.ES.ARXTWMAI.MODELO415_347PR) | GA1: Invoice Type is replaced by a named column, TRX_BUSINESS_CATEGORY, in the following tables:•
GA1: Invoice Type is replaced by ZX_LINES_DET_FACTORS.TRX_BUSINESS_CATEGORY. |
Spanish Receivables Invoice Type : Modelo 349 (JE.ES.ARXTWMAI.MODELO349) | GA5: Triangulation is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE. |
Spanish Receivables Invoice Type : Other (JE.EX.ARXTWMAI.OTHER) | GA1: Invoice Type is obsolete. |
Feature Area | Description of Change |
CZ Receivables VAT Register Informations (JE.CZ.ARXTWMAI.REGISTER_INFO), HU Receivables VAT Register Informations (JE.HU.ARXTWMAI.REGISTER_INFO), PL Receivables VAT Register Informations (JE.PL.ARXTWMAI.REGISTER_INFO), and SK Receivables VAT Register Informations (JE.SK.ARXTWMAI.REGISTER_INFO) | GA1: Final Vat Register Request ID is replaced by JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID. |
HU Receivables VAT Register Informations (JE.HU.ARXTWMAI.REGISTER_INFO) | The following segments are obsolete:
|
Feature Area | Description of Change |
Additional Transaction Type Information (JE.ES.RAXSUCTT.INV_TYPE) | GA10: INV_TYPE is obsolete. |
Additional Transaction Type Information (JE.HU.RAXSUCTT.REVALUATION) | GA1: Revaluate Transaction type is obsolete. |
Feature Area | Description of Change |
LMP Format (LI.LMP) | JGZZ_FORMAT_INFO2: JEFI_ILLEGAL_CHARS and JGZZ_FORMAT_INFO3: JEFI_LEGAL_CHARS are obsolete. JGZZ_FORMAT_INFO5: JEFI_EDI_IDENTIFIER is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE. JGZZ_FORMAT_INFO6: JEFI_PROCESSING is replaced by IBY_PAYMENT_PROFILES.BANK_INSTRUCTION1_ID. |
LUM2 Format (FI.LUM2) | JGZZ_FORMAT_INFO1: JEFI_CONTRACT_NO is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_VALUE. JGZZ_FORMAT_INFO7: JEFI_EFT_NUMBER_LUM2 is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE. JGZZ_FORMAT_INFO2: JEFI_ILLEGAL_CHARS and JGZZ_FORMAT_INFO3: JEFI_LEGAL_CHARS are obsolete. |
ULMP Format (FI.ULMP) | JGZZ_FORMAT_INFO1: JEFI_CONTRACT_NO is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_VALUE. The following segments are obsolete:
|
Feature Area | Description of Change |
German Payment Schedule Level Declaration (DE.U) | The following segments are obsolete:
JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For examples, DECLARATION_THRESH_AMOUNT and DECLARATION_OPTION_FLAG). |
German Payment Schedule Level Declaration (DE.V) | The following segments are obsolete:
JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For examples, DECLARATION_THRESH_AMOUNT, and DECLARATION_OPTION_FLAG). |
German Payment Schedule Level Declaration (DE.W) | The following segments are obsolete: JGZZ_PS_INFO1: Country Name JGZZ_PS_INFO9: Record Type JGZZ_PS_INFO17: Reason JGZZ_PS_INFO18: Alpha JGZZ_PS_INFO19: Numeric JGZZ_PS_INFO28: Buyers Address JGZZ_PS_INFO20: Explanation is replaced byAP_INVOICES_ALL.REMITTANCE_MESSAGE1. JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For example, DECLARATION_THRESH_AMOUNT and DECLARATION_OPTION_FLAG) |
Feature Area | Description of Change |
Austrian Vendor Site EFT Information (AT) | JGZZ_SITE_INFO1: BANK_CHARGE_CODE is replaced by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER. |
Belgium Vendor Site EFT Information (BE) | JGZZ_SITE_INFO1: IBLC/BLIW Trade is replaced by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_REASON_ID. JGZZ_SITE_INFO1: Foreign Payment Cost Code is replaced by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER. |
Finnish Vendor Site EFT Information (FI) | The following segments are replaced by named columns:
JGZZ_SITE_INFO2: JEFI_DEPENDENCE is obsolete. |
German Vendor Site Level EFT Parameters (DE) | The following segments are replaced by named columns:
The following segments are obsolete:
|
Netherlands EFT Vendor Site Formats (NL) | The following segments are replaced by named columns:
|
Super set of NO's EFT vendor formats (NO) | The following segments are replaced by named columns:
|
Swedish Vendor Site Format (SE) | The following segments are replaced by named columns:
JGZZ_SITE_INFO1: Receiver Name is obsolete. |
Swiss Vendor Site EFT Information (CH) | JGZZ_SITE_INFO2: Payment Type is replaced by IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID. |
Feature Area | Description of Change |
DTA Payment Format for Switzerland (CH.JECHRDTA) | The following segments are obsolete:
JGZZ_SYSTEM_INFO6: Company TELEKURS ID and JGZZ_SYSTEM_INFO7: Department TELEKURS ID are replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE. |
EFT format for Bankgiro Foreign SISU Sweden (SE.JESEPBSI) and EFT format for Bankgiro Foreign UTLI Sweden (SE.JESEPBUT) | JGZZ_SYSTEM_INFO8: EFT File Directory is replaced by IBY_PAYMENT_PROFILES.OUTBOUND_PMT_FILE_DIRECTORY. The following segments are obsolete:
|
EFT format for Bankgiro Inland Sweden (SE.JESEPBAI) | The following segments are replaced by named columns:
The following segments are obsolete:
|
EFT Format for Netherlands Foreign Payments (NL.JENLFFGN) | The following segments are replaced by named columns:
JGZZ_SYSTEM_INFO13: EFT Rate Type is obsolete. |
EFT format for Postgiro Foreign Sweden (SE.JESEPPOU) | The following segments are replaced by named columns:
The following segments are obsolete:
|
EFT format for Postgiro Inland Sweden (SE.JESEPPOI) | The following segments are replaced by named columns:
The following segments are obsolete:
|
German System Level EFT Parameters (DE.JEDEDEFI) | The following segments are replaced by named columns:
|
Norwegian BBS (NO.JENOPBDR) | The following segments are replaced by named columns:
The following segments are obsolete:
|
Norwegian Datadialog (NO.JENOPDDG) | JGZZ_SYSTEM_INFO1: Customer ID is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE. The following segments are obsolete:
|
Norwegian Telepay (NO.JENOPTGN) | The following segments are replaced by named columns:
|
SAD Payment Format for Switzerland (CH.JECHRSAD) | The following segments are obsolete:
JGZZ_SYSTEM_INFO7: Company PTT File ID replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE. |
This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for the Americas Release 12.
Feature Area | Description of Change |
Brazilian Additional Information (JL.BR.APXSUMBA.AR.Additional) | GA3: Country Code is replaced by named columns:
GA7: Company Code for Bank is replaced by a named column, CE_BANK_ACCOUNTS.SECONDARY_ACCOUNT_REFERENCE. |
Feature Area | Description of Change |
Columbian Bank Information (JL.CO.APXSUMBA.BANKS) | GA11: Primary ID Number is replaced by a named column, HZ_PARTIES.JGZZ_FISCAL_CODE. GA3: Country Code is replaced by named columns:
|
Feature Area | Description of Change |
Argentine Distribution Information (JL.AR.APXINWKB.DISTRIBUTIONS) | GA3: Ship To Location is replaced by named columns:
|
Brazilian Additional Tax Information (JL.BR.APXINWKB.D_SUM_FOLDER) | GA1: Operation Fiscal Code is replaced by the named columns:
|
Columbian Distribution Information (JL.CO.APXINWKB.DISTRIBUTIONS) | GA3: Ship To Location is replaced by named columns:
|
Feature Area | Description of Change |
Argentine Open Interface Invoice Lines Information (JL.AR.APXIISIM.LINES_FOLDERPayables) and Columbian Open Interface Invoice Lines Information (JL.CO.APXIISIM.LINES_FOLDER) | GA3: Ship To Location is obsolete. |
Brazilian Open Interface Invoice Lines Information (JL.BR.APXIISIM.LINES_FOLDER) | GA1: Operation Fiscal Code is replaced with a named column: ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY. |
Feature Area | Description of Change |
Additional Information (JL.BR.APXINWKB.AP_INVOICES) | GA2: Operation Fiscal Code is replaced by the named columns:
Brazilian AP/PO feature is obsolete and the following segments are obsolete:
|
Argentine Invoice Information (JL.AR.APXINWKB.INVOICES) | The following segments are replaced with the named columns:
|
Columbian Invoices Information (JL.CO.APXINWKB.INVOICES) | GA18: Ship To Location is replaced by named columns:
|
Feature Area | Description of Change |
Brazilian Open Interface Information (JL.BR.APXIISIM.INVOICES_FOLDER) | GA2: Operation Fiscal Code is replaced by a named column: ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY. Brazilian AP/PO feature is obsolete and the following segments are obsolete:
|
Feature Area | Description of Change |
Brazilian Additional Information (JL.BR.APXCUMSP.SYS_PARAMETER) | GA4: Payment Location is renamed to Payment Location City. The following segments added. Previously, they were profiles:
|
Feature Area | Description of Change |
Argentine Tax Names Information (JL.AR.APXTADTC.TAX_NAMES) | GA4: Withholding Type is replaced by ZX_REPORT_CODES_ASSOC.AR_DGI_TRX_CODE. |
Chilean Tax Information (JL.CL.APXTADTC.AP_TAX_CODES) | GA19: Tax Category is replaced by a named column, ZX_REPORT_CODES_ASSOC.CL_TAX_CODE_CLASSIF. |
Feature Area | Description of Change |
Argentine Standard Memo Lines Information (JL.AR.ARXSTDML.AR_MEMO_LINES), Brazilian Additional Information (JL.BR.ARXSTDML.Additional), Columbian Standard Memo Lines Information (JL.CO.ARXSTDML.AR_MEMO_LINES), and Fiscal Classification Code (JL.BR.ARXSDML.Additional) | GA1: Fiscal Classification Code is replaced by the named columns:
|
Feature Area | Description of Change |
Chilean Receipt Class Information (JL.CL.ARXSUDRC.RECEIPT_CLASS) | The following segments are obsolete:
|
Feature Area | Description of Change |
Brazilian Additional Information (JL.BR.ARXSYSPA.Additional Info) | The following segments are obsolete:
|
Feature Area | Description of Change |
Argentina Tax Codes and Rates (JL.AR.ARXSUVAT.AR_VAT_TAX) | The following segments are replaced by named columns:
|
Brazilian Tax Information (JL.BR.ARXSUVAT.Tax Information) andColumbian Tax Codes and Rates (JL.CO.ARXSUVAT.AR_VAT_TAX) | The following segments are replaced by named columns:
|
Chilean Tax Codes and Rates Information (JL.CL.ARXSUVAT.VAT_TAX) | The following segments are replaced by named columns:
|
Feature Area | Description of Change |
Columbian Additional Information (JL.CO.GLXJEENT.THIRDPARTY) | GA1: Third Party ID is replaced with a named column: GL_JE_LINES.CO_THIRD_PARTY. |
Feature AreDescription of Changea | |
Argentine Locations Information (JL.AR.PERWSLOC.LOC), Chilean Locations Information (JL.CL.PERWSLOC.LOC), and Columbian Locations Information (JL.CO.PERWSLOC.LOC) | The following segments are replaced by named columns:
|
Argentine Locations Information (JL.AR.PERWSLOC.LOC) | GA14: Inception Date is replaced by XLE_ETB_PROFILES.EFFECTIVE_FROM |
Chilean Locations Information (JL.CL.PERWSLOC.LOC) | GA13: Inscription is replaced by XLE_ENTITY_PROFILES.ACTIVITY_CODE, XLE_ETB_PROFILES.ACTIVITY_CODE GA14: Legal Representative to HZ_PARTIES_PARTY_NAME GA15: Legal Representative ID is replaced by HZ_PARTIES.PARTY_NUMBER |
Columbian Locations Information (JL.CO.PERWSLOC.LOC) | GA4: Activity Code is replaced by XLE_ENTITY_PROFILES.ACTIVITY_CODE. GA14: Economic Activity Code is replaced by XLE_ETB_PROFILES.ACTIVITY_CODE. |
Feature Area | Description of Change |
Brazilian Fiscal Information (JL.BR.INVIDTMP.Fiscal) | GA1: Fiscal Classification Code is replaced by the following named columns:
|
Feature Area | Description of Change |
Argentine Master Items Information(JL.AR.INVIDITM.SYSTEM_ITEMS), Brazilian Fiscal Information (JL.BR.INVIDITM.XX.Fiscal), and Columbian Master Item Information / Inflation Accts.( JL.CO.INVIDITM.SYSTEM_ITEMS) | GA1: Fiscal Classification Code is replaced by the following named columns:
|
Feature Area | Description of Change |
Argentine Order Lines Information (JL.AR.OEXOEORD.LINES) and Columbian Order Lines Information (JL.CO.OEXOEORD.LINES) | GA5: Fiscal Classification Code is replaced by the following named columns:
|
Brazilian Order Line Information (JL.BR.OEXOEORD.LINES) | The following segments are replaced by the named columns:
GA13: Default federal Tributary Situation is corrected as Default Federal Tributary Situation. GA14: Default State Tributary is corrected as Default State Tributary Situation. |
Feature Area | Description of Change |
Brazilian Additional Information (JL.BR.ARXTWMAI.Additional Info) | The following segments are replaced by the named columns:
|
Argentine Invoice/Tax Lines (JL.AR.ARXTWMAI.LINES) and Columbian Invoice/Tax Lines (JL.CO.ARXTWMAI.LINES) | The following segments are replaced by the named columns:
|
Feature Area | Description of Change |
Argentine Customer Transaction Information (JL.AR.ARXTWMAI.TGW_HEADER) | The following segments are replaced by the named columns:
|
Copyright © 2006, 2010, Oracle and/or its affiliates. All rights reserved.