Thursday Jan 23, 2014

An Introduction to Subledger Accounting
By Chris Rudd

R12 saw the introduction of Oracle Subledger Accounting (SLA), a rule-based accounting engine that centralizes accounting for Oracle E-Business Suite products in Release 12 and above.
SLA is not a separate product in itself, but is Oracle’s engine catering to the accounting needs of Oracle applications. There are no SLA responsibilities, you do not log into SLA, Subledger Accounting forms and programs are embedded within standard Oracle Application responsibilities (for example, Payables Manager).

Multiple Accounting Representations

Together with the new ledger support in General Ledger (GL), SLA provides the ability to maintain multiple accounting representations in a single instance.
A Subledger Accounting Method is linked to a ledger and the rules contained within that Subledger Accounting Method determines how a transaction is represented in that ledger.

In R12, you can have Primary, Secondary and Reporting Currency Ledgers. Your primary ledger is your main reporting ledger, a Secondary Ledger can be used if you have the need for another accounting representation and a reporting currency ledger is used where you need to report in another currency.


A US Corporation has an operation in France. The French operation is subject to French accounting regulations, and therefore must report its activities to the local authorities in Euros, according to the French business calendar, French chart of accounts, and the French interpretation of IFRS (International Financial Reporting Standards).

This would be the French Primary Ledger. However, the US headquarters/parent company would need to have a consolidated global visibility of the worldwide operations so you can use a Secondary Ledger linked to the French Primary Ledger. The Secondary Ledger will share the same currency, COA, calendar and Subledger Accounting Method as those at HQ.

In the definition above, Subledger Accounting allows:
• multiple accounting methods to be defined
• separate accounting methods to be used on different ledgers

Journal entries will be created for both ledgers for a single subledger posting (French activities accounted for on the primary ledger according to the IFRS method, and on the secondary ledger according to the US GAAP method).

Oracle provides a number of seeded Subledger Accounting Methods, for example Standard Accrual. If you want to change the accounting rules then you can copy the seeded method and create your own Subledger Accounting Method.

So now all of the subledgers create accounting in the same consistent way, with the ability to do online accounting for a transaction or to submit a standard request to account for all transactions in a module. You can create draft accounting, useful if you are playing with the rules, or if you wish to review before posting. Final Accounting which is complete and ready to post to GL or Final Post, which is complete and will post in GL.

Once data is posted to GL, there’s a full audit trail with drilldown all the way to the actual subledger transaction. Come along to the R12.x Oracle Subledger Accounting Fundamentals class to learn more about this and other features of SLA or send me an eMail with any questions:


About the Author:

Chris Rudd joined Oracle in May 1999. She is a Principal Training Consultant at Oracle University. Using her detailed product knowledge Chris delivers both In Class and Live Virtual Class courses for the Oracle E-Business Suite Financials and Oracle Fusion Financial products

Monday Jan 20, 2014

Description of the Business Object component within Oracle Siebel CRM / Oracle Siebel 的业务对象(BO)说明

Read in Chinese

Description of the Business Object component within Oracle Siebel CRM

Oracle Siebel CRM is a mainstream Customer Relationship Management (CRM) software package within the current global market. Providing a very comprehensive solution, Oracel Siebel defines its objects by three main levels of technical implementation.

BO (Business Object) in the business level is quite interesting. In reality, a single business component (BC) cannot describe an actual business comprehensively. Therefore, the system has introduced the concept of Business Object to link various Business Components together, to fully represent an actual business. Looking at an example of a Business Component - “Opportunity”: in order to fully understand a business opportunity, we have to take into consideration the Account, Contact and Action that are associated with the business opportunity. Therefore in technical implementation, it is the Business Object that has linked all these different components together.

In this scenario developed around Opportunity, Opportunity is the Parent Business Component, with Account, Contact and Action that describe the Opportunity as Child Business Components. This has formed a multidimensional technical model centered around Opportunity. Its technical implementation can be illustrated as below:

Link is implemented by primary key/foreign key relationship.

Wang Zeyi: Senior training lecturer in Oracle University. Wang has engaged in the CRM field for a long time, including experience in CRM pre-sales, research, business analysis and technical implementation among various industries such as financial service, Hi-tech, telecommunication and automobile. He is mainly in charge of training courses on Oracle Siebel CRM and Oracle Fusion CRM.

Oracle Siebel 的业务对象(BO)说明

Read in English

Oracle Siebel CRM 软件是当今全球主流客户关系管理软件。具有非常完善的解决方案。其技术实现中的对象定义分为三个主要层面。

其中业务层中的业务对象也就是英文所说的BO,比较有特点。因为,在实际业务中一个单独的业务组件 (BC)无法全面描述一个实际业务。所以引入业务对象 (BO) 来关联多个业务组件 (BC),来描述具体的一个实际业务。例如:商机 (Opportunity)这个业务,在实际工作中要想全面了解一个商机,必然要查看这个商机相关的客户 (Account),联系人(Contact),操作 (Action)。这时技术实现中用到的就是业务对象 (BO) 来将这些不同的对象关联到一起。

这样这个场景中处于中心地位的商机 (Opportunity) 作为父业务组件 (BC),而作为商机描叙性信息的客户 (Account),联系人(Contact),操作 (Action) 作为子业务组件存在。形成一个以商机 (Opportunity) 为中心的多维描述的技术模型。至于技术实现就比较容易如下图:


王泽义 甲骨文大学高级培训讲师。长期从事客户关系管理 (CRM) 相关工作,参与过金融服务、高科技、通信、汽车等多个行业的 CRM 售前、调研、业务分析和技术实现。主要讲授 Oracle Siebel CRM 和 Oracle Fusion CRM 方面的培训课程。

Expert trainers from Oracle University share tips and tricks and answer questions that come up in a classroom.


« January 2014 »