ebs 121 cum rcd fin patches

E E CONTENT DOCUMENT

Financials Release 12.1 (through 12.1.3)

Prepared by EBS Product Management & Strategy Last Updated: October 6, 2010

3.0 Copyright © 2010 Oracle Corporation All Rights Reserved

ORACLE E-BUSINESS SUIT

RELEAS

Version:

Table of Contents

1. 1

. 2 2.1. 2

3 3.1. 3

1. 3 2. 3

urge Rejected Intercompany Batches from Interface Table 3

3.2. 3 1. .1 3

Customer Dispute Enhancement 3

Contract Level 4 .2 4

agement 4 3. 4

4

3.3. 4 1. 4

Tax Reform 2007 4

3.4. 5 5

onal Bank Account Number (IBAN) Support 5 ) Support 5

ent Reconciliation 5 5

ank Accounts 5 ormat Update 6

ank Transaction Codes 6 3.4.2.4. Load Bank Statements for the Current Day 6

3.4.1. Release 12.1.3 6 3.4.1.1. Manual Entry in Cash Position 6

3.5. Oracle Credit Management 7 3.5.1. Release 12.1.3 7

3.5.1.1. Configurable Analyst Assignment Rules 7

3.6. Oracle Financials for EMEA 7 3.6.1. Release 12.1.1 7

3.6.1.1. Business Intelligence Publisher Support for Select EMEA Reports 7 3.6.1.2. Enhanced Statutory Report Extracts for Italy 7

3.7. Oracle Financials for India 8

Disclaimer

2 Introduction Purpose of Document

3. New and Changed Features in Financials Oracle Advanced Global Intercompany System (AGIS)

3.1. Overview 3.1. Release 12.1.2

3.1.2.1. P

Oracle Advanced Collections3.2. Release 12.1

3.2.1.1.3.2.1.2. Customer Level Bankruptcy 33.2.1.3. Status Assignment at Case and

3.2.2. Release 12.13.2.2.1. Multiple Level Collections Strategy Man

3.2. Release 12.1.3 3.2.3.1. Staged Dunning

Oracle Assets 3.3. Release 12.1.3

3.3.1.1. Asset Impairment for Japan

Oracle Cash Management

3.4.1. Release 12.1.1

3 nternati.4.1.1. I3.4.1.2. Bank Identifier Code (BIC3.4.1.3. Payment Group based Bank Statem.4 e 12.1.23 .2. Releas3.4.2.1. Option to Override Country-Specific Validation for B3.4.2.2. EDIFACT Bank Statement F3.4.2.3. Copy B

Oracle E-Business Suite Release 12.1 Release Content Document

ii

3.7. Release 12.1.1 1. 8 efit Tax Support 8

8 8

port for India 8 2. 8

8 chase Order Workflow Notification for India 8

9 9

Support 9 lay of Value Added Tax (VAT) Invoice Number in Receivables Transaction Workbench for India

3.8. 9 1. 9

nhanced Financial Statement Generator Reporting to Display Content Set Values 9 2. 9

tatement Generator Reporting to Support Drill-down for Non-Contiguous Account

ancial Statement Publishing 10 3. 10

ournals between Primary and Secondary Ledgers 10 10

3.9. 1. 10

tachments from Invoice 10 ipts Required for Mileage Category 10

rge of Expense Reports 11 Read-Only Access to Per Diem and Mileage Details in Audit 11

MEX Loader Option to Not Load Payment Transactions 11 . 11

ment Enhancements 11 te Expense Detection 11

3.10. 11 lease 12.1.3 11

3.11. 12 1 12

plication Fees without Loan Approval 12 12 12

2 12 an Servicing 12

3.12. Oracle Payables 13 3.12.1. Release 12.1.1 13

3.12.1.1. Enhanced Withholding Tax Calculation for Brazil 13 3.12.1.2. Discount Calculation Enhancements 13 3.12.1.3. Subcontractor Management for Engineering and Construction 13 3.12.1.4. Supplier Dispute Processing 13 3.12.1.5. Third Party Payments 13 3.12.1.6. Business Intelligence Publisher Support for Selected Payables Reports 14

3.12.2. Release 12.1.2 14 3.12.2.1. Replace Supplier Bank Accounts on Invoices 14 3.12.2.2. Change Taxes from Inclusive to Exclusive Online 14

3.13. Oracle Payments 14

3.7.1.1. Fringe Ben3.7.1.2. Inclusive Tax Support

etroactive Pricing Support

3.7.1.3. R3.7.1.4. Payables Invoices Sup

3.7. Release 12.1.2 3 dvanced Pricing Support for India .7.2.1. A3.7.2.2. Tax Information on Pur3.7.2.3. Reassessing Service Tax on Receipt of Foreign Payments for India

3.7.3. Release 12.1.3 3.7.3.1. Descriptive Flex Field (DFF)3.7.3.2. Disp 9

eneral Ledger Journal Drill-Down Support 93.7.3.3. G

Oracle General Ledger 3.8. Release 12.1.1

3.8.1.1. E3.8. Release 12.1.2

3.8.2.1. Enhanced Financial SRanges 9 3.8.2.2. Streamlined Excel-based Fin

3.8. Release 12.1.3 3.8.3.1. Synchronize Reversing J 3.8.3.2. Limit Accounts in Budget Wizard

Oracle Internet Expenses 103.9. Release 12.1.2

3.9.1.1. Access Expense At3 upport Rece.9.1.2. S3.9.1.3. Archive and Pu3.9.1.4.3.9.1.5. A

3.9.2 Release 12.1.3 3.9.2.1. Expense Receipt Manage3.9.2.2. Duplica

Oracle Legal Entity Configurator 3.10.1. Re

3.10.1.1. Enhanced Legal Addresses 11

Oracle Loans 3.11. . Release 12.1.2

3.11.1.1. Process Ap3.11.1.2. Ad-hoc Billing and Receipt Application 3.11.1.3. Loan Forgiveness

3.11. . Release 12.1.3 Multiple Disbursements during Lo3.11.2.1.


iii

3.13.1. Overview 14 2 15

EPA) Support 15 n 15

ditional Parameters 15 15

PA-DSS for Credit Card Processing 15

3.14. 16 iew 16 e 12.1.1 16

usiness Rules that Reference Disabled/Inactive Dimensi n Members 16

3.15. 16 1 16

16 17

bles Processing 17 x Adaptor Enhancements for Mainland China 17

usiness Intelligence Publisher Support for Selected Receivables Reports 18 2 18

Receipts 18 eivables 18

3.16. 18 ease 12.1.1 18

istorical Data Initialization for New Reporting Currencies and Secondary Ledgers 18 2 19

ccounting Rules Detail Report and Enhanced Subledger Accounting Onl ne Inquiry 19 rade by Subledger 19

19 s Qualifier 19

3.17 20 1 20

for Counterparty Ba s 20 20

econcile Treasury Transactions of all Deal Types 20

3.18. 20 1 20

2 21

ng 21 anges for Central Contractor Registration (CCR) 21

3.19. 21 1 21 2 21

c Invoice Integratio 21 3.19.2.2. Japan: Asset Depreciation Enhancements for Japan Tax Reform Act of 2007 22 3.19.2.3. United Kingdom: Reverse Charge VAT 23

3.19.3. Release 12.1.2 23 3.19.3.1. Argentina: Turnover Tax Withholding/Perception Regimes 23 3.19.3.2. Brazil: Federal SPED Regulation - Accounting SPED 24 3.19.3.3. China: Golden Tax Adapter Enhancements 26 3.19.3.4. Italy: Annual VAT Extract 26 3.19.3.5. Italy: Annual Withholding Extract 26 3.19.3.6. Japan: Enhanced Support for Tax Reform 2007/2008 26 3.19.3.7. Spain: VAT Legislation: Modelo 340 Informative Declaration 27 3.19.3.8. Spain: VAT Legislation: Modelo 347 Domestic Transactions Turnover Report Changes 28 3.19.3.9. Spain: VAT Legislation: Modelo 415 Canary Island Turnover Report Changes 28

3.13. . Release 12.1.1 3.13.2.1. Single Euro Payments Area (S

aymentech Integration Certificatio

3.13.2.2. P3.13.2.3. Positive Pay File with Ad

3.13.3. Release 12.1.2 3.13.3.1.

Oracle Profitability Manager 3.14.1. Overv3.14.2. Releas

3.14.2.1. Identification of B o

Oracle Receivables 3.15. . Release 12.1.1

3 ash Application Work Queue .15.1.1. C3.15.1.2. Enhanced Line Level Cash Application 3.15.1.3. Enhanced Performance for High Volume Receiva3.15.1.4. Golden Ta3.15.1.5. B

3.15. . Release 12.1.2 3.15.2.1. Default Customer Bank Account Information on Unidentified

Multi-Fund Accounts Rec

3.15.2.2. Enhanced Aging Report to Support

Orac e Subledger Accountingl3.16.1. Rel

3.16.1.1. H3.16. . Release 12.1.2

3.16.2.1. A i3.16.2.2. Accounting Data On-Demand Upg

3.16.3. Release 12.1.3 3.16.3.1. New Control Account

. Oracle Treasury 3.17. . Release 12.1.2

ank Account Number (IBAN) Support3.17.1.1. International B nk Account lease 12.1.3 3.17.2. Re

3.17.2.1. R

Oracle U.S. Federal Financials 3.18. . Release 12.1.2

3.18.1.1. Enhanced Delinquency Processing 20

n

3.18. . Release 12.1.3 Processi3.18.2.1. Updates to Year-End Close

3.18.2.2. Extract File Ch

Tax, Legal and Regulatory Updates 3.19. . Overview 3.19. . Release 12.1.1

3.19.2.1. Brazil: Fiscal SPED – Support for Fiscal Book Generation and Electroni


iv

3.19.3.10. Spain: Changes to Taxpayer ID Validation 3.19.3.11. United Kingdom: S n

28 upport for Revaluations and Impairments per Stateme t of Recommended Practice for

29 29

Central Contractor Registration (CCR) Processing ce with International A counting Standard 36 30

30 4 30

to) 30 31

s (DDA) 31 31

e Added Tax (VAT) Functionality to Support Flexible Recovery Sch ule for India

ing and Reporting for Non-Shippable Items 32 ent 32

32 r Central Contractor Registration (C R) 33

ederal: Regulatory Updates to Statement of Budgetary Resources 33 egulatory Updates to SF-133 Report 33

ean Community VAT Changes for 2010 34

4. Real Estate Management 35 4.1. 35

1. 35 eatures 35

Statuses 35 ancements 35

ntraction 36 ercent Determined by Attribute on Tenancy 36

ame Schedule Day 36 ed on a New Start Day Field 36

. 36

reakpoint Enhancements 36 of Agreement or Lease 37

iable Rent Agreements 37 ethods 37

ear Calculation Methods 37 oll Forward of Variable Rent Agreements 38 mulative Calculation Method 38

batements 38 ent as Negative Rent 38

38 38

onal Frequency Attribute 39 4.1.3.15. Streamlining of Adjustments 39 4.1.3.16. Form Enhancements 39 4.1.3.17. Display of Calculation Results 39 4.1.3.18. Variable Rent Templates 39 4.1.3.19. Term Template Enhancements 39 4.1.3.20. Processing by Property 40 4.1.3.21. Improved Variable Rent Report 40

4.1.4. Release 12.1.1 Index Rent Features 40 4.1.4.1. Early Termination of Rent Increase Agreements 40 4.1.4.2. Extension of Rent Increase Agreements 40 4.1.4.3. Month-to-Month Roll Forward 40 4.1.4.4. Index Multiplier 40

United Kingdom Local Authority Accounting 3.19.3.12. U.S. Federal: New FACTS II Edit Checks and File Layout Changes 3.19.3.13. U.S. Federal: Enhanced 293.19.3.14. G clobal: Support for Asset Impairment in Accordan

ss 3.19.3.15. Global: Year End Closing Proce3.19. . Release 12.1.3

3.19.4.1. Argentina: Support for Argentina Simplified Regime (Monotribu3.19.4.2. Belgium: Annual VAT Report File Format v1.3 3.19.4.3. Brazil: Support for Brazilian Electronic Collection Document Proces

n 2 of the China Accounting Software Data Interface Standard3.19.4.4. China: Support for Versio3.19.4.5. India: Enhanced Valu ed 31 3.19.4.6. India: Value Added Tax (VAT) Statutory Account3.19.4.7. Israel: Israel VAT Report Enhancem3.19.4.8. Israeli: Withholding Tax File – 856 3.19.4.9. U.S. Federal: Extract File Changes fo C3.19.4.10. U.S. F3.19.4.11. U.S. Federal: R

urop3.19.4.12. Global: E

New and Changed Features inOracle Property Manager 4.1. Overview 4 1 2. Release 12.1.1 Leasing F. .

4.1.2.1. New Lease4.1.2.2. Lease Extension Enh4.1.2.3. Tenancy Extension and Co4.1.2.4. Assignment Occupancy P4.1.2.5. Multiple Schedules for S4.1.2.6. Prorating the Billing/Payment Amount bas

4.1. Release 12.1.1 Variable Rent Features34.1.3.1. Breakpoint Flexibility 36

dating Breakpoints 364.1.3.2. Up4.1.3.3. Natural B4.1.3.4. Early Termination 4.1.3.5. Extension of Var4.1.3.6. New Calculation M4.1.3.7. New Partial Y4.1.3.8. Month-to-Month R4.1.3.9. Enhancement to Cu 4.1.3.10. Allowances and A4.1.3.11. Carry Forward of Excess Abatem4.1.3.12. Constraints 4.1.3.13. Updat4.1.3.14. Additi

ing Volumes


v


vi

ation 40 40

e Option 40 s 41

41 5. Features 41

greement 41 Payment Terms 42

4.1.5.3. Reconciliation 42 4.1.5.4. Operating Expense Agreement Dashboard 43

4.1.4.5. Pror4.1.4.6. Term Length4.1.4.7. Include/Excl ud4.1.4.8. Recurring Backbill Term4.1.4.9. Rent Increase Report

4.1. Release 12.1.1 Operating Expenses 4.1.5.1. Create Operating Expense A4.1.5.2. Enter and Maintain Estimated

1. Disclaimer This Release Content Document (RCD) describes product featuthe specified releases of the Oracle E-Business Suite. This dochanged functionality o

res that are proposed for cument describes new or

nly. Existing functionality from prior releases is not described. It grading to the specified

proprietary information of this confidential

cle Software License and and with which you agree to comply. This

t of Oracle. This rporated into any .

ed solely to assist you in res described. It is not a

commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

is intended solely to help you assess the business benefits of uprelease of the Oracle E-Business Suite.

This document in any form, software or printed matter, containsthat is the exclusive property of Oracle. Your access to and usematerial is subject to the terms and conditions of your OraService Agreement, which has been executeddocument and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consendocument is not part of your license agreement nor can it be incocontractual agreement with Oracle or its subsidiaries or affiliates

This document is for informational purposes only and is intendplanning for the implementation and upgrade of the product featu

Oracle E-Business Suite Release 12.1.Release Content Document 4BPurpose of Document 1

2. Introduction

2.1. Purpose of Document

This Release Content Document (RCD) communicates information about new or changed 12.1 and subsequent 12.1.x

the release in which they first became available. Release 12.1.1 was the first generally-available

h on Release 12.1.1, but res released in RUP2 of

2.0, Release 12.0.x Release Update Packs (RUPs), or prior releases is not described in this document. For a complete overview of all functionality included in prior releases, this document should be read in conjunction with the Release 12 and Release 12.0.x RUP RCDs. These RCDs can be found in My Oracle Support Knowledge Document 404152.1 Release Content Documents for E-Business Suite Release 12 and 12.0.x Release Update Packs.

functionality introduced in Oracle E-Business Suite ReleaseRelease Update Packs and off-cycle patches.

For your convenience, features are organized by product, and then by

release of Release 12.1. Features released in an off-cycle patcbefore Release 12.1.2, are designated as Release 12.1.1+. FeatuRelease 12.1 are designated as Release 12.1.2, and so on.

Existing functionality in Release 1

Oracle E-Business Suite Release 12.1.Release Content Document 4BPurpose of Document 2

3. New and Changed Features in Financials

3.1. Oracle Advanced Global Intercompany System (AGIS)

3.1reamlines the intercompany

IS facilitates balanced a forum for trading ntrolled manner.

l regulations, but also to follow established corporate standards for processing intercompany transactions between related legal entities of an enterprise. It also provides interactive reconciliation reporting,

allows drilldown to the details of Intercompany Account Balances so the source of discrepancies to the balances of each trading partner’s account balances can be found

3.1

ace Table

.1. Overview Oracle Advanced Global Intercompany System (AGIS) sttrading and reconciliation process across ledgers. Oracle AGintercompany transactions for the global enterprise by providingpartners to record and approve intercompany transactions in a co

Oracle AGIS allows companies to comply not only with loca

which

quickly.

.2. Release 12.1.2

3.1.2.1. Purge Rejected Intercompany Batches from Interf

Oracle AGIS introduces a new Purge Rejected Intercompapurge rejected intercompany transaction batches from intercom

ny Transactions Program to pany interface tables.

Oracle AGIS validates intercompany transaction batches imported from external source atches that pass validation become intercompany transactions in AGIS.

Batches that fail validation are retained in the intercompany interface table with a ted status. These rejected intercompany transactions occupy space in the database

and can lead to detrimental impact on system performance. Users can use the new iew and purge the rejected intercompany transactions.

3.2.

applications. B

Rejec

concurrent program to prev

Oracle Advanced Collections

3.2.1. Release 12.1.1

3.2.1.1. Customer Dispute Enhancement

Collectors require the ability to record comments while researching transactions and interacting with customers during the dispute process. A new Internal Comment field is available on all screens used to submit and manage disputes. This field streamlines the dispute submission and approval process by allowing collectors to enter and share comments to internal users such as receivables specialists.

3.2.1.2. Customer Level Bankruptcy

During various stages of a customer’s bankruptcy process their outstanding business transactions require specialized handling. In prior releases of Advance Collections,

Oracle E-Business Suite Release 12.1.Release Content Document 5BOracle Advanced Global Intercompany System (AGIS) 3

individual transactions had to be marked with a Bankruptcy stacan now assign Bankruptcy status at the cus

tus. Collections agents tomer level, ensuring that all transactions in

d uniformly.

This feature has also been back-ported to 12.0 via the standalone patch:

Level

all accounts and bill to sites are status and manage

8522751:R12.IEX.A.

3.2.1.3. Status Assignment at Case and Contract

Collectors can now better manage their leasing delinquencies by assigning delinquency levels including the lease contract, the lease case, or specific transactions.

3.2.2. Release 12.1.2

3.2.2.1. Multiple Level Collections Strategy Management

In prior releases, collections strategies could only be execaccount, bill to site) atsimultaneously at different levels for different customers and opexample, in one region - at Bill to level, in another region – at Afeature allows managers to setup and execute strategies at multilevels while allowing collections agents to change specific cdifferent business levels as required.

uted at one business (party, a time. Enterprises require the ability to execute strategies

erating units, for ccount level. This new

ple collection business ustomer strategies to

ble to plan and manage collections strategies that support nique business requirements where strategies must be executed at different ing units, groups of customers or specific customers. Collections agents can view

ifferent levels on their work queue and on the strategy tab. Delinquent managed at the business level most appropriate to their business model.

rategy management can

Release 12.1.3

. Staged Dunning

Collections managers are now atheir uoperatstrategies at dcustomers are

Additionally, background processes including collections and stnow be executed at different levels concurrently.

3.2.3.

3.2.3.1

In addition to the Aged Dunning method that is based on a customer’s oldest aged method. The Staged

automatically incremented etween letters being sent.

3.3. Oracle Assets

invoice, Collections organizations may now use Staged DunningDunning method ensures the dunning notices set to a customer based on the collection score and pre-defined number of days b

3.3.1. Release 12.1.3

3.3.1.1. Asset Impairment for Japan Tax Reform 2007

As defined by previous regulatory initiatives in Japan and the Japan Tax Reform of 2007, the impairment functionality in Oracle Assets has been extended to perform and account for asset impairments in compliance with Japanese accounting regulations. Impairment losses can now be derived and recorded for Japan-specific depreciation methods.

Oracle E-Business Suite Release 12.1.Release Content Document 7BOracle Assets 4

The following impairment feature functionality is now available for Japan depreciation

s within Cash Generating Units

pairment of assets exceeding depreciation limits

3.4.

methods.

• Japan specific impairment loss calculations

• Assignment and impairment of asset

• Impairment of fully reserve and non-depreciating assets

• Im

Oracle Cash Management

3.4.1. Release 12.1.1

3.4.1.1. International Bank Account Number (IBAN) Support

International Bank Account Number (IBAN) is an inbank accounts across national borders in a way

ternational standard for identifying that would minimize the risk of

Cash Management now validates IBAN at the time of dard Modulo-97 checks.

ne patch: 7552541:R12.IBY.A.

3.4.1.2. Bank Identifier Code (BIC) Support

propagating transaction errors.recording bank account details. This validation is based on stan

This feature has also been back-ported to 12.0.6 via the standalo

Bank Identifier Code (BIC) is a unique identification for bank branches. This code can es the length of BIC when

re has also been back-ported to 12.0.6 via the standalone patch: 41:R12.IBY.A.

ciliation

be 8 or 11 characters in length. Cash Management now validatrecording bank branch details.

This featu75525

3.4.1.3. Payment Group based Bank Statement Recon

Oracle Cash Management now utilizes the new Payment Grouoptional matching criterion for manual and automated reconcil

p Number attribute as an iation of bank statements.

12.0.6 via the standalone patch: 7552541:R12.IBY.A.

3.4.2. se 12.1.2

3.4.2.1. Option to Override Country-Specific Validation for Bank Accounts

This feature has also been back-ported to

Relea

Sometimes legacy bank account numbers do not conform to modern country-specific validation rules. Users can now disable the default country-specific bank validations to migrate legacy bank account information.

This feature has also been back-ported to following releases:

Release Patch Number 12.0.4 7582842:R12.CE.A

Oracle E-Business Suite Release 12.1.Release Content Document 8BOracle Cash Management 5

12.1.1 8871846:R12.CE.B

3.4.2.2. EDIFACT Bank Statement Format Update

The bank statement loader program supports EDIFACT statements. With this release, the

es. The opening and closing eric

ram is enhanced to

rting the Record 05. The current seeded loader is enhanced to handle the record type 05. This additional record is defined as part of the EDIFACT standard and contains the contextual information of Record 04.

This feature been back-ported to following releases:

Patch Number

following additional data processing features are addressed:

• Support for non-numeric characters in bank balancbalance amounts sent in the EDIFACT statements contain non-numcharacters. The bank statement loader and import progconvert the non-numeric characters into numeric values.

• Support loading and impo

Release 12.0.4 8874185:R12.CE.A 12.1.1 8942035:R12.CE.B

. Copy Bank Transaction Codes 3.4.2.3

Bank transaction codes are used by banks to identify the types of transactions on bank statements. The codes are set up for each bank account for reconciliation purposes. For

ounts, it can be a cumbersome process to manually ecific bank use the same

A new concurrent program has been provided to copy the bank transaction codes from account(s).

. Load Bank Statements for the Current Day

organizations having several bank accsetup these transaction codes since most bank accounts for a sptransaction codes.

one bank account to another bank

3.4.2.4

In previous releases, users could only import bank statements and perform bank balance nance for past dates. Users can now enter or import bank statements and perform

bank balance maintenance for the current date. mainte


Release Patch Number 12.0.6 8965556:R12.CE.A 12.1.1 9090829:R12.CE.B

3.4.1. Release 12.1.3

3.4.1.1. Manual Entry in Cash Position

The cash position functionality has been enhanced to allow cash managers the ability to manually enter cash flows into their cash positions allowing for greater flexibility in their decision making process.


Release Patch Number

Oracle E-Business Suite Release 12.1.Release Content Document 8BOracle Cash Management 6

12.0.6 9059098:R12.CE.A 12.1.1 9059098:R12.CE.B

Management 3.5. Oracle Credit

3.5.1. Release 12.1.3

3.5.1.1. Configurable Analyst Assignment Rules

In addition to the seeded assignment rules, Oracle Credit Management can now assign credit analyst to case folders based on user-defined assignment rules and parameters.

ater flexibility in addressing customer specific work load management .

3.6.

This offers greneeds

Oracle Financials for EMEA

3.6.1. Release 12.1.1

3.6.1.1. Business Intelligence Publisher Support for Select EMEA Reports

The following Oracle Financials for EMEA reports have been re-written utilizing the (BIP) tool. BIP based reports offer greater flexibility to

ging report layouts and formats.

over Report

ents

• Receivables Aggregate VAT Statement

• Account Analysis Detailed Reporting

3.6.1.2. Enhanced Statutory Report Extracts for Italy

Business Intelligence Publisherend users in chan

• Payables Turn

• Supplier Statem

• Customer Statements

• Regional Cash Desk Report

• Account Analysis Report

Article 37 of Italian Legislative Decree No. 223/2006 introduced a new fiscal requirement whereby all legal organizations must provide customer and supplier listings in electronic format to the Italian fiscal authorities on a yearly basis.

The Italian supplier and customer listing reports available in prior releases are now replaced with new Italian Customer and Supplier Listing data extracts.

Oracle E-Business Suite Release 12.1.Release Content Document 9BOracle Credit Management 7

3.7. Oracle Financials for India

3.7.1. Release 12.1.1

3.7.1.1. Fringe Benefit Tax Support

Fringe Benefit Tax (FBT) was introduced in India as part specific employee expenses not treated a

of Budget 2005-2006, to tax s individual income.

or India enables computation, payment, tracking, and statutory Oracle Financials freporting of Fringe Benefit Taxes on non-payroll expenses.

3.7.1.2. Inclusive Tax Support

Oracle Financials for India now supports the setup, calculation,of inclusive taxes for payables and receivable transactions.

accounting and reporting

3.7.1.3. Retroactive Pricing Support

In order to accurately reflect payable obligations, it is necessary to propagate retroactive price modifications on blanket agreements to downstream documents such as releases and

a taxes on transactions such eipts, accruals, credit memos, and price correction invoices. A new user interface s users to claim credit for increases in recoverable taxes.

standard purchasing orders.

The retroactive pricing process is modified to recalculate Indias recenable

3.7.1.4. Payables Invoices Support for India

Oracle Financials for India now supports tax calculation for uninvoices. A new window is avai

matched payables lable to manage India taxes on unmatched invoices.

3.7.2.1. Advanced Pricing Support for India

3.7.2. Release 12.1.2

Oracle Financials for India now allows users to calculate excise and VAT assessable t. The advanced price list is based on the item

category. Users can associate a price list with an item category to determine assessable er that category.

3.7.2.2. Tax Information on Purchase Order Workflow Notification for India

values based on the advanced price lis

values for all items classified und

Oracle Financials for India now enables reporting and display of India taxes on purchasing approval workflow notifications. India taxes are included in the following:

• Purchase order, requisitions, and releases workflow notifications

• Total amount reported on workflow notifications

• Approval limit in the workflow hierarchy

• Change order workflow

Oracle E-Business Suite Release 12.1.Release Content Document 11BOracle Financials for India 8

Additionally, users can modify the tax amount, precedence, vendor, and vendor site information at the time of approval.

Payments for India 3.7.2.3. Reassessing Service Tax on Receipt of Foreign

Oracle Financial for India enables users to comply with statutory requirements by ng users to recalculate the service tax on receipt of foreign currency payments on the applicable exchange rate on the receipt date.

Descriptive Flex Field (DFF) Support

allowibased

3.7.3. Release 12.1.3

3.7.3.1.

Users can now capture customer specific data using descFinancials for India (OFI) f

riptive flex fields within Oracle orms. The data captured is stored and available within the

play of Value Added Tax (VAT) Invoice Number in Receivables India

OFI specific tables.

3.7.3.2. DisTransaction Workbench for

The VAT Invoice number is now displayed within the referenceTransaction Workbench.

field of Receivables This simplifies the process of matching receipt of payments

against a VAT invoice.

General Ledger Journal Drill-Down Support 3.7.3.3.

Users can now drill down from General Ledger to transactions for the accounting entries

3.8.

generated by Oracle Financials for India.

Oracle General Ledger

3.8.1. Release 12.1.1

to Display Content Set 3.8.1.1. Enhanced Financial Statement Generator ReportingValues

Users can now publish a Financial Statement Generator (FSG) When the Page Expand option is selected, each value in the cas an individual tab in the Microsoft Excel workbook.

report with a content set. ontent set becomes visible

3.8.2. Release 12.1.2

3.8.2.1. Enhanced Financial Statement Generator Reporting to Support Drill-down for Non-Contiguous Account Ranges

General Ledger provides a streamlined drill path from the monetary amounts in financial statements to the underlying detail balances. After running a FSG report, users can drill from any summarized financial balance in the report directly to the detail account balances that comprise the summary amount, even if the summary amount represents multiple non-contiguous account ranges.

Oracle E-Business Suite Release 12.1.Release Content Document 12BOracle General Ledger 9

This process allows users to perform the drill down efficientlythe need to perform multiple searches by selecting one acc

in one step and eliminates ount range at a time. It also

improves usability by enabling the user to see all the information on a single page.

shing 3.8.2.2. Streamlined Excel-based Financial Statement Publi

Users can now publish FSG reports natively as Excel files. Usetemplates using Excel, and then run reports using BI Publish

rs can create presentation er’s Excel publishing

capabilities to generate an Excel file that opens directly in Excel. Users can then drill to derlying details, leveraging General Ledger’s Account Analysis and Drilldown ility.

. Synchronize Reversing Journals between Primary and Secondary Ledgers

the uncapab

3.8.3. Release 12.1.3

3.8.3.1

Oracle General Ledger now streamlines the propagation of journal reversals from the al reversal of primary nding journal entries in the

3.8.3.2. Limit Accounts in Budget Wizard

primary ledger to the associated secondary ledgers. The manuledger journal entries now automatically reverses the corresposecondary ledger.

In prior relOracle General Ledger Budget Wizard to lim

eases, users could only use specific account code combinations ranges in the it accounts for the budget entry process.

udget Wizard now allows users to use low and high values for one or more

3.9.

The Bsegments in the account range.

Oracle Internet Expenses

3.9.1. Release 12.1.2

3.9.1.1. Access Expense Attachments from Invoice

The Expense Report Export program has been enhanced to proAttachments to transfer attachments from an expense report to an invoice. This option

vide the option Transfer

enables the payables person to access the attachment from Invoice without having to use Internet Expenses responsibilities and efficiently execute audits.

3.9.1.2. Support Receipts Required for Mileage Category

United Kingdom HM Revenue & Customs department requires employees to submit invoices/tax receipts to employers for any mileage related claims so that the employers can recover VAT on fuel purchased by employees used for business purposes.

The Receipts Required feature has been enhanced to provide support for expense types associated with the Mileage expense category.

Oracle E-Business Suite Release 12.1.Release Content Document 13BOracle Internet Expenses 10

3.9.1.3. Archive and Purge of Expense Reports

This new program enables administrators to archive and purge expense reports related data that is no longer needed.

n Audit 3.9.1.4. Read-Only Access to Per Diem and Mileage Details i

The Audit Expense Report page has been enhanced to allow auditors to view Per Diem &

er Option to Not Load Payment Transactions

Mileage category expense details.

3.9.1.5. AMEX Load

The American Express Transaction Loader and Validation program has been enhanced to

ense Receipt Management Enhancements

optionally load payment transactions.

3.9.2. Release 12.1.3

3.9.2.1. Exp

Oracle Internet Expenses has been enhanced to provide usaccept, track and route imaged receipts to the ap

ers the ability to define rules to propriate auditor work queue.

ailed scanned receipts can now be associated with expense

ed rules can be setup to enforce receipt submission and reimbursement thresholds in addition to highlight missing receipts for expense lines.

Expense Detection

Faxed receipts and/or emreports as receipt images.

User defin

3.9.2.2. Duplicate

Duplicate Expense Detection Rules are now available to detect duplicate expense claims inistration costs by ensuring only reimbursement of

3.10. Or

aiding customers in decreasing admvalid expense claims.

acle Legal Entity Configurator

3.10.1. Release 12.1.3

3.10.1.1. Enhanced Legal Addresses

In prior releases, when defining the address for a new legal entity, users could only select from existing locations identified as legal addresses. Users can now select any existing location as an address for a legal entity.

This feature has also been back-ported to following releases:

Release Patch Number 12.0.6 6116752:R12.XLE.A 12.1.1 6116752:R12.XLE.B

Oracle E-Business Suite Release 12.1.Release Content Document 14BOracle Legal Entity Configurator 11

3.11. Oracle Loans

3.11.1. Release 12.1.2

3.11.1.1. Process Application Fees without Loan Approval

Loan application fee is a fee charged to process an application fmortgage from a lender or mortgage broker. L

or a loan, such as a home oan application fees are charged to cover

non-refundable regardless ront.

application had to be ng for loan fees before the

loan gets approved or rejected.

on an ad hoc basis or automatically based on a loan activation, loan

.11.1.2. Ad-hoc Billing and Receipt Application

some of the costs involved in processing the application including credit checks, propertyappraisals and basic administrative costs. Such fees are oftenof the outcome of the application review and are charged upf

Previously, in order for any loan fee to be processed, the loanapproved. This new feature allows processing and accounti

The fees now can be charged manuallycertain event in the loan application lifecycle (loan origination, submission for approval).

3

Borrowers receive their loan repayment bills when an automated process determthe next installment is due. This n

ines that ew feature allows users to manually select the next

. Users now also have an option le of installments and bill customers manually on an ad

has been streamlined by the loan transaction

ly from UI) has been

installment and create a customer bill on an ad hoc basisto create a loan without a scheduhoc basis.

In addition, the process of applying customer payments to loansproviding users an option to perform receipt application withincontext, without the need to switch to Receivables. A new system profile option (LNS: Allow to Bill and Appintroduced to control user’s access to this feature.

3.11.1.3. Loan Forgiveness

The Loan Forgiveness feature allows users to create and manage loan forgiveness option loan programs. By populating a Receivables Activity in the new system option Loan

forgiveness is enabled or disabled for the

rcentage of the loan duration. Loan

are visible for each individual loan via the Servicing Center: Overview: Summary window. During billing, the forgiven amount is displayed and accounted for as an adjustment on the customer invoice.

3.11.2. Release 12.1.3

3.11.2.1. Multiple Disbursements during Loan Servicing

Forgiveness Adjustment: Activity Name, loan loan products within the organization. Loan forgiveness is applied at the individual loan level as a peinstallment amount and can be modified throughout the loan’s forgiveness details

In prior releases, direct loans could only be adjusted using multiple disbursements with disbursement amount, percentage and a specific target date freeze before the approval, activation or funding of the loan. Now, loan managers can perform adjustments to the loan amount in active and multiple disbursements of the loan after the loan is activated, funded or in the servicing stage.

Oracle E-Business Suite Release 12.1.Release Content Document 15BOracle Loans 12

Additionally, for Extended Repayment Schedule (ERS) loanadd and convert additional receivables transactions to existinstage. Managers can also modi

s, loan managers can now g loans in the servicing

fy the outstanding amount of receivables or adjust the receivables amount based on the payment terms.

les 3.12. Oracle Payab

3.12.1. Release 12.1.1

3.12.1.1. Enhanced Withholding Tax Calculation for Brazil

Brazilian tax regulations require withholding taxes to be deducevent points such as recordin

ted at multiple business g and payment of invoices.

x was deducted either during validation or payment of lication of withholding taxes

yment.

In prior releases, withholding tainvoices. Oracle Payables has been enhanced to allow appboth during invoice validation and pa

3.12.1.2. Discount Calculation Enhancements

Suppliers offer discounts for early payment. Early payment discounts can be fixed .

ms only. Oracle Payables . When a percentage as well as

an be specified for application.

Management for Engineering and Construction

monetary amounts or calculated on a percentage basis

In prior releases, discounts could be defined in percentage ternow allows discounts to be specified in monetary amountsan amount is available, the higher or lower of the two c

3.12.1.3. Subcontractor

Oracle Payables has been enhanced to automatically apply holdwhen the Pay When Paid or the PO Deliverable Control option

s on supplier invoices is enabled on purchase

orders. During invoice validation, such holds are automatically released provided been recorded within Oracle Project Accounting or Oracle authorizations have

Purchasing.

3.12.1.4. Supplier Dispute Processing

Supplier invoices may be short paid to expedite dispute settlements. The Payables Invoice Workbench has been enhanced to capture the invoice amount originally claimed by the supplier and the reason for short payment.

3.12.1.5. Third Party Payments

Suppliers can specify a related trading partner to be paid on their behalf. The payments made on behalf of suppliers to other trading partners are termed as third party payments.

Oracle Payables has been enhanced to record third party relationships and to process third party payments. Withholding and 1099 processing continue to occur for invoicing suppliers.

Oracle E-Business Suite Release 12.1.Release Content Document 16BOracle Payables 13

3.12.1.6. Business Intelligence Publisher Support for Selected Payables Reports

The following Oracle Payables reports have been re-written utiIntelligence Publisher (B

lizing the Business IP) tool. BIP based reports offer greater flexibility to end users

d formats:

Invoice Report

Date Report

Payment Audit by Voucher Number

in changing report layouts an

• Withholding Tax by

• Bills Payable Maturity

• Discounts Available Report

•

• Prepayments Status Report

3.12.2. Release 12.1.2

3.12.2.1. Replace Supplier Bank Accounts on Invoices

In today’s business environment, it is a common practice to change bank accounts. If suppliers change their bank accounts, Oracle Payables can now automatically update all

ank account information. When users and provide a new active bank account, Oracle it-to bank account information on unpaid and

g and prevents the need to

patches: 6867725:R12.AP.B and 6615694:R12.IBY.B.

e

unpaid and partially paid invoices with the new bend date an existing supplier bank account Payables will automatically update the rempartially paid invoices. This streamlines transaction processinupdate each invoice manually.

This feature has been back-ported to 12.1.1 via the standalone

3.12.2.2. Change Taxes from Inclusive to Exclusive Onlin

The tax regulations in many countries require that certain types of taxes on invoices be applied as inclusive or exclusive to the price of the good or service. This is common in ountries that report VAT, such as in the United Kingdom, where the VAT tax can be eated as inclusive or exclusive depending on the type or price of the good or service.

Oracle Payables provides the flexibility to override the inclusive or exclusive nature of oice, users can change shown on the physical ting.

3.13. Oracle Payments

ctr

taxes that default from the eBTax setup. While entering an invtaxes from inclusive to exclusive or vice versa to match the taxinvoice. This ensures more accurate invoice entry and tax repor

3.13.1. Overview

Oracle Payments provides a highly configurable and robust engine to disburse and receive payment, and integrates with multiple products that require support for payment processing. Oracle Payments processes invoice payments from Oracle Payables, bank account transfers from Oracle Cash Management and settlements against credit cards and bank accounts from Oracle Receivables. Oracle Payments provides the infrastructure

Oracle E-Business Suite Release 12.1.Release Content Document 17BOracle Payments 14

required to connect these applications and others with third party payment systems and ial institutions.

3.13.2. Release 12.1.1

financ

3.13.2.1. Single Euro Payments Area (SEPA) Support

The Single Euro Payments Area (SEPA) guidelines require that credit transfers be executed using standard SEPA Credit Transfer initiation messages. These are XML

forming to SEPA credit

yments has been enhanced to support SEPA Credit Transfers. Messages are initiated and formatted utilizing the existing disbursement framework.

alone patch:

messages generated as per the ISO 20022 framework and contransfer schemes negotiated with banks.

Oracle Pa

This feature has also been back-ported to 12.0.4 via the stand7552541.R12:IBY.A.

3.13.2.2. Paymentech Integration Certification

Paymentech is a leading Back End Processor (BEP) in providing financial settlement ith Paymentech for seamless transmission of

2.0.4 via the standalone patch:

.3. Positive Pay File with Additional Parameters

services. Oracle Payments is certified wcredit card, debit card and direct debit transactions.

This feature has also been back-ported to 16975269:R12.IBY.A.

3.13.2

The Positive Pay File report details payments made to specific trading partners. A new al Parameters report has been introduced to include

dalone patch:

3.1

Positive Pay File with Additionprevious payments and, optionally, voided check information.

This feature has also been back-ported to 12.0.0 via the stan6939650:R12.IBY.A.

3.3. Release 12.1.2

3.13.3.1. PA-DSS for Credit Card Processing

To ensure all payment type applications that interact with payment cards meet consistent tandards Council

ly PA-DSS (Payment certified payment application software.

Certification applies to software applications that store, process, or transmit payment cardholder data as part of an authorization or settlement process. This certification reassures users that Oracle Payments is properly handling and securing sensitive payment card information. Certification includes proper adherence with industry accepted data storage guidelines, encryption algorithms, secured coding practices, and secured transmission standards.

Oracle Payments customers benefit from the ongoing enhancements made to conform to PA-DSS requirements. These PA-DSS enhancements are also available as standalone patches to customers on Release 12.0 and 12.1.1.

security standards, the Payment Card Industry (PCI) Security Sencourages and in some cases mandates that merchants use onApplication Data Security Standards)

Oracle E-Business Suite Release 12.1.Release Content Document 17BOracle Payments 15

3.14. Oracle Profitability Manager

3.1

eater insight into the nable information for

ability. As part of Oracle’s Corporate anager is a comprehensive

e calculation, analysis and reporting of profitability.

ial Services suite)

ness Suite)

ease 12.0, major emphasis was placed on maintaining all the industry leading es and functions available in earlier versions of the Financial Services Applications

appeal of profitability analytics, cial services enterprises.

sabled/Inactive

4.1. Overview

Oracle Profitability Manager provides enterprises with a grprofitability of current operations and empowers them with actiomaking decisions and driving improved profitPerformance Management (CPM) suite, Oracle Profitability Msolution for th

Oracle Profitability Manager was first released with Release 12. It is the integration of two existing applications:

• Oracle Performance Analyzer (part of the Oracle Financ

• Oracle Activity-Based Management (part of the E-Busi

In Relfeatur(OFSA), while simultaneously leveraging the power of the Oracle E-Business Suite. The Profitability Manager application broadens the industryand repeats the success the legacy products had beyond finan

3.14.2. Release 12.1.1

3.14.2.1. Identification of Business Rules that Reference DiDimension Members

Users manage metadata as a standard business process related tomaintenance of business rules with the Profitability Manager apusers make changes to metadata like hierarchies and dimension mcases "disable" dimension members to indicate that they are used as part of the profitability calculations. A

the construction and plication. Over time,

embers, and in some no longer active or no longer

good example of this would be when a company reorganizes, and some departments are transferred, combined or eliminated. In this example, data for those "old" departments would not be used in future models.

lp the user understand how these metadata changes affect their profitability models, feature is introduced which indicates where disabled dimension members are used

archies. Users are provided a concurrent program that will and write out the results to tables that can be used for

routine has also been .

3.15. Oracle Receivables

To hea newin mapping rules, or in hierscan a set of business rules,reporting with the tool of the user's choice. In addition, a purge provided that allows the user to clean up data from previous runs

3.15.1. Release 12.1.1

3.15.1.1. Cash Application Work Queue

Receivables departments need to efficiently allocate and monitor the workload of receipt application personnel. Unapplied customer receipts can now be automatically assigned to specific cash application specialists for further processing. This assignment is done

Oracle E-Business Suite Release 12.1.Release Content Document 18BOracle Profitability Manager 16

based on user defined rules by a new concurrent program: Assign Cash Application Work

alists can efficiently load, review unapplied receipts and take further actions on unapplied

receipts. The Cash Workload Review Report is now available to review and monitor the

Line Level Cash Application

Items.

Using the new Cash Application Work Queue workbench, specimanage their work

current workload of assignees.

3.15.1.2. Enhanced

Business operating in certain industries need to track balances anpayments at the invoice line level.

d apply customer

r all transactions originating from x matching routine has been n line selection logic.

bles Processing

Oracle Receivables now maintains line level balances fosources enabled for line level operations. The Auto Lockboenhanced with an open call-out to invoke custom transactio

3.15.1.3. Enhanced Performance for High Volume Receiva

Companies operating in industries such as telecommunications, retail, insurance and utilities process large volume of invoices and receipts on a daily basis. Oracle

ntly enhanced the performance and scalability of the following l processing logic and fine tuning database

• AutoInvoice Master Program

3.15.1.4. Golden Tax Adaptor Enhancements for Mainland China

Receivables has significakey batch programs by implementing paralleindexes:

• Automatic Clearing for Receipts

• Automatic Remittances Master Program

• Lockbox Execution Program

All businesses operating in mainland China are required to use a government certified tax application for VAT calculation, VAT invoice generation, and statutory tax reporting.

r provides a seamless ation between Oracle Receivables and the Golden Tax system.

Tax Adaptor now supports three additional VAT invoice types: special VAT

Credit memo processing through Golden Tax Adaptor has been enhanced with the following new features:

• Processing of on-account credit memos and credit memos referring to multiple invoices

• China Tax Office notification number support for credit memos on Special VAT Invoices

• Validation rules to prevent export of credit memos with duplicate or incorrectly formatted notification numbers

This system is referred to as Golden Tax. Golden Tax Adaptointegr

Goldeninvoices, common VAT invoices, and special VAT invoices for waste and outdated materials.

Oracle E-Business Suite Release 12.1.Release Content Document 19BOracle Receivables 17

3.15.1.5. Business Intelligence Publisher Support for Selected Receivables Reports

The following Oracle Receivable reports have been re-written uIntelligence Publisher (B

tilizing the Business IP) tool. BIP based reports offer greater flexibility to end users

youts and formats.

on Report

Invoice Exception Report

ation on Unidentified Receipts

in changing report la

• AR Reconciliati

• Customer Open Balance Letter

• Incomplete Invoices Report

•

• Receipt Analysis - Days Late

3.15.2. Release 12.1.2

3.15.2.1. Default Customer Bank Account Inform

Auto Lockbox now derives customer bank account information based on the Magnetic Ink Character Recognition (MICR) number supplied in the lockbox data file. This

anually associated with a uto Lockbox

e patch:

Accounts Receivables

information is defaulted on unidentified receipts and can be mcustomer record for matching receipts in subsequent runs of A

This feature has also been back-ported to 12.1.1 via standalon8422361:R12.AR.B

3.15.2.2. Enhanced Aging Report to Support Multi-Fund

Public sector companies and federal agencmultiple operating funds on an invoice. Oper

ies often need to record receivables against ating funds are represented as balancing

segments. In prior releases, Oracle Receivables aging reports could be used to monitor nces only when an invoice impacted a single balancing segment.

Receivables introduces a new Aging 7 Bucket by Account -- Multi-Fund Accounts Receivables Report. This report lists receivables balances regardless of the

3.16.

fund level bala Oracle

number of funds associated with any invoice.

All other Oracle Receivables aging reports remain unchanged.

Oracle Subledger Accounting

3.16.1. Release 12.1.1

3.16.1.1. Historical Data Initialization for New Reporting Currencies and Secondary Ledgers

When setting up new secondary ledgers or reporting currencies with an existing primary ledger for new local or corporate reporting requirements, all historical transaction accounting amounts and balances have to be initialized in these new ledgers/currencies to ensure proper reconciliation with their primary ledger counterparts. Oracle Subledger Accounting now provides a new concurrent program: SLA Secondary/ALC Ledger

Oracle E-Business Suite Release 12.1.Release Content Document 20BOracle Subledger Accounting 18

Historic Update for this particular need. This program rettransaction accounting data from the existing primary ledgersecondary or reporting currency ledgers. Once this prog

roactively posts historical to the newly created

ram is executed, reports and ies will correctly display secondary ledger or reporting currency amounts.

Subledger Accounting

inquir

3.16.2. Release 12.1.2

3.16.2.1. Accounting Rules Detail Report and EnhancedOnline Inquiry

Oracle Subledger Accounting introduces a new Subledger AccoListing Report to provide detailed information abo

unting Rules Detail ut accounting rules defined for a

itted from the individual subledger applications or from Oracle General Ledger. In addition, the report can be submitted for

istered within Oracle Financial Accounting Hub.

Users can now use the new report to easily review the following setup details:

Definition

e Type

• Journal Header Description

ed with two new sections used for generating an

accounting entry.

ubledger

subledger accounting method. The report can be subm

custom applications reg

• Subledger Accounting Method

• Journal Line

• Journal Lin

• Account Derivation Rule

• Journal Line Description

The online Subledger Journal Entry page has also been enhancto display the journal line definition and the journal line type

3.16.2.2. Accounting Data On-Demand Upgrade by S

During the Release 12 upgrade process, customers can choose the time span for rting historical accounting data to the new Subledger Accounting tables. There is

also a separate program that allows customers to extend the data conversion to older upgrade. This program runs for all subledgers at the same

racle Subledger Accounting has enhanced this process by introducing a new concurrent program Upgrade Historical Subledger Transaction Accounting that allows the historical accounting data conversion be done independently for each subledger.

3.16.3. Release 12.1.3

3.16.3.1. New Control Accounts Qualifier

conve

accounting periods after the time.

In this release, O

“Restrict Manual Journals” has been added as a new qualifier on the natural account segment to provide users the ability to specify the control accounts that do not require third party detail for posting.

Oracle E-Business Suite Release 12.1.Release Content Document 20BOracle Subledger Accounting 19

ry 3.17. Oracle Treasu

3.17.1. Release 12.1.2

3.17.1.1. International Bank Account Number (IBAN) SBank Accounts

upport for Counterparty

The International Bank Account Number, or IBAN, was designed to standardize and been added to the e input of the

The seeded confirmation templates and X12 Electronic Funds Transfer script now use the for both the company and counterparty, if provided. The Daily Payments/Receipts

Report displays the IBAN, if it is specified, rather than the account number for the

s of all Deal Types

simplify the transfer of international payments. A new field has Counterparty Settlements Account Details window to support thInternational Bank Account Number for the counterparty.

IBAN

counterparty.

3.17.2. Release 12.1.3

3.17.2.1. Reconcile Treasury Transaction

Oracle Treasury now allows the use of Retail Term Money Market deal transactions w Oracle Cash M Statement reconciliation. With this enhancement, users can view and use all treasury deal type transactions when reconciling bank statements within Oracle Cash Management providing a single point for reconciliation.

also been back-ported to the following releases:


ithin the anagement Bank

This update has

12.0.6 9491322:R12.XTR.A 12.1.1 9393372:R12.CE.B

3.18. Oracle U.S. Federal Financials

3.18.1. Release 12.1.2

3.18.1.1. Enhanced Delinquency Processing

Federal delinquency processing features have been enhanced to provide additional configuration options including the ability to configure:

• Finance charges to be assessed on other finance charges

• Finance charges once for an installment invoice or on each installment for an installment invoice

• The source of the distribution for finance charges (for example, from the original invoice distribution or from the transaction type).

Oracle E-Business Suite Release 12.1.Release Content Document 21BOracle Treasury 20

3.18.2. Release 12.1.3

3.18.2.1. Updates to Year-End Close Processing

The Federal Year End Close process has been modified to aaccom

dd a Closing Method to modate configuration of Pre-Closing as well as Closing accounting entries.

Closing Method and Closing Period have been added as parameters to the Year End

egistration (CCR)

closing process.

3.18.2.2. Extract File Changes for Central Contractor R

CCR enhancements include:

• Placing specific named holds (instead of suppliescheduled payments when the

r site holds) on invoices and supplier’s registration status becomes inactive, and

ecomes active

d information on

• Providing validation on the Payables Assignment page to prevent the association of a CCR vendor to an existing supplier when their TINS do not match

aid invoices with the latest bank account information from CCR when the bank information has changed for a CCR registration.

3.19. Ta

automatically releasing the hold when the registration b

• Masking the CCR account user identifier and passworconcurrent request parameters and log file output

• Updating unp

x, Legal and Regulatory Updates

3.19.1. Overview

troduced to address tax,

llowing updates have also been back-ported to previous releases via nformation on patch numbers.

3.19.2. Release 12.1.1

l SPED – Support for Fiscal Book Generation and Electronic Invoice Integration

The following section provides information about the updates inregulatory and legislative changes.

Note: Most of the fostandalone patches. Please refer to the sections below for i

3.19.2.1. Brazil: Fisca

Support for Fiscal Book Generation

The Brazilian Fiscal SPED requires organizations to submit a set of legal reports in electronic format to tax authorities. Specific additional information is required to be provided in these reports. Oracle Financials for Latin America provides new and enhanced functionality to capture the additional required information.

The following new windows have been introduced to support SPED:

• Electronic Invoice Attributes

Oracle E-Business Suite Release 12.1.Release Content Document 23BTax, Legal and Regulatory Updates 21

• Electronic Invoice Status History

xisting windows have been enhanced:

x Codes and Rates

plier Sites

• Customer Sites

urces

Management Deliveries

agement Carriers

•

y be billed to a

merica provides support for electronic al. The tax authority approval status is used

to control downstream business process such as invoice printing, collection, etc. for the eceivab n orde s with an invalid document

status, only receivable invoices with a status of Finalized or Contingency are processed. Invoices with a status of Sent, Error, Cancelled, Rejected and Obsolete are placed on hold until the electronic invoice status is updated to Finalized or Contingency.

This update has also been back-ported to the following release:

elease Patch Number My Oracle Support Knowledge

The following e

• Ta

• Sup

• Transaction So

• Order

• Order Man

Transaction Types

• Inventory Master Items

• Item Templates

Support for Electronic Invoice Integration Per Brazilian tax law, account receivable invoices can onlcustomer after tax authority approval. In this release, Oracle Financials for Latin Ainvoice integration for tax authority approv

r les invoice. I r to prevent billing customer

RDocument

12.0 7000001:R12.JL.A 753705.1 – Electronic Invoice Standards

lectronic Invoice Integration Support 876892.1 – E

3.19.2.2. Japan: Asset Depreciation Enhancements for Japan Tax Reform Act of 2007

In order to stimulate and promote economic growth, The Ministry of Finance for Japan has announced new tax reforms. The reforms introduced new rules for calculating depreciation on fixed assets effective April 1, 2007.

Oracle Assets provides the following new features to support the new tax reforms:


• New depreciation methods and rates for depreciable assets acquired on or after April 1, 2007

ded to the Straight Line Method

calculation of extended depreciation for eciable asset acquired on or before March 31st, 2007 and

depreciated up to earlier 95% limit)

pliance

adding Salvage value and Final Depreciable mit parameters

This update has also been back-ported to the following releases:

Patch Number

• New rates are ad

• 250% Declining Balance Method

• Extension of Depreciation feature for eligible assets (depr

• Enhanced reporting for com

• Enhanced Mass Changes feature byli

Release 11.5.10 7427746 12.0 8706840:FA.A

3.19.2.3. United Kingdom: Reverse Charge VAT

On June 1, 2007, the new Reverse Charge VAT rule became efKingdom. The Rev

fective in the United erse Charge VAT involves inverting the tax liable party from the

ns for domestic

Oracle Financials now supports this new VAT regulation by identifying reverse charge transactions and ensuring that appropriate tax rules are applied. A Reversed Charge

Sales report is now available to list effected invoices. A standard message is printed on

ials Release Update Pack t Knowledge Document

3.1

3.19.3.1. Argentina: Turnover Tax Withholding/Perception Regimes

‘Seller of Goods’ to the ‘Buyer of Goods’ under certain conditiotransactions within the EU countries.

VAT

all reverse charge sales invoices.

This update has also been back-ported to 12.0 via Oracle Financ5. For additional information, please refer to My Oracle Suppor565898.1.

9.3. Release 12.1.2

The Tax Authority of Buenos Aires province has determined through regulations DN 70/07 and DN 74/07, that tax rates for its Turnover Withholding and Turnover Perception regimes would be defined per individual contributors (i.e. taxpayer id), therefore modifying existing withholding and perception tax rate determination, which was a general rate applicable for all taxpayers.

Each Perception agent (i.e. seller) and Withholding agent (i.e. buyer) will be required to download from the tax authority’s website a monthly flat file with applicable tax rate information for each contributor (taxpayer id).


In this release, Oracle Financials for Latin America provides nfunctionality to enable its customers to upload the governmeupdate the corresponding tax assignments per taxpayer id (i.e.suppliers in Oracle Payables and Perception rates for custo

ew and enhanced nt’s monthly data file and

Withholding rates for mers in Oracle Receivables)

and ultimately calculate proper withholding and perception taxes on Payments and , thus complying with the current legal regulations.

Data File

to Validate Data prior to Data Upload

Program to Update Monthly Turnover Perception Tax Assignments per Taxpayer

er Withholding Assignments per Taxpayer id

m to Update Withholding Rates for Unpaid Invoices (Payables)

ded Data for Verification Purposes

The following windows have been enhanced:

• Supplier Withholding Applicability

een introduced:

Verification Report

d on parameters entered in the above concurrent program:

• Argentine Turnover Temporary Data Upload Verification Report

• Argentine Turnover Data Upload Validation Report

• Argentine Turnover Final Data Upload Verification Report

:

Patch Number My Oracle Support Knowledge Document

Receivables transactions

The following functionality is provided:

• Infrastructure and Guidelines to Setup and Upload Monthly

• Program

• id (Receivables)

• Program to Update Monthly Turnov(Payables)

• Progra

• Report to List Uploa

• Withholding Taxes

The following concurrent program has b

• Argentine Turnover Tax Data Upload

The following reports can be generated base

This update has also been back-ported to the following releases Release

11.5.10 7368540 733928.1 12.0 7685123:R12.JL.A 778917.1 12.1.1/12.1.2 8427989:R12.JL.B 878707.1

3.19.3.2. Brazil: Federal SPED Regulation - Accounting SPED

The Brazilian Accounting SPED, also known as ‘Escrituração Contabil Digital – ECD’, requires companies to submit their accounting data to the Federal Tax Authority on a monthly or yearly basis in a flat file format.


In this release, Oracle Financials for Latin America profunction

vides new and enhanced ality to capture the required information, extract and format electronic

monthly generation of the following bookkeeping types:

Bookkeeping Type G is applicable when the company stores detailed accounting in ral Ledger. It is the preferred bookkeeping type by Federal Tax

• Bookkeeping Type R

arizes accounting data in the sub-ledgers.

• eping Type A

Bookkeeping Types R or unting information from AP and

ype B is specific for Financial Institutions such as Banks. It requires ters to be reported. This book may also have an auxiliary

g Type A associated to it.

ccounting SPED are:

Participants

lationships

ping Types

enhanced to capture new data elements:

Legal Entities

• Contac

The following programs have been introduced:

• Brazilian Accounting SPED Data Extract Program

• Brazilian Accounting SPED Text File Generation Program

• Brazilian Accounting SPED Financial Statements Data Extraction

This update has also been back-ported to the following releases: Release Patch Number My Oracle Support

accounting books.

Oracle supports

• Bookkeeping Type G

Oracle GeneAuthority.

Bookkeeping Type R is applicable when a company summOracle General Ledger and keeps the accounting details in

Bookke

Bookkeeping Type A contains the detailed accounting for B. Users can drill down and retrieve detailed accoAR sub-ledgers.

• Bookkeeping Type B

Bookkeeping Tadditional regisbookkeepin

New User Interface screens introduced to support A

•

• Participant Re

• Bookkee

The following pages have been

•

• Establishments

• Legal and Tax Registrations

ts Information


Knowledge Document 11.5.10 8319193 786498.1 12.0 24610:R1 878922.1 88 2.JL.A 12.1.1/12.1.2 8692514:R12.JL.B 878922.1

3.19.3.3. China: Golden Tax Adapter Enhancements

In this release the EBS Golden Tax Adaptor functionality has been expanded to support er

or use in the Golden Tax (VAT) invoices, and the s.

es

customer into a single VAT the System Options.

turing bank and customer information in simplified Chinese

print the customer and inese on issued VAT invoices.

den Tax Adaptor into the Golden Tax system. Users can import credit memo data with merged discount

the merging of multiple Golden Tax (VAT) Invoices, capturing bank and custominformation in simplified Chinese fability to support sales discounts on Golden Tax (VAT) invoice

1. Merge multiple Golden Tax (VAT) invoic

Users can consolidate multiple invoices for the sameinvoice within limits as defined in

2. Cap

Users can use an Alternate Name to enter, capture andbank information in Ch

3. Sales discount

Users can export sales discount lines from the EBS Gol

amounts back into Golden Tax Adaptor.

3.19.3.4. Italy: Annual VAT Extract

The Annual VAT declaration is a legal requirement in Italy. All Italian legal entities T declaration according to the specifications of the Italian

h contains selected VAT details to assist their functional currency as

r their statutory reporting

must complete the Annual VAfiscal authority.

This release provides a standard extract whicItalian customers to submit their Annual VAT declaration in well as non-Italian customers to reconcile their VAT registers foneeds.

3.19.3.5. Italy: Annual Withholding Extract

The Annual Withholding declaration is a legal requirement in Italy. All legal entities must complete the fiscal template according to the specifications of the Italian fiscal authority.

This release provides a report that may be printed annually for each legal entity. The report lists the withholding tax and the tax identification information related to partially and fully paid payables transactions. This report is consistent with the information listed on Italian Withholding Tax Letters.

3.19.3.6. Japan: Enhanced Support for Tax Reform 2007/2008

Japan’s Ministry of Finance announced new tax reforms for the calculation and reporting of fixed asset depreciation.


Oracle Assets provides the following new features to support the Japanese tax reform

m

system to be assigned the new depreciation methods. However, n existing assets to the new

mandated methods.

egacy assets:

dition of assets already in Extended ation for these assets.

asset information.

ADI) has been modified to enable the addition of existing assets in Extended Depreciation.

The Extended Adjustments program has been modified to support Depreciation.

x Reform

on program has been enhanced to use 2007 Japan Tax

Japan Tax Reform.

ently depreciating under Extended Depreciation.

ble Assets Tax Report for Japan

Previously, users of the Japan Depreciable Assets Tax Report could only register ingle company. The report has now s.

The Japan Depreciable Assets Tax Report contains the following modifications:

e companies linked to specified

• Additional reference information is enterable in the report.

• The report layout format conforms to the legal standard.

This update has also been back-ported to 12.1.1 via the standalone patch: 8706842:R12.FA.B.

3.19.3.7. Spain: VAT Legislation: Modelo 340 Informative Declaration

legislation:

1. Enhanced Legacy Data Migration for Japan Tax Refor

Prior 2007 Japan Tax Reform product enhancements allowed new assets added into thecustomers also need the ability to easily assig

The following functionality enables users to migrate l

• The Asset Workbench now allows adDepreciation and displays additional asset inform

• Mass Additions now permits the addition of existing assets in Extended Depreciation and also displays additional

• The Asset Integrator (Oracle Web

•migrated depreciating assets in Extended

2. Enhanced What-If Depreciation Analysis for Japan Ta

The What-If DepreciatiReform methods:

• New JP 250 DB methods introduced with the

• The new JP STL EXTD method for assets curr

3. Deprecia

and provide descriptive information for a sbeen enhanced to handle multiple companie

• Users can specify information for multiplasset book(s).

The new Modelo 340 Informative Declaration includes Issued Invoices, Received Invoices, Investments and Certain Intra EU transactions. This new 2009 declaration


accompanies the VAT Settlement ("Liquidación del IVA") and does not replace an ed monthly or annually.

rdance to the new legislation. ate has also be d to the following releases:

Patch Number

existing declaration ("Modelo"). This settlement can be perform

In this release, a new file is available in accoThis upd en back-porte

Release 11.5.10 8535502 12.0 8635531:R12.JE.A 12.1.1/12.1.2 8635531:R12.JE.B

3.19.3.8. Spain: VAT Legislation: Modelo 347 Domestic TrReport Changes

ansactions Turnover

New guidelines include changes to the types of companies that are required to submit n December 30th, 2008, and are applicable

uary 1st, 2009: Order EHA/3787/2008, of 29 of December, (BOE 30-diciembre-A series of upd ional fields have been applied to the layout of

elo 347 report in a legislative requirements. has also be o the following releases:


Modelo 347. These guidelines were issued oas of Jan

2008). ates and additMod ccordance to the This update en back-ported t

11.5.10 7564728 12.0 8635531:R12.JE.A 12.1.1/12.1.2 8635531:R12.JE.B

3.19.3.9. Spain: VAT Legislation: Modelo 415 Canary Island Turnover Report Changes

Companies operating i nds and subject to the Canary Islands Tax Regime to submit an IGIC Modelo 415 file. A series of updates and additional fields

have been applied to the layout of Modelo 415 in accordance of the new legislative requirements.

to the following releases:

n the Canary Islaare required

This update has also been back-ported

Release Patch Number 11.5.10 8294328 12.0 8635531:R12.JE.A 12.1.1/12.1.2 8635531:R12.JE.B

3.19.3.10. Spain: Changes to Taxpayer ID Validation

In 2008, Spain issued new legal guidelines to allow Taxpayer ID’s to begin with alphabet characters of “Y” and “Z” and specific logic to derive the correct format. Prior to this change, Spanish Taxpayer ID’s were legally allowed to only begin with alphabet characters up to “X”. This release supports the revised Spanish Taxpayer ID validation.

For additional information, please refer to My Oracle Support Knowledge Document: 759473.1, 760262.


3.19.3.11. United Kingdom: Support for Revaluations anS

d Impairments per tatement of Recommended Practice for United Kingdom Local Authority

Accounting

The Joint Committee for CIPFA/LASAAC published “A Statement of Recommended

007.

n Oracle Assets now addresses the fixed asset

ting for – Net Book Value

ciation Neutralizing Entries

ccounting Entries

• Revaluations Directly Related to Prior Impairments

tries.

lone patch:

U.S. Federal: New FACTS II Edit Checks and File Layout Changes

Accounting Practice (SORP) 2006”. The SORP recommends how fixed assets owned byUK Local Authorities are to be revalued starting from April 1, 2

Revaluation and impairment functionality irevaluation requirements as per SORP.

• Revaluation Reserve Accoun

• Generating Depre

• Revaluation of Donated and Discounted Assets

• Impairment Classification Types

• Reason and Purpose Descriptions

• Generating Impairment Loss Neutralizing A

• Generating Asset Decommission and Disposal En

This update has also been back-ported to 12.1.1 via the standa8706842:R12.FA.B.

3.19.3.12.

Closing Validat 13 and Reclassific it 14 rules have been added as configuration options for FACTS II processing in accordance with Treasury FMS

ance. Addi ACTS II Ed Check Detail Report has been modified to include the status and supporting detail for these edits.

eleases:

My Oracle Support Knowledge Document

ion Edit ation Ed

guid tionally, the F it

This update has also been back-ported to the following r Release Patch Number

11.5.10 9351322 875303.1 12.0 9351569.FV.A 875303.1 12.1.1/12.1.2 9351569.FV.B

3.19.3.13. U.S. Federal: Enhanced Central Contractor Registration (CCR) Processing

CCR processing has been enhanced to process the BPN extract v4.07 files. These extracts contain unlimited Business Types, NAICS, SIC, PSC and FSC Codes, as well as NAICS exception and SBA Certification Data. The CCR Vendors pages have been updated to display this information.


3.19.3.14. Global: Support for Asset Impairment in Accordance with International Accounting Standard 36

IAS 36 addresses financial accounting and reporting for improvisions provide that assets should not be carried at moreamounts. The Standard requires entities to carry out impairmenttangible and intangible assets, other than assets in certain specinventories, construction contract assets, financial assets andas held for sale). IAS 36 requires companies to measure an as(the higher o

pairment of assets. The than their recoverable

tests for all their ified categories (e.g.

non-current assets classified set's recoverable amount

f the asset's or cash generating unit's fair value, less costs to sell, and its cle Assets now calculates and

with IAS 36 guidelines.

value in use) and compare it to the book value. Oragenerates asset impairments and the appropriate General Ledger journals in accordance

This update has also been back-ported to 12.1.1 via the standalone patch: 8706842:R12.FA.B.

3.19.3.15. Global: Year End Closing Process

Selective country legislators stipulate that the year-end closingbeginning opening journals are to be cre

journals and year-ated using the net balance of each account.

lose Process: Create Balance Sheet Closing Journals program and Close Process: Create Income Statement Closing Journals program in General Ledger have been

Net Closing Balance Journal enerate the appropriate year-

gime (Monotributo)

The C

enhanced to support this legal requirement. Using the new option in the Accounting Setup Manager, users can now gend closing journals and year-beginning opening journals.

3.19.4. Release 12.1.3

3.19.4.1. Argentina: Support for Argentina Simplified Re

The Argentine Fiscal AuthorityRegime for Income Tax and VAT application

(Resolution 2616), introduced a new Withholding to Simplified Regime Contributors (a.k.a.

y 1, 2010, the new regime is effective on any payment shold-billing amount as pre-

ithholding solution for Argentine has been enhanced to address these

mes.

With these changes, users now can:

• Identify o are Monotr

• Verify supplier’s billing information against fiscal authority thresholds

• Analyze information through the Monotributistas Billing vs. Threshold Verification Report

• Automatically enable Simplified Regime applicability to Monotributistas that meet the threshold.

This update has also been back-ported to the following releases: Release Patch Number My Oracle Support

Monotributista). Effective Januarmade to a Monotributista that has reached an annual thredefined by the government.

The extended wchanges. Suppliers can now be defined using withholding types and rates applicable to simplified regi

suppliers wh ibutistas


Knowledge Document 11.5.10 8971151 12.0.5 12951:R1 987131.1 91 2.JL.A 12.1.1/12.1.2 9112951:R12.JL.B 987131.1

3.19.4.2. Belgium: Annual VAT Report File Format v1.3

Effective from January 2010, the new v1.3 file format has replaced the current v1.2 file f the Belgian An turn File. T ate has also bee orted to the following releases:

elease Patch Number

ormat of nual VAT Rehis upd n back-p

R11.5.10 9249589 12.0.5 9480859:R12.JE.A 12.1.1/12.1.2 9480859:R12.JE.B

3.19.4.3. Brazil: Support for Brazilian Electronic Collection Document Process (DDA)

Effective October 2009, Oracle Financials for Latin Americaattributes in the C

introduced two new ollection Document Window and in the Import Collection Documents

(DDA) system:

• Collection Document Barcode: The Collection Document Barcode is required is mandatory record speeds up the data entry

of manually collected documents and is now a required field in the Standard Collect .

• Electronic Collection Document Flag: The Electronic Format (Y/N) flag identifies if the respective collection document is electronic (Y) or standard (N).

ses:

My Oracle Support Knowledge Document

program to support the Brazilian Authorized Direct Debit

for the Electronic File Transfer. Th

ion Document

This update has also been back-ported to the following relea Release Patch Number

11.5.10 8802352 1071872.1 12.0.5 9319746:R12.JL.A 987749.1 12.1.1/12.1.2 9319746:R12.JL.B 987749.1

r Version 2 of the China Accounting Software Data 3.19.4.4. China: Support foInterface Standard

The China National Audit Office (CNAO) has defined a newauditing filing standard, known as the Chin

version of their accounting a Accounting Software Data Interface

Standard. The new standard requires a number of XML-based reports, using data primarily from the General Ledger, Payables, Receivables, Assets, and Payroll modules. It is currently required for state-owned enterprises and public sector organizations.

3.19.4.5. India: Enhanced Value Added Tax (VAT) Functionality to Support Flexible Recovery Schedule for India

Oracle Financials for India now provides the flexibility to use VAT recovery schedules and percentages to derive the tax installments and dates to claim or recover VAT on capital goods.


3.19.4.6. India: Value Added Tax (VAT) Statutory Accounting and Reporting for Non-Shippable Items

Users can now have the ability to generate Value Added Tax InvVAT Repository

oice Numbers, perform updates, and account for VAT taxes for customer billable non-shippable

ment

items on sales orders.

3.19.4.7. Israel: Israel VAT Report Enhance

Effective January 2010, new legislation was introduced affecting companies issuing islative changes include:

utput taxes

•

d on Petty Cash transactions

aration of export trade transactions (Rshimon Export)

ting Setup has been updated to capture monthly aggregation and declaration limits for Israel.

been enhanced to incorporate the legislative changes:

• Israeli VAT AP Detail Report

• Israeli eclaratio Authorities

• Israeli VAT File Generation Related to 835

releases:

Release Patch Number My Oracle Support Knowledge Document

periodic VAT declarations in Israel. The leg

• Enhanced tax reporting boxes for declared input and o

New electronic flat file format declaration related to 835

• Aggregated reporting of taxable sales transactions below the official published limits

• Monthly percentage or amounts limits for tax reclaime

• Mandatory decl

The EMEA VAT Repor

The following Israeli reports have

• Israeli VAT AR Detail Report

VAT Summary D n to Tax

This update has also been back-ported to the following

12.0.6 9241039:R12.JE.A 981126.1 12.1.1/12.1.2 9241039:R12.JE.B 981126.1

3.19.4.8. Israeli: Withholding Tax File – 856

Legislative amendments to the Income Tax Ordinance require updates to the ‘Withholding Tax File – 856’. These amendments impact the existing ‘Israeli Withholding Tax File to Tax Authority’ report.

In summary, the amendments are as follows:

• The existing Row 60 has been updated. New fields ‘Tax Year’, ‘Supplier Type’ and ‘Explanation for the Tax File in IRS’ have been added to this row.


• The existing Row 70 has been updated. New fields ‘FPayments Paid by Bank’ and ‘Foreign Suppliers Tota

oreign Suppliers Total l Withhold Amounts Paid

by Bank’ have been added to this row. Positions 53 to 101 are filled out with

• A new row (Row 80) has been added to the file. This row has 216 positions and line per each month of the year.

pe Code, Tax Year, Period, Number of tal Withholding Tax, 155 spaces and the

T has also bee the following releases:

spaces.

is composed of 12 lines, one

The following data is also generated as part of row 80:

• IRS Deduction File Number, Reporting TyReported Suppliers, Total Payments, Toconstant ‘80’.

his update n back-ported to

Release Patch Number 12.0.5 9253606:R12.JE.A 12.1.1/12.1.2 9253606:R12.JE.B

3.19.4.9. U.S. Federal: Extract File Changes for Central Contractor Registration (CCR)

CCR processing has been enhanced to process the BPN extract contain additional NAICS information, as well as the Excluded Parties List Sy

v4.09 files. The extracts stem

ML request version number has been updated to 2.10. The lso been updated to display the additional information.

3.19.4.10. U.S. Federal: Regulatory Updates to Statement of Budgetary Resources

(EPLS) status. The CCRXCCR Vendors pages have a

The setup and concurrent process for the following Federal Financial Statements have ed June 10, 2009) as well

• Stateme s in Net Posi

.4.11. U.S. Federal: Regulatory Updates to SF-133 Report

been modified to align with OMB Circular A-136 Revised (datas USSGL Fiscal Year 2010 crosswalk attributes:

• Statement of Budgetary Resources

nt of Change tion.

3.19

The setup and concurrent process for the SF 133, Report on Budget Execution, has been modified to align with OMB Circular A-136 Revised (dated June 10, 2009) as well as USSGL Fiscal Year 2010 crosswalk attributes. This update has also been back-ported to the following releases: Release Patch Number My Oracle Support

Knowledge Document 11.5.10 9307464 979828.1 12.0 9162915:R12.FV.A 979828.1 12.1.1/12.1.2 9162915:R12.FV.B 979828.1


3.19.4.12. Global: European Community VAT Changes for 2010

Effective January 1, 2010, the European Union (EU) introduceAdded Tax (VAT) to modernize and simplify the rules for croand tax recovery. Business-to-business supply of services will now no longer be taxed

d changes related to Value ss-border supply services

where the supplier is located but will be taxed where the customer is situated. The

hanges by providing the res:

transaction lines and display them on the European

• Print standard legal messages on s

This update has rted to t ng releases: Release ch Num My Oracle Support

Knowledge Document

changes also introduced new reporting requirements.

Oracle Financials has been enhanced to address the new VAT cfollowing featu

• Identify the intra EU service Sales Listing report

ales invoices.

also been back-po he followi

Pat ber

12.0 9337544:R12.ZX.A 9123675:R12.BPA.A

974979.1 1107453.1

12.1 9337544:R12.ZX.B 9123675:R12.BPA.B

974979.1 1107453.1


4. New and Changed Features in Real Estate Management

4.1. Oracle Property Manager

4.1

anagement solution orate, commercial, or retail operation, Oracle

solution for managing your real estate erty Manager streamlines space management and lease

aximizes the value of your real estate by:

s and identifying new revenue opportunities

• Minimizing contractual and financial risk

.1. Overview

Oracle Property Manager is the cornerstone of the real estate mprovided by Oracle. Whether you are a corpProperty Manager provides a comprehensive portfolio efficiently. Oracle Propadministration, and m

• Reducing cost

• Providing data transparency

4.1.2. Release 12.1.1 Leasing Features

4.1.2.1. New Lease Statuses

Two new statuses have been introduced for leases. The new statuses are ‘Lease Ordered’ es are available when the lease approval status is ‘Draft.’

edules and items are created for es or make payments from the

e only, before the lease is finalized. Users can ay be required before a

ase Extension Enhancements

and ‘Signed’. These statusWhen a lease has a status of Lease Ordered or Signed, schany one-time payments. This allows users to create invoiclease, for terms with frequency of one-timuse this new functionality for deposits or other payments that mlease is finalized.

4.1.2.2. Le

When the status is changed to Month-to-Month or Holdover andentered, the followin

an extension date g things will now be done automatically:

on date will be extended

e agreements extended. ections on Variable Rent and Rent Increase

enhancements.

• Extensions of terms and agreements can be rolled forward month by month using a new concurrent process.

• The system extends existing normalized payment terms differently depending on the lease status. If the user changes the status from Active to Month-to-Month or Holdover, the system extends a normalized payment term ending on the old lease termination or extension date by adding a new non-normalized term rather than by changing the end date of the existing term. If the lease is later placed back in Active status, the term will be extended by addition of a new normalized term beginning on the amendment commencement date.

• Recurring payment terms that end on the lease terminatito the new extension date.

• Users can choose to have variable rent and rent increasThis is described further in the s

Oracle E-Business Suite Release 12.1.Release Content Document 24BOracle Property Manager 35

4.1.2.3. Tenancy Extension and Contraction

When the user extends or contracts a lease, tenancy records (records on the locations tab of the lease) will be extended or contracted as well, as appropriate.

ibute on Tenancy 4.1.2.4. Assignment Occupancy Percent Determined by Attr

A new field on the lease locations (tenancy) tab, Assigned % Area: determines the % ent, that is, it will determine what percentage of the

tomer. The default will be 100%

ltiple Schedules for Same Schedule Day

Area value on the Customer Assignmlocation area is occupied by that cus

4.1.2.5. Mu

Oracle Property Manager can create a new draft schedule, if needed, for a date with an new term with the desired

g/Payment Amount based on a New Start Day Field

existing approved schedule. This means you can create aschedule day in all cases

4.1.2.6. Prorating the Billin

A new field has been added to the Lease form to capture the Year Start Date for n this field, the Schedule Start Date is determined considering the

3.1. Breakpoint Flexibility

Prorating. Based operiod in which the Term Start Date falls into.

4.1.3. Release 12.1.1 Variable Rent Features

4.1.

Complete flexibility in setting up line items and breakpoint definitions has been introduced. With this feature, users can:

ts, rates, breakpoint types, imes over the span of the

• Enter line item and breakpoint details with any start and end date, not restricted end dates.

• Set up complex agreements with changes to breakpoinline items, etc., occurring on any date, any number of tlease.

to sales year start and

4.1.3.2. Updating Breakpoints

Users can now change breakpoint definitions at any time, regardless of whether variable

ent. If the changes affect rent that has been approved, the application will create adjusting terms.

4.1.3.3. Natural Breakpoint Enhancements

rent has been calculated and approved. To respond to amendments or to correct data, users can change most parts of a variable rent agreem

When the terms that form the basis for a natural breakpoint change, whether because of a rent increase or because a user added or ended a term, the system now automatically recalculates the natural breakpoints. The user can recalculate the variable rent; and if the changes affect rent that has been approved, the application will create adjusting terms.

Users now select terms to form the basis for natural breakpoints using a new attribute on the term, allowing complete control over which terms are to be included.


Users can now have rent increases, selectively, included in the natural breakpoint basis as the increases are assessed.

4.1.3.4. Early Termination of Agreement or Lease

The user can now end variable rent agreements as of any date, either directly or by terminating a lease. The system will perform any recalculations necessary if variable rent has already been paid for affected periods and will create adjusting and/or reversing terms.

4.1.3.5. Extension of Variable Rent Agreements

The user can now extend the length of variable rent agreements, or have the system extend the agreement automatically when a lease is extended. The user also chooses

stem automatically extend the latest breakpoint definitions when breakpoint definition detail for the

extension period.

whether to have the sythe agreement is extended or to manually enter the

4.1.3.6. New Calculation Methods

Two new calculation methods have been introduced for Variable Rent.

m determines overage by comparing the cumulative olume).

iodically through the year with a non-cumulative method and then does a True Up calculation at the end of the

• Year-to-Date. The systebreakpoint with the cumulative sales (or other v

• True Up. The system calculates variable rent per

year (or other appropriate period).

4.1.3.7. New Partial Year Calculation Methods

Several new methods (in addition to the existing Standard Proraintroduced to calculate variable rent in partial years at the beginning or end of an

tion) have been

agreement.

rst year variable rent is calculated based on the first 12 second year as proxy for

is prorated based on the

Last Year. This is the equivalent of the First Year method, applied to partial last

selected, both the First Year and Last Year methods will be applied.

• Combined Year with Breakpoint Proration. The first partial year is combined with the second year. For cumulative and year-to-date methods, breakpoints and volumes continue to accumulate for more than 12 months. The breakpoints are effectively ‘annualized’ because the period of breakpoint accumulation matches the period of volume accumulation.

• Combined Year without Breakpoint Proration. The first partial year is combined with the second year. A blended annual breakpoint is calculated for the combined period, converted to a 12-month value. This is used as the basis for

• First Year. A partial fimonths of sales, effectively using some sales from thethe missing months in the first year. The resulting rent actual length of the first partial year.

•years.

• First Year / Last Year. If this Partial Year Method is


breakpoints for all methods. Since the combined year isand the sales are accumulated for that longer period, th

longer than 12 months, e breakpoint accumulation

is not matched to the volume accumulation and the breakpoint is not, in effect,

o Proration. The breakpoints are used as entered, without proration. There is no interaction or combination between values in the first partial year and the

ent Agreements

annualized.

• N

second year.

4.1.3.8. Month-to-Month Roll Forward of Variable R

If a lease is in Month-to-Month status, thevariable rent agreement with each monthly

user can choose to automatically extend the roll-forward of the Month-to-Month

4.1.3.9. Enhancement to Cumulative Calculation Method

extension.

When the overage rate for calculation of variable rent changes mid-year, accumulation of of the ‘cumulative cycle’

rate changes. volume recommences. Breakpoints are prorated to the length determined by sales year end dates or

4.1.3.10. Allowances and Abatements

There are a number of enhancements related to allowances and abatements. Users can:

plied first.

for recurring abatement at the time that agreements are created.

tions automatically and have the system able rent calculation process.

• Enter amounts for ‘Fixed Abatement.’ This is a new type of abatement. A fixed tement is an amount entered by the user to be applied as abatement for each

nt of recurring abatement nvoice period.

e Rent

• Create multiple allowances with effective dates.

• Specify whether allowances or abatements are to be ap

• Select terms

• Roll forward recurring abatement selecapply abatements automatically as part of the vari

abainvoice period, much like the system applies the amouterms each i

4.1.3.11. Carry Forward of Excess Abatement as Negativ

Users can now control through an agreement parameter wamounts are treated as negative rent.

hether excess abatement

4.1.3.12. Constraints

Users can now set start and end dates for constraints for the life of the agreement rather than setting them up for each year.

4.1.3.13. Updating Volumes

Users can now update previously entered volume amounts through the Variable Rent Gateway, where previously the only way to do an adjustment was by entering an additional volume record (with a positive or negative adjusting amount).


4.1.3.14. Additional Frequency Attribute

The attribute called ‘Reporting Frequency’ in previous functiondifferent frequencie

ality determined two s, which sometimes should have had different values. This attribute

requency.’

• Reporting Frequency. The frequency with which the tenant is required to report equency does not affect calculations but does affect the logic by

entry rows.

Adjustments

has been split into two attributes:

• Calculation Frequency. The frequency with which variable rent is calculated. This was the primary purpose of the former ‘Reporting F

volumes. This frwhich the Variable Rent Gateway creates default volume

4.1.3.15. Streamlining of

Users can now recalculate variable rent at any time, to accommodate for changed volume, ms if necessary. There

rate adjustment process.

Enhancements

breakpoints or other factors. The system will create adjusting teris no longer a sepa

4.1.3.16. Form

There have been many enhancements to layouts and navigation,screens and

decreasing the number of improving usability.

folder blocks to allow for configuration.

een added between the invoice review screen and the line item

• Multi-row views have been combined on a single screen with a master-detail reduce the number of screens and present information in a more

lation Results

• A number of multi-row views have been converted to user

• Drilldowns have breview screen.

relationship tointuitive layout.

4.1.3.17. Display of Calcu

Users can review in detail, on-screen, the calculation thatamount, regardless of which method is used for the agreement.

4.1.3.1

resulted in the variable rent

8. Variable Rent Templates

Users may select a variable rent template to populate many of the attributes of a variable rent agreement. This reduces data entry effort and error.

4.1.3.19. Term Template Enhancements

Users can now create, edit and save term templates from within the variable rent agreement. Now, users can maintain a relatively small number of generic term templates to use as the starting point for term detail defaults for variable rent agreements. The user will select a generic term template then, if necessary, make a copy with changes specific to the agreement.


4.1.3.20. Processing by Property

Property has been added as a parameter to the concurrent process for calculation of variable rent so that users can now select agreements by property for batch calculation.

4.1.3.21. Improved Variable Rent Report

An improved report has been introduced for reporting calculated variable rent.

4.1.4.1. Early Termination of Rent Increase Agreements

4.1.4. Release 12.1.1 Index Rent Features

The user can now end rent increase agreements as of any date, either directly or by r reversing items as necessary.

t Increase Agreements

terminating a lease. The system will create adjusting and/o

4.1.4.2. Extension of Ren

The user can now extend the length of rent increase agreemenextend the agreement automatically when a lease is exte

ts, or have the system nded.

h-to-Month Roll Forward 4.1.4.3. Mont

If a lease is in Month-to-Month status, the user can choose torent increase agreement with each monthly roll-forward of thextensio

automatically extend the e Month-to-Month

n.

Index Multiplier 4.1.4.4.

Users can now specify a multiplier to be applied for rent increases based on an index amount specified is multiplied times the calculated change in the index

er than by the actual index

4.1.4.5. Proration

value. Theamount and the rent is changed by the resulting value rathchange percentage.

The system will now prorate constraints on rent increase for partial years.

4.1.4.6. Term Length

One compounding rent increase calculation method has been changed so that rent increase terms are created only for the length of the assessment period rather than to the end of the lease. This is appropriate for this method so that users now do not need to manually change the term lengths.

4.1.4.7. Include/Exclude Option

A system option has been introduced that controls how terms are selected to form the basis for rent increases. With previous functionality, all terms of the selected type were selected by default for inclusion and users would deselect terms as appropriate. An organization now can choose whether terms are included or excluded by default. Users will still have complete control at the individual agreement level.


4.1.4.8. Recurring Backbill Terms

An option has been introduced that controls whether backbill tetime terms or as recurring terms. If they are created as recurring

rms are created as one- terms, the transaction

date for all resulting schedules is set to the same date, which is the date that the term was

4.1.4.9. Rent Increase Report

approved.

An improved report has been introduced for reporting calculated rent increases.

4.1

This major new feature allows tenants to record in detail the lease clauses governing imbursements or recoveries (also known as common area

eating and changing

.5. Release 12.1.1 Operating Expenses Features

payment of operating expense remaintenance expenses, etc.) to landlords. It also supports crestimated payment terms and periodic reconciliations.

4.1.5.1. Create Operating Expense Agreement

Users can create an operating expense agreement for any lease clause governing the ea maintenance costs.

aspects of these agreements in a structured way that ents across the portfolio and also supports the

consistent and accurate reconciliation and ‘desktop audit’ of landlord reconciliation that can be recorded in a structured way include:

asis for expense recovery, such as occupied area with floor

ses within a single agreement

fees and anchor contributions

les governing recovery of different expense groups or pools, within a single her a type of expense is subject to fees or cap

nd minimums

• Different reconciliation frequencies

• Whether rent is subject to tax

• Stop amounts

• How reconciliation credits can be applied

• Standard expense group naming, for cross-portfolio comparisons

• Critical date rules, such as audit period and statement and payment due dates

• Extensive notes, by category

payment of rent based on landlord operating costs or common arThe agreement captures the keyenables consistent recording of agreem

statements. Aspects of agreements

• All common ways of determining the pro rata b

• Multiple pro rata ba

• Administration

• Ruagreement, such as whet

• All common methods for calculating caps a


4.1.5.2. Enter and Maintain Estimated Payment Terms

If the agreement requires the tenant to make estimated payments budgets, the user can create the payment term through the OperatEstimated payment amounts are often adjusted by landlords annThe user can enter new amounts th

based on landlord ing Expense Agreement.

ually or at other intervals. rough the Agreement and the system will create the

appropriate term, including a catch-up term if needed. A history of the changing amount red and displayed, with percent change. is thus captu

4.1.5.3. Reconciliation

Reconciliation is created for each agreement for each reconciliation period. The user can ent and use the reconciliation econciliation statement.

• Key entry, from the landlord reconciliation statement, of information not landlord expenses.

ected’ column, if the user has information that conflicts with the values presented by the landlord.

known based on the Operating nciliations, such as

amount already paid as

o Optional entry of the same items in the ‘Statement’ column, if the me as expected.

-ent next to the values

expected by the user. The calculation includes caps, fees, contributions, lation, and prior payment

for each expense group, , and the tenant share of expenses.

is with side-by-side comparison.

Simple creation of reconciliation payment term based on the bottom line of the reconciliation analysis, or simply the payment due amount on the landlord reconciliation statement.

• Flexible expense year dates, or reconciliation period dates, so that reconciliations can be done at irregular intervals if needed.

• Reconciliation notes and direct access to notes related to the agreement and to prior reconciliations.

• Maintenance of critical dates specific to each reconciliation, such as audit period end date.

record information from the landlord reconciliation statemscreens as a ‘workbench’ for doing a desktop audit of the rFeatures include:

available to the user from other sources, such as actual

o Optional entry of the same items, in an ‘Exp

• Presentation by the system of information that is Expense Agreement, previous payments, and prior recocalculated cap amount, agreement fee percentage andestimated payments.

amounts on the landlord statement are not the sa

• Detailed presentation of the operating expense obligation calculation, in side-byside layout, showing the values from the landlord statem

occupancy adjustments and stops, pro rata share calcuamounts.

• Presentations of the percent change over the prior periodthe total landlord expense

• Printable version of the detailed reconciliation analys

•



Tracking of reconciliation and audit status, and users responsible for each.

• Preservation of prior versions of a single reconciliation.

•

4.1.5.4. Operating Expense Agreement Dashboard

A dashboard presents agreements, reconciliations, and relalikel

ted payment terms that are y to need attention, based on user-configurable selection criteria. The dashboard also

s, reconciliations and/or

Users can select existing objects for view or update, or can initiate creation of new agreements, reconciliations or payment terms from the dashboard.

has advanced query capability for searching for agreementpayment terms.