July 2008 Blog Posts (16)

Discovering the details about user-defined collection types

While experimenting with some of the internals in the XDB schema, I needed to discover whether some of the XDB collection types were varrays or nested tables. It was tedious, so I wrote a script to discover the type of collection, the base type of the collection, and the limit of varrays. It creates a SCHEMA_COLLECTION_TYPES view.

If you're interested in discovering collection type details too,… Continue

Added by Michael McLaughlin on July 30, 2008 at 11:03pm — No Comments

Oracle APS R12.1 : Service Parts Planning (SPP)

In this blog I would try to share my exposure on Oracle's new release Service Parts Planning, based on a recent Oracle Webcast.

Oracle's R12.1 APS suite has a new product in offering "Spare/Service Parts Planning", which is focused to answer the need of an advanced, automated, exception based planning application of Service industry. Sectors which can highly benefit from Service Parts Planning are Industrial Manufacturing, Aerospace, High Tech & OEMs. As volume of spares in these… Continue

Added by Rajkumar Singh on July 29, 2008 at 11:30pm — No Comments

Mostly asked questions in Account Payables Modules

Mostly asked questions in Account Payables Modules

Hello, Some of the very much interview oriented, one of mostly asked questions in Account Payables Modules. here they are

Questions: How many types of Invoices in Oracle Account Payables

1)Standard Invoice

2)Debit Memo

3)Credit Memo

4)Withholding tax invoice5)PO Default

6)Prepayment Invoice

7)Expense Reports

8)Recurring Invoices

9)mixed Invoices

Question :How many… Continue

Added by Shivmohan Purohit on July 29, 2008 at 10:00pm — No Comments

Demantra Predictive Trade Planning & Promotion Optimization

Demantra's PTP & TPMO module focuses on Consumer Good industry's requirement for trade promotions and account planning, sales forecasting, and promotions optimizations. The module is build on top of basic Demand Management module and utilizes various components of Demand planning function. Few of the important features can be listed as:

* Lift generation on top of Baseline forecast when engine is run in Promotion Effectiveness (PE) mode

* Promotions Planning & Analysis,… Continue

Added by Rajkumar Singh on July 28, 2008 at 10:27am — No Comments

Serial Number Generation

Serial generation in Oracle Apps is based on the parameters defined for an Organization:

* Serial Uniqueness

o Within organization: Enforce unique serial numbers within the current organization

o Within inventory model and items: Enforce unique serial numbers for inventory items

o Across organizations: Enforce unique serial numbers throughout all organizations

* Serial Generation

o At organization level: Define the starting prefix… Continue

Added by Devendra Gulve on July 28, 2008 at 7:45am — No Comments

Form Personalization in Oracle Applications

courtesy: http://knoworacle.wordpress.com/

Form Personalization in Oracle Applications

These days Form personalization is keyword and almost all developer and analyst working in oracle application must be aware and conversant with feature and how-to use this. I recommend to have good amount of practice on this. here i am presenting very brief overview and like to know if it useful need kind of tutorial kind of… Continue

Added by Shivmohan Purohit on July 28, 2008 at 2:39am — No Comments

Oracle Demantra: Seeded EBS-DM integration data flow

Oracle's seeded Demantra integration with Demantra's Demand Management module can be utilized with ease to empower an organization with a collaborative, web based, integrated demand planning environment.

In EBS-DM integrated environment, one can start the process of demand planning, with responsibility "Demand Management System Administrator".… Continue

Added by Rajkumar Singh on July 26, 2008 at 11:00am — No Comments

Demantra 7.2.1 Release

Oracle released another major Demantra release recently, integrating the Israeli product more with existing acquisitions and new product releases. This release clearly indicates that going forward Demantra will be a core part of APS suite in Fusion, with quite a few major integrations already in market. Demantra's first integration release was with Demantra Demand Management module, Oracle EBS 11i suite and Enterprise One, this was followed up with Demantra's 7.2 release which was Demantra's… Continue

Added by Rajkumar Singh on July 25, 2008 at 11:00am — No Comments

Overview of Concurrent Programs and Requests

A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program is a long-running, data-intensive task, such as posting a journal or generating a report.

Request Groups and Request Sets

Reports and concurrent programs can be assembled into request groups and request sets.

o A request group is a collection of reports or concurrent… Continue

Added by Shivmohan Purohit on July 24, 2008 at 10:15pm — No Comments

How I came to Know about Oracle Community?

Well, Its from OTN by a thread posted by APC on Feb 6 2008 about Oracle Community.
And I recommended few of friends as well to join this!

Ravi Prakash

Added by @Ravi on July 24, 2008 at 9:00am — No Comments

Query to find the responsibility, where the concurrent program can be run.

This sql will take Concurent Program name as a parameter:

FROM fnd_responsibility
WHERE request_group_id IN (
SELECT request_group_id
FROM fnd_request_groups
WHERE request_group_id IN (
SELECT request_group_id
FROM fnd_request_group_units
WHERE request_unit_id = (select CONCURRENT_PROGRAM_ID from fnd_concurrent_programs where user_concurrent_program_name like :p)))

Added by Srinivas on July 24, 2008 at 4:15am — 1 Comment

Query to find the table dependencies.

This query will take table name as Parameter:

SELECT owner, object_type, object_name, object_id, status,

DECODE (REPLACE (object_type, ' ', '_'),


REPLACE (object_type, ' ', '_')

) type_link

FROM SYS.all_objects

WHERE object_id IN (

SELECT object_id

FROM public_dependency

CONNECT BY PRIOR object_id = referenced_object_id

START WITH referenced_object_id =

(SELECT object_id

FROM… Continue

Added by Srinivas on July 24, 2008 at 4:00am — No Comments

Know Oracle

plz check



Added by Shivmohan Purohit on July 16, 2008 at 8:45am — No Comments

Oracle 11g, EMCA, and Windows - a leathal combo

I went too fast and installed Oracle Database 11g into a new Windows XP x64 virtual machine. I forgot to change the automatically generated hostname. It was a trade-off whether the time to rebuild the VM was less than fixing the Oracle Enterprise Manager. When you change the Windows hostname, you must drop and recreate the Enterprise Manager Repository, update the listener files, hostname, and hosts file.

I found it wasn't as clean as I thought when cruis'n down the street. That's… Continue

Added by Michael McLaughlin on July 13, 2008 at 1:30pm — No Comments

Background Process is killed with Error ORA-01562

Oracle Database 10g Enterprise Edition Release - 64bit Production

With the Partitioning, OLAP and Data Mining options

ORACLE_HOME = /opt/oracle/product/

System name: HP-UX

Node name: NODE_NAME>>

Release: B.11.11

Version: U

Machine: 9000/800

Instance name: ORACLE_SID>>

Redo thread mounted by this instance: 1

Oracle process number: 19

Unix process pid: 10514, image:… Continue

Added by Mahantesh on July 9, 2008 at 11:36pm — No Comments

Oracle Text, Lexers, and Formatting a STOPLIST

I posted an entry that shows you how to get the formatted words excluded by a STOPLIST in Oracle Text. I also took a shortcut and tripped an error linked to permissions. When I google’d it, I found there wasn’t a complete answer out there, so I put one here (at least it is a start).

Added by Michael McLaughlin on July 6, 2008 at 8:45pm — No Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …


Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.

Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…


Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…


Posted by Alvaro Dee on April 3, 2017 at 3:23am

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service