ITPub博客

首页 > Linux操作系统 > Linux操作系统 > China Local Reports Release Notes, Release 12.1

China Local Reports Release Notes, Release 12.1

原创 Linux操作系统 作者:leoa_z 时间:2011-06-27 13:35:09 0 删除 编辑

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 

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:

  1. 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.
  2. 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.
  3. Run “Subledger accounting balance updates” program under AP and AR to update third party balance.
  4. 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-06

  • 博文量
    47
  • 访问量
    186055