8/3/2019 Oracle Apps Basic Info

1/2

Oracle Apps Basic Info:

Sub Inventory: Sub inventories are unique physical or logical separations of material inventory, such as

raw inventory, finished goods or defective material. All material within an organization is held in sub

inventory, so you need to define at least one sub inventory.

Locator: To identify physical areas where you store inventory items. Item quantities can be tracked by

locator

Routing: Assembling the component, Different processes/activities/operations you need to perform to

manufacture the product/sub assembly

Schedule Group: A schedule group is group of flow schedules and discrete jobs which can be sequenced

for the purpose of giving priority. Schedule groups are defined in the Define Schedule Groups window

and can be optionally assigned to jobs, in the Discrete Jobs window, or to Flow schedules, in the Line

Scheduling Workbench Options window. Sequencing is done by assigning a unique schedule number to

each job or flow schedule with in a schedule group.

Delete Concurrent Program: From front end we can not delete the concurrent program. We can only

enable or disable the program.

We can delete the concurrent program from back end.

fnd_program.delete_program('Short Name', 'Application');

fnd_program.delete_executable('Short Name', 'Application');

Add Program to request group from Back end:

DECLARE

BEGIN

FND_PROGRAM.add_to_group

(

PROGRAM_SHORT_NAME =>CUST_XML_SAMPLE

,PROGRAM_APPLICATION =>AR

,REQUEST_GROUP => Receivables All

,GROUP_APPLICATION =>AR

) ;

commit;

exception

when others then

dbms_output.put_line(Object already exists);

END ;

8/3/2019 Oracle Apps Basic Info

2/2

Remove program from request group:

Begin

Fnd_prorgam.remove_from_group(Conc Prog Short name,Appl Short Name,Request Group,Group

Appl);

End;

Commit;