Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

TCA in EBS: Integration with HRMS

Posted on October 23rd, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

dgreybarrowHRMS Integration with TCA - Concept

When the CRM Application were incorporated into EBS , there was a need to manage the relationships within the trading community of the corporation from one standard model. that why Oracle came with a complete suite of integrated modules that cover the front to back end office operation in its entirety, and therefore could uniquely provide a ‘Single Source of Truth’ mostly meant for customer information. That means , a customer record is the exact same record whether it is viewed through Oracle Sales Online, Oracle Marketing Online, Oracle Customer Care, Oracle Financials, or iStore.

The concept of ‘Party’ enables the Customer Model to treat all business entities equally. This means that regardless of the type of customer (i.e., organizations, people, groups, or relationships), each customer is handled in the same way by the data model.

As HRMS is the main application for the management of people in the e-Business Suite, it is also responsible for maintaining a corporate record of each person which is held in TCA. This corporate person record not only provides a central source of data for those applications that require basic access to the people of the enterprise, but also links all the local records for a person within Oracle HRMS itself . For example , in a Global Enterprise, a person may need to be transferred between business groups to work temporarily in other countries. That will mean records will exist for the same person in different business groups but which are identified by a common party_id linked to the corporate record in TCA.

HRMS only maintains the Person entity in TCA. It does not maintain Organizations or Locations.

dgreybarrowTCA in R12: Integration with HRMS

  • Similar to 11i , TCA create and have the global view of person
  • TCA enables you to store person Information at a corporate level Person is stored as party in TCA
  • Comprehensive duplicate person check when entering a new person – Across the business group
  • Propagate some information entered in one business group to the record in the other business group
  • PER_ALL_PEOPLE_F.PARTY_ID is a foreign key to the HZ_PARTIES table, an integral part of Oracle's "Trading Community Architecture" (TCA).

Hope this helps.

Posted in Oracle TCA | No Comments »

Right tool for the right Financial Reporting

Posted on October 21st, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is summary of few Financial reports (Opertional, Analytics, Executive Reports, Financial Reports, ‘What If’ Scenario Modeling of Financial Data
, KPIs , Dashboard, managment reporting and SEC specfic ) for best avaiablity in Right tool for the right report.

 

Type of Report Type EBSOracle (FSG or Custom)
Essbase HFM OBIEE

Profit & Loss

Yes

Yes

Yes

Balance Sheet

Yes

Yes

Variance (Act v Bud)

Yes

Alternate Hierarchies

Yes

Trial Balance

Yes

Yes

Cash Flow

Yes

Finance KPI

Yes

Real-Time (Transactional & Summary)

Yes

Yes

Sub-Ledger Detail

Yes

Yes

GL Detail

Yes

Yes

Budget, MYF, LY Forecast

Yes

Oracle Definitions for each reporting tool

  1. Hyperion/Essbase is the market-leading OLAP server for interactive, forward-looking analytics at the speed of thought. Essbase provides rapid modeling of alternative scenarios and streamlines the forecasting, and variance analysis process.
  2. Oracle Business Intelligence (OBIEE) is a comprehensive business intelligence platform that delivers a full range of capabilities—including interactive dashboards, ad hoc queries, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, search and collaboration, mobile and disconnected analytics, integrated systems management and more.
  3. Oracle FSG is a powerful report building tool used to generate financial statements for every segment of the business, real time. It uses security rules to provide only the data that each business segment should see, and provides full drilldown to transaction level detail.

Posted in Oracle General Ledger | No Comments »

API’s availability in Oracle Service Contracts(OKS)

Posted on October 20th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

dgreybarrow Contract Header Creation : For creating contract header API is:OKS_CONTRACTS_PUB.CREATE_CONTRACT_HEADER

dgreybarrow Line Creation : You creating lines you can this api OKS_CONTRACTS_PUB.CREATE_SERVICE_LINE

dgreybarrow Sub Line Creation : This is important when underline item is IB track able then we can create covered product sub line with IB link established. API you can use is: OKS_CONTRACTS_PUB.CREATE_COVERED_LINE

dgreybarrow UPDATING CONTRACT HEADER - You can use okc_contract_pub.update_contract_header API to Update contract Header

okc_contract_pub.update_contract_header
( p_api_version => 1.0,
p_init_msg_list => okc_api.g_true,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_restricted_update => okc_api.g_false,
p_chrv_tbl => l_chrv_tbl_in,
x_chrv_tbl => l_chrv_tbl_out);

dgreybarrow UPDATING CONTRACT LINE - You can use okc_contract_pub.update_contract_line API to Update contract Lines

okc_contract_pub.update_contract_line (
p_api_version => 1,
p_init_msg_list => OKC_API.G_TRUE,
p_restricted_update => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_clev_tbl => l_clev_tbl,
x_clev_tbl => l_x_clev_tbl
);

dgreybarrow CASCADE DATE -You can use oks_bill_sch.cascade_dates_sll to cascase date in billing agreement(schedule). You just need to pass only the contract line ID

oks_bill_sch.cascade_dates_sll
(
p_top_line_id => <OKS Contract Line ID>,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);

dgreybarrow DEFAULTING ATTRIBUTES FROM LINES TO SUBLINES : You can use below API for daulting attributes

oks_attr_defaults_pvt.default_lines_to_sublines
(
lines_sublines_tbl => l_line_table,
x_return_status => l_return_status,
x_msg_tbl => l_msg_tbl
);

dgreybarrow CREATING CONTACT AT CONTRACT HEADER LEVEL :You can use okc_contract_party_pub.create_contact to create contact at header.

okc_contract_party_pub.create_contact (
p_api_version => 1,
p_init_msg_list => fnd_api.g_true,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ctcv_rec => l_ctcv_rec,
x_ctcv_rec => l_x_ctcv_rec
);

dgreybarrow UPDATING CONTACT AT CONTRACT HEADER LEVEL :You can use okc_contract_party_pub.update_contact to create contact at header.

okc_contract_party_pub.update_contact (
p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ctcv_rec => l_ctcv_rec,
x_ctcv_rec => l_x_ctcv_rec
);

dgreybarrow CREATING CONTACT E-MAIL ADDRESS AT CONTRACT HEADER LEVEL :You can use OKS_EXTWAR_UTIL_PUB.Contact_Point to create contact at header.

OKS_EXTWAR_UTIL_PUB.Contact_Point (
p_api_version => 1,
p_init_msg_list => 'T',
P_commit => 'F',
P_contact_point_rec => l_cpoint_rec,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_contact_point_id => l_x_contact_point_id
);

dgreybarrow Sales Credit : For creating sales credit separately, we will have to use API:OKS_SALES_CREDIT_PUB.INSERT_SALES_CREDIT.

Posted in API Integration, Service Contracts | No Comments »

First Day of The Week Support

Posted on October 9th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is New feature in 12.1.2 Release, that means user in countries where Sunday is not the first day of the week can now choose their preferred first day of the week. This is achieved via a new system profile option that can be set at the site, application, responsibility and user levels

FND: Calendar Week Start Day

This profile changes first day of the week of Oracle Application Framework and Forms date pickers only, but does not affect business logic or reports

Posted in AOL | No Comments »

Page 1 of 11