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

Oracle Fixed Asset:Security by Book

Posted on June 13th, 2008 by Sanjit Anand ||Email This Post Email This Post

You can manage your Asset Book Security, as mention in one of last post.This Functionality you can

  • Secure access to each depreciation book
  • Create a flexible hierarchy of asset organizations
  • Associate a responsibility with one or more depreciation books

Asset Book Security allows multiple asset books/registers to be manage/administered independently.

Read the rest of this entry »

Posted in Oracle Asset | 4 Comments »

FNDLOAD for AME’s

Posted on June 12th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle Approvals Management (AME) is a self-service Web application that enables users to define business rules governing the process for approving transactions in Oracle Applications .This enables development of custom rules to manage transaction approvals that is integrated with multiple Oracle EBS applications such as HR, PO, AP and UMX.

If you want to migrate the AME setup like rules,conditions,approval groups etc. from one instance to another instance, you can use some of them by mean of FNDLOAD utility. The process is similar to what we are regularly using for other AOL Objects.

FNDLOAD will have such ldt file through which you can use.

list

You should read the lct first before using any FNDLOAD Command. In the lct, there is an Entity section, where the Entity details are mentioned.Newcomer in OracleApps if you are not familiar with lcts, i would suggest you to go through the DOWNLOAD section and find the bind variables, which are mandatory.

Here are the details steps for each setup’s availability till date.

Read the rest of this entry »

Posted in AOL | 10 Comments »

Migration of XMLPub Templates :XDOLOADER Utility

Posted on June 11th, 2008 by Sanjit Anand ||Email This Post Email This Post

As it is well known fact that XMLPublisher stores the metadata and physical files for templates and data definitions in BLOB columns in its schema. During Development you need to download information from a development instance to a test instance before porting over to production environment.These steps you normally follow:

  • Use the FNDLOAD utility to upload and download the data definition information and the template metadata stored in the Template Manager.
  • Use the XDOLoader utility to upload and download the physical files (RTF, PDF, XSL-FO, XML, and XSD).

dgreybarrowUsing FNDLOAD to Manage Metadata

As per user guide,both templates and data definitions are stored in the database, therefore we can use the FNDLOAD loader to download the metadata for these objects and then to upload this metadata to another instance. The FNDLOAD program requires a control file (lct) as discussed earlier that XML Publisher provides for use with its objects. The file which is used called xdotmpl.lct and it is located under your APPL_TOP directory as follows:

XDO_TOP/patch/115/import/xdotmpl.lct

Read the rest of this entry »

Posted in Emerging Technologies | 3 Comments »

“Record History” Utility in 11i

Posted on June 7th, 2008 by Sanjit Anand ||Email This Post Email This Post

Do you know “Record History” utility in the Oracle EBS forms interface where every form block have, where a user simply has to have their cursor in the target data, and then from the command menu, select “Help, Record History” .

This is very old offering in application Release 9, and have evolved to a useful utility in the Release 11i version of the e-Business Suite. From many of the Professional forms that display a data record (not find windows, for example), a user can click on “Help” in the command menu bar, and then select “Record History”.

When you click, the resulting pop-up window will provide two general areas of information. The user audit information from the database table is presented, including the

  • CREATION_DATE Date and Time row was created
  • CREATED_BY Oracle Applications user ID from FND_USER
  • LAST_UPDATE_LOGIN Login ID from FND_LOGINS
  • LAST_UPDATE_DATE Date and Time row as last updated
  • LAST_UPDATED_BY Oracle Applications user ID from FND_USERS

This information can be easily accessed through the application or SQL. Within the applications, select Help > Record History from the main menu to view the information for the current record.

These fields are typically called as “WHO” columns , they are a standard on nearly every Oracle application database table.

The second piece of useful information is the “Table Name” value for the primary table that stores the data on this form. This is sometimes a Database Table, and can also be a View.

This utility did not function on certain very complex forms, where multiple blocks displayed data from a variety of tables. In this case, a user might be presented with a message the “Record History is not available”.

Posted in AOL | No Comments »

Next Entries »