Entries by Oracle ERP Apps Guide

, ,

R12 – How to Create Category and Category Set in Oracle Inventory

Categories are the method by which the items in inventory can be separated logically and functionally for planning, purchasing and other activities.You can use categories and category sets to group your items for various reports and programs. A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping […]

, , , , , ,

How to Create and Register a Concurrent Program using SQL*Loader

When building customization’s for the Oracle E-Business Suite it might be needed to load data from external sources into specific tables. Tables might be seeded tables, i.e. Open Interface tables, or custom tables which you’ve added to a special customization’s database schema.To load data from external sources into Oracle eBS you might consider using SQL*Loader to accomplish this. SQL*Loader […]

, , ,

R12 – FND – Script to add responsibility using fnd_user_pkg with validation

Some times we don’t have the access to add the responsibility to the user using the the Create User form. So for this Oracle is having one API fnd_user_pkg.addresp which can do the job without using the Create User Form. R12 – FND – Script to add responsibility using fnd_user_pkg with validation DECLARE v_user_name   […]

, ,

How to Implement Bar Code in XML Publisher Report

Bar Code Local Setup:1) Copy Barcode font in C:WindowsFonts directory.2) Copy xdo.cfg in C:Program FilesOracleXML Publisher DesktopTemplate Builder for Wordconfig directory. The sample file is already available when BI Publisher desktop is installed.3) Right click the font file and go to properties. Copy the .ttf file name. Double click the font file to get the […]