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

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…


Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…


Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…


Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…


Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service