China Local Reports Release Notes, Release 12.1

Applies to:

APAC Add-on Localizations - Version: 12.1.1 to 12.1.1 - Release: 12.1 to 12.1
Information in this document applies to any platform.
Oracle APAC Add-On Localizations - Version: 12.1.1 to 12.1.3

Purpose

Oracle APAC Add-On Localizations - China Local Reports Release Notes, Release 12.1

Scope and Application

This document provides information about Oracle China Local Reports which are being delivered by APAC Add-On Localizations (CLA) on Oracle EBusiness Suite Release 12.1, as well as installation steps. This is the second version for China Local Report, which contains more reports and makes some enhancement against the first version (Note 842923.1).

Oracle APAC Add-On Localizations - China Local Reports Release Notes, Release 12.1

1. Applying patches for Oracle China Local Reports Release 12.1

 

The patches for Oracle China Local Reports 12.1 are supposed to be applied upon Oracle E-Business Suite, Release 12.1

1.1 Pre-install

The following pre-requisite patch is required to be applied prior to applying the patch 10209774:R12.CLA.B 

Patch 8506229 - APAC Consulting Localizations 12.1 (R12.CLA.B)

1.2 Applying the patch 10209774:R12.CLA.B

This patch contains the following unified driver file to be applied with AutoPatch: 

U10209774.drv (This is the unified driver)  

The patch has fully translated into Chinese, please apply corresponding ZHS patch along with US patch if Chinese report layouts are needed.

2. Documentation 

2.1 Userguide

2.1 Userguide

The userguide for these China Local Reports could be downloaded through the documentation patch 10224781

Top

3. New and Changed Features

Based upon release 12.1, Oracle APAC Add-On Localizations have added the following feature for Mainland China.

3.1 China Local Reports

3.1 China Local Reports 

Description	The following seven reports are offered to meet legal requirements or needs of financial auditing for customers in Mainland China Voucher Printing Report General Ledger Voucher/Subledger Transaction Mapping Report Daily Cash/Cash In Bank Report Ledger Report Supplier/Customer Balance Detail Report Supplier/Customer Balance Summary Report Inventory In Out On-Hand Report
New, Changed, Obsolete Components	This section lists the components that were added, changed, or made obsolete for this feature in Oracle China Local Report in Release 12.1. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs. New Tables This table lists the new tables. Table Name Description CLA_CN_INV_BALANCE_GT This global temporary table is used to store interim calculation result during execution process of Inventory In Out On-Hand Report CLA_CN_TP_CUR_BALANCES This table is used for storing third party balances by currencies. The data is created and updated during execution process of the Supplier/Customer balance Detail Report or Supplier/Customer Balance Summary Report incrementally. CLA_CN_TP_CUR_ITEM This table is used for storing third party transaction item ids by currencies, which will improve performance while calculating currency balance. The data is created and updated during execution process of the Supplier/Customer balance Detail Report or Supplier/Customer Balance Summary Report incrementally. CLA_CN_TP_FILTER_GT   This global temporary table is used to store interim calculation result during execution process of f the Supplier/Customer balance Detail Report or Supplier/Customer Balance Summary Report. CLA_CN_LEDGER_LE_BSV_GT This global temporary table is used to store interim data related to Balance Segment Value (BSV) assignment of legal entities for all reports.   Changed Tables There are no changed tables that are associated with this feature. Obsolete Tables There are no obsolete tables that are associated with this feature. New Views This table lists the new views. View Name Description CLA_CN_PARTY_NUMBERS Supplier/Customer balance Detail Report and Supplier/Customer Balance Summary Report programs have the third party number from/to parameters, the value of which can be selected from the value sets CLA_CN_PARTY_NUMBER_FROM and CLA_CN_PARTY_NUMBER_TO. The view is used for these value sets definition for both supplier and customer third party types.   New XML Publisher Components This table lists the new XML Publisher Components. Definition  Name Template Name Concurrent Program Voucher Printing Report Voucher Printing Report Voucher Printing Report General Ledger Voucher/Subledger Transaction Mapping Report General Ledger Voucher/Subledger Transaction Mapping Report General Ledger Voucher/Subledger Transaction Mapping Report Daily Cash/Cash In Bank Report Daily Cash/Cash In Bank Report Daily Cash/Cash In Bank Report Ledger Report Ledger Report Ledger Report Supplier/Customer Balance Detail Report Supplier/Customer Balance Detail Report Supplier/Customer Balance Detail Report Supplier/Customer Balance Summary Report Supplier/Customer Balance Summary Report Supplier/Customer Balance Summary Report Inventory In Out On-Hand Report Inventory In Out On-Hand Report Inventory In Out On-Hand Report       Changed XML Publisher Components There are no changed XML publisher components that are associated with this feature. Obsolete XML Publisher Components There are no obsolete XML publisher components that are associated with this feature.
Implementation Considerations	New and Changed Setup Steps This section lists the setup steps that were added or changed for Oracle China Local Reports in Release 12.1. For additional details about performing the setup steps listed below, refer to the documentation described in the Documentation section. Voucher Numbers Run Voucher Number Generation program firstly before using these reports, otherwise the voucher number can’t be shown in these reports. If you are also the customer of Solution for China Accounting Software Data Interface Standard, Before running Voucher Number Generation Program, Voucher Number Migration Program should be run firstly to migrate historical voucher numbers from Solution for China Accounting Software Data Interface Standard itemization program. As this migration program will purge the voucher numbers generated by Voucher Number Generation program, you need rerun the Voucher Number Generation program after the Voucher Number Migration program even you once run the generation program before. If you make balance segment value (BSV) changes in a month, you are recommended to run the “Voucher number generation” program with “Regeneration” option.   Supplier/Customer Balance Detail Report and Supplier/Customer Balance Summary Report If you plan to use these two reports, please make sure following steps have been completed: Control Account segment qualifier should be defined for balance sheet accounts, for example, Receivable or Liability, to retrieve balance information for Third parties, including customers and suppliers. See: Defining Segment Qualifiers, Oracle General Ledger Implementation Guide. Run “Program – Inherit Segment Value Attribute” program to propagate Control Account attribute of the accounts defined in above step to all relevant account combinations. See: Segment Value Inheritance, Defining Segment Qualifiers, Oracle General Ledger Implementation Guide. Run “Subledger accounting balance updates” program under AP and AR to update third party balance. MO: security profile should be set for the responsibility level to run these reports. See: Multiple Organizations in Oracle Applications   Voucher Printing Report The xml data files of this report also exports some additional columns that are not showed in standard report layout, such as attribute1~n etc, you can extend the report to show them if need be. Upgrade Considerations There are no upgrade considerations for this feature. New Concurrent Programs Voucher Printing Report General Ledger Voucher/Subledger Transaction Mapping Report Daily Cash/Cash In Bank Report Ledger Report Supplier/Customer Balance Detail Report Supplier/Customer Balance Summary Report Inventory In Out On-Hand Report
Customizations and Extensions	All these reports were developed by BI Publisher technologies. If you would like to customize report layout, please make copies from the original concurrent programs and templates and do modification on those new copies, in lieu of making modification on original concurrent programs and templates directly, otherwise it might cause support issue.
Minimum Level Requirements	There are no minimum level requirements for this feature.
Technology Stack Incompatibilities	There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations	There are no technology architecture considerations for this feature.
Troubleshooting Tips	There are no troubleshooting tips for this feature.Oracle APAC Add-On Localizations - China Local Reports Release Notes, Release 12.1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/86584/viewspace-700794/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/86584/viewspace-700794/