An Orastudy Site | Oracle ERP 专业站点

Below is the Forms Personalization code which will add a Web Link in the Tools menu  :

1) Login to your responsibility.

2) Go to the Forms you need to personalize.
3) Open personalizations forms :  Help/Diagnostics/Custom Code/personalize.
4) Enter sequence as ’1′ and in description enter ‘Init Web URL menu’.
5) In condition tab, enter trigger event as ‘WHEN-NEW-FORM-INSTANCE’.
6) Click on ‘Actions’ tab. Enter sequence as ’1′ and Type = ‘Menu’.
7) Choose Menu Entry (any of the special menu entries). Eg. Special 12.
8) Enter menu label ( eg: Web URL ).
In ‘Enable[......]

阅读全部…

Use a single installation of any Oracle Applications product to support any number of organizations, even if those organizations use different sets of books.

Support any number of legal entities within a single installation

Secure Access: You can assign users to particular organizations. This ensures accurate transactions in the correct operating unit.of Oracle Applications.

You can sell from one legal entity and ship from another, posting to each organization’s set of books.

You can enter purchase orders and assign for receipt any inventory organization that uses the same set of books.

Y[......]

阅读全部…

Product Integration

Single installation improves integration between products that required multiple

installations and those that did not. Two integration examples are Oracle General

Ledger’s drill down to Oracle Receivables and Oracle Payables mass addition to

Oracle Assets. In a multiple installation environment (MSOBA), these features

often worked only for one installation.

Global Enterprise Management and Visibility

A core benefit of a single-instance is the ability to improve global enterprise

management and visibility to global enterprise conditions. Implementing global

business[......]

阅读全部…

Conventional DSO = (total outstanding receivables/total sales for prior DSO
days) * (DSO days)

You select DSO days in the Setup=>System =>System Options screen, under the
Miscellaneous drop down box.

Solution Explanation:
=====================
The formula used to calculate DSO is : 

ROUND( ( (SUM( DECODE(ps.class,'INV',1,'DM',1,'CB',1,'DEP',1,0
                      ) * ps.acctd_amount_due_remaining
             ) * MAX(sp.cer_dso_days
                     )
          )
/* Pick amount_due_original only when the gl_date lies between sysdate and dso_days */
/* The Denominator would be 1[......]

阅读全部…

STRATEGY

1. An incorrect strategy has been assigned via strategy management program to the customer, Why?

a. Please check the score of the customer/account/bill to/delinquency as applicable and check the minimum applicable score of the strategy template.
b. Make sure you have not selected the strategy from Change strategy button
c. If the object (customer/account/bill to/delinquency) doesn’t fall in segment corresponding to any strategy template and then default strategy will be assigned.

2. Strategy is missing in strategy tab?

a. Make Sure Score exists for the customer/accoun[......]

阅读全部…

1. Confirm additional product installation:

Confirm that you have the appropriate products installed to allow Collections to work properly. The following files will need to be compiled on your instance resulting in .plx files. Without these files compiled, Collections will not work properly.

CUSTOM.pll, GLOBE.pll, FNDSQF.pll, JE.pll, JA.pll, JL.pll,
JTF_GRID.pll, JTFDEBUG.pll, JTF_UTIL.pll ,ASOCORE.pll
ASTTMLIB.pll, ASTBOMAN.pll, IEUPUWQ.pll
CSUTILS.pll, CSQKMENU.pll, (ASTCORE.pll in Release 11i only)

2. Setup your Collections User:

Refer to Note: 230346.1 How To Setup a Collect[......]

阅读全部…

 In this Document
  Goal
  Solution
     1. Disable Create Accounting Concurrent Request
     2. Disable the Create Accounting Online Menu from the Workbenches
     3. Review Settings
     Still Have Questions?
  References

Applies to:

Oracle Receivables – Version: 12.0.0 to 12.1.2 – Release: 12.0 to 12.1
Information in this document applies to any platform.

Goal

Oracle Receivables (AR): Transactions Workbench Information Center > Transactions Form Personalizations: Sample Code, Known Issues and Patches > Note 1074342.1

How can I the restrict the a[......]

阅读全部…

Applies to:

Oracle Receivables – Version: 12.0.0 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
***Checked for relevance on 27-Jul-2011***
ARACCPB : Submit Accounting
XLAACCPB : Create Accounting
XLAACCUP : Accounting Program
FND_REQUEST.SUBMIT_REQUEST

Purpose

This sample code will call “Submit Accounting” (Program short name is “ARACCPB “) in Release 12 using FND_REQUEST.SUBMIT_REQUEST API
Submit Accounting will interm spawn Create Accounting (XLAACCPB) which will create Accounting for Entities as on a given date,calls Accoun[......]

阅读全部…

作为一个企业级的学习管理系统（LMS）以及Oracle电子商务套件的关键组件，Oracle iLearning为任何人、在任何时间和任何地点，提供了一种方便的、经济的、以互联网为基础的学习解决方案。Oracle iLearning可在线使用，为员工、客户和商业合作伙伴提供一致的、全球化的学习，从而最大限度拓展您的企业的业务范围。

为什么使用Oracle iLearning？

作为Oracle.com的在线商务套件的一部分，Oracle iLearning通过让Oracle来管理您的学习管理系统，使您能将注意力集中在核心业务上。Oracle iLearning允许您可以在不同的部署选项中进行选择。Oracle.com可为"任何地点"的Oracle iLearning提供远程管理服务，这包括在Oracle数据中心、在您的站点、或在您选择的任何地点进行管理的Oracle iLearning。Oracle.com的"任何地点"部署选项使您能够充分利用快速和可靠的在线服务，但也使您可选择将自己的硬件设备置于何处。Oracle将提供远程系统管理服务，包括应用程序产品支持、功能实施、应用程序和数据库管理等，而您的企业将负责硬件和设备的管理。

Oracle iLearning的关键特性

特性概述
* 标准的LMS特性，比如自行注册、目录检索、[......]

阅读全部…

在报废该期间的一项资产并创建日记帐分录时，Oracle Assets 会为损益额的每个组成部分创建总帐日记帐分录。它还会为以下每个组成部分的损益帐户创建日记帐分录：销售收入、拆迁成本、报废的帐面净值以及报废的重估准备金。同样，它还会创建日记帐分录来结算销售收入和拆迁成本。

Oracle Assets 会为在"帐簿控制"窗口中设置的报废帐户创建日记帐分录。如果为损益额的每个组成部分输入不同的损益帐户，Oracle Assets 会为这些帐户创建多个日记帐分录。对于导致收益的报废和导致亏损的报废，您可以输入不同的报废帐户集。

报废折旧

报废惯例、报废日期和折旧方法控制着报废资产时 Oracle Assets 所提取的折旧额。

如果资产折旧法未在报废年度对资产进行折旧，Oracle Assets 会冲销年初至今折旧。在这种情况下，如果执行完全报废，Oracle Assets 将冲销资产的年初至今折旧，并使用所得出的帐面净值计算损益。如果执行部分报废，Oracle Assets 会冲销相应部分的年初至今折旧，并使用所得出的相应部分的帐面净值计算损益。

如果折旧方法在报废年度提取折旧，Oracle Assets 会使用报废惯例来确定资产是否适合在该年度进行附加折旧，或者是否必[......]

阅读全部…