Oracle Apps

Showing posts with label Oracle apps. Show all posts

Oracle Apps R12 - Order Management Tables and Description

The blog post details all the tables in Order management:

Table Name

Description

OE_ACTIONS_IFACE_ALL

This is the open interface table for Order Management action requests. User can populate this table with data to perform a variety of actions such as booking, hold application and removal, automatic attachments, fulfillment set application and removal, match and reserve for Configured items, get ship method and freight rates (both individually and together), and the linking and delinking of Configured items.

Dates in Oracle Applications

There are two main ways that dates are stored in the applications: as character strings or as binary, Julian dates. Dates, both as character strings and as Julian dates, are used in various places in the applications, including database tables, C and Pro*C code, PL/SQL versions 1, 2, and 8, concurrent programs, Oracle Reports, Java code, flexfield columns, form fields, and profile values.

Before continuing the discussion of how dates are used in Oracle Applications, it is helpful to establish some definitions.

How to invoke a calendar in a form

You can enter a value directly to a date field or use the calendar facility in APPS. Calendar lets you the following needs.

· Represent date and time graphically so that you can make a quick selection without typing.

· Select only those dates or date ranges that are suitable for the current field.

How to invoke a calendar in a form.

Write and Get Paid at Oracleapps4u

Start sending your writings to Oracleapps4all@gmail.com

All you need to do is, submit 10 posts on various topics related to Oracle apps.

Once you have sent your post content, our team will review your writings. You will be paid for all your approved posts.

Conditionally disable DFF components in Oracle apps

A frequent requirement in most Oracle Applications implementations is to be able to conditionally disable one of the components of a Descriptive Flexfield (DFF). DFFs follow the “all or none law” for a given DFF context. If a DFF is displayed, it is enabled and can be changed. The only exception to this rule is when the entire record is read-only. However, if your DFF is using five attributes, there is no mechanism to disable one attribute out of the five attributes. Also, since the DFF window is a user exit call, you cannot disable any attribute field by using set_item_property. We’ll show you how to protect DFF using CUSTOM.pll.

Qualifiers

Qualifiers control who receives benefits. They can assign discounts and promotions to:

Specific customers
Customer groups
Order types
Order amount
Specific customer or group of customers

This blogpost lists the predefined Oracle Pricing Lookups.

Agreement Type

Access Level: Extensible

Allows the user to optionally categorize agreements by defining unique agreement types. For example, the user could setup an agreement type per contract type, or use the categorization for reporting purposes. An agreement type is optional on a pricing agreement.

The user can choose to use the seeded agreement types or add new types.

The following table lists the default (seeded) values for this lookup type.

Oracle Apps Order Management - Overview of Price Lists

Price lists are essential to ordering products because each item entered on an order must have a price. Each price list contains basic list information and one or more pricing lines, price breaks, pricing attributes, qualifiers, and secondary price lists. Basic information includes the price list name, effective dates, currency, pricing controls, rounding factor, and shipping defaults such as freight terms and freight carrier.

How to Create a user in Oracle Apps

Open the Windows Internet Explorer

And select the URL of the application server say: http://nivasr12.apps.com:8005/

Oracle Order Management Item Orderability rule in R12

There is a new interface provided by oracle to define rules to restrict certain kind of items to be ordered based on certain rules / criteria.

Example:

Customer A may purchase all items except for repair items and promotional items.

Alternatively, Customer B buys only repair parts but is restricted from buying promotional items.

Overview of Oracle Apps Purchasing

Oracle purchasing is a comprehensive procurement solution designed to:

o Help purchasing professionals reduce administration costs.

o Process requisitions, purchase orders, requests for quotation, and receipts quickly and efficiently.

o Enable you to focus on:

AutoInvoice Program Overview in Oracle Applications – Receivables

AutoInvoice Overview

AutoInvoice is a powerful, flexible tool you can use to import and validate transaction data from other financial systems and create invoices, debit memos, credit memos, and on-account credits in Oracle Public Sector Receivables. You use a custom feeder program to transfers transaction data from an external system into the AutoInvoice interface tables. AutoInvoice then selects data from the interface tables and creates transaction in Receivables. Receivables rejects transactions with invalid information to ensure the integrity of your data.

We have reached a new milestone - 100 Facebook likes

Hurray!!! We’ve reached a new milestone. We have now 100 facebook page likes for OracleApps4u.

How to prepare for an oracle apps interview

Preparation for an interview is very important. Even your dressing and appearance counts. I have few tips which could help you get some edge in your interview.

Oracle Apps DBA Interview Questions

1. Explain the difference between a hot backup and a cold backup and the benefits associated with each?

Oracle Apps Data Migration Strategy

In Data migration different types of data is migrated. It may be some transactional data or master data. The process of migrating data can be broken down into a series of well-defined atomic level tasks. Data migration is not a single activity. It is composed of different stages. All these stages will be discussed further in the document.

Key Flexfields in Oracle Applications

The Oracle Applications products provide many key flexfields as integral parts of the products.
Here is a table listing all the key flexfields in Oracle Applications, ordered by the application that ”owns” the key flexfield. Note that other applications may also use a particular flexfield.

Oracle Apps training videos

Following are some of the oracle apps training videos available for learning:

Create PO Requisition:

Create RFQ:

Blanket PO:

Blanket release:

BOE Invoice:

Auto Create PO:

AR Transaction Training:

AR Single Receipt for Multiple OU3:

AR Creation of Manual Debit Memo:

AR Auto Invoice Training:

OAF Personalization

AR Bills Receivable Training:

Useful oracle apps queries/ scripts/ codes/ tips

Visit our new blog: Oracle apps scripts and tips

I am working on this blog post. For now i have placed only few scripts. Keep checking this post for further updates:

My 100th Blog Post

Hi every one. With this blog entry i have completed 100 Blog posts in the cloud. It all started 4 months back. I’ve shared lots of information & enjoyed doing so. Thanks to all those who have encouraged me by posting their valuable suggestions / comments on my posts. Happy learning.

PAGES

Pages