Oracle EBS R12: Archive of useful Standard DB Objects

The purpose of this post is to pool together useful seeded Oracle db objects that may help you for multiple purposes (Reporting, Queries, Data Extraction, Personalizations etc.).

Continue reading


Oracle EBS R12: Grey out Descriptive Flexfield Segment (DFF)

The purpose of this article is to demonstrate on the technique to grey out a Descriptive flexfield (DFF) segment.

You may require to Grey out / Restrict entry in a DFF segment to serve any possible purpose in your business process mapping in any form of Oracle.

Continue reading

Oracle EBS R12: How to create WebADI Integrator & Upload Customers through WebADI

This post will provide you with the complete detailed method on how to Create a WebADI Integrator and to upload Customers into your Oracle EBS R12 instance through WebADI.

A complete functional solution to uploading customers, no IDs required whatsoever. Just enter all the functional data available to you (that the WebADI demands for uploading customers) and the WebADI will do the rest for you.

Continue reading

Oracle EBS R12: Extract a Complete Menu, its Functions and Sub-Menus via SQL

The following query will extract all the functions, Sub-Menus & the functions & sub-menus within the above sub-menus on a single sheet.

Creating restricted responsibilities for users may require condensed Menus with fewer functions & sub-menus. Creating such menus can become very hectic by navigating in and out of the seeded menus to pick the right functions and sub-menus to include.

Continue reading