Oracle Apps R12 Techno - Functional: Oracle 10g Installation Guide

Oracle Apps R12 Techno - Functional: Oracle 10g Installation Guide: http://students.heinz.cmu.edu/docs/Oracle_10g_Installation.pdf

Oracle 10g Installation Guide

http://students.heinz.cmu.edu/docs/Oracle_10g_Installation.pdf

Define Subinventory

Define Subinventory:

Subinventories 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 a subinventory therefore, 

you must define at least one subinventory.

Navigation : Inventory Responsini

Define Grouping Rules in Oralce apps

Define Grouping Rules

Navigation :Accoutions Recivables Manager -->setup -->Transactions -->AutoInvoice-->Grouping Rules

Grouping rules specify attributes that must be identical for lines to be created as one transaction. Grouping rules always include the mandatory attributes, and to this is added optional attributes that you define in the grouping rule.

Grouping rules tell AutoInvoice how you want to group records in the interface tables into invoices, debit memos, and credit memos. Grouping rules specify which attributes must be identical for lines to appear on the same transaction.

In the figure below, the grouping rule specifies that items must have the same currency, Bill-To address, and Order Type to appear on the same invoice. Items A and B share the same currency and Order Type, so they appear on the same invoice (Invoice 1). Item C has the same currency as A and B, but it has a different order type, so it appears on its own invoice (Invoice 2). Items D and E share the same currency and Order Type, so they appear on the same invoice (Invoice 3).

Responsibility: Receivables Manager
Navigation: Setup > Transactions > AutoInvoice > Grouping Rules

Concurrent Program and Executable Details

SELECT b.user_concurrent_program_name, b.concurrent_program_name,
 APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US',
a.user_executable_name,
DECODE (a.execution_method_code,
'I', 'PL/SQL Stored Procedure',
'H', 'Host',
'S', 'Immediate',
'J', 'Java Stored Procedure',
'K', 'Java concurrent program',
'M', 'Multi Language Function',
'P', 'Oracle reports',
'B', 'Request Set Stage Function',
'A', 'Spawned',
'L', 'SQL*Loader',
'Q', 'SQL*Plus',
'E', 'Pearl concurrent Programm',
'Unkown Type'
) TYPE,
a.execution_file_name, a.execution_file_path, a.application_name,
c.basepath
FROM fnd_executables_form_v a,
fnd_concurrent_programs_vl b,
fnd_application c
WHERE a.application_id = c.application_id
AND a.executable_id = b.executable_id
AND a.application_id = b.application_id
AND a.executable_id > 4
AND b.user_concurrent_program_name LIKE '%Aging%';

Assigned user with respective responsibility

SELECT FURGA.USER_ID
, FU.USER_NAME
, FURGA.RESPONSIBILITY_ID
, FRTL.RESPONSIBILITY_NAME
, FURGA.RESPONSIBILITY_APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
, FURGA.SECURITY_GROUP_ID
, FSG.SECURITY_GROUP_KEY
, FURGA.START_DATE
, FURGA.END_DATE
, FURGA.CREATED_BY
, FUCB.USER_NAME
, FURGA.CREATION_DATE
, FURGA.LAST_UPDATED_BY
, FULUB.USER_NAME
, FURGA.LAST_UPDATE_DATE
, FURGA.LAST_UPDATE_LOGIN
, FULUL.USER_NAME
FROM
FND_USER_RESP_GROUPS_ALL FURGA,
FND_USER FU,
FND_USER FUCB,
FND_USER FULUB,
FND_USER FULUL,
FND_APPLICATION FA,
FND_RESPONSIBILITY_TL FRTL,
FND_SECURITY_GROUPS FSG
WHERE
FURGA.USER_ID = FU.USER_ID (+)
AND FURGA.CREATED_BY = FUCB.USER_ID (+)
AND FURGA.LAST_UPDATED_BY = FULUB.USER_ID (+)
AND FURGA.LAST_UPDATE_LOGIN = FULUL.USER_ID (+)
AND FURGA.RESPONSIBILITY_APPLICATION_ID = FA.APPLICATION_ID (+)
AND FURGA.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_ID (+)
AND FRTL.LANGUAGE = 'US'
AND FURGA.SECURITY_GROUP_ID = FSG.SECURITY_GROUP_ID (+)
ORDER BY START_DATE;

Hierarchial query example in oracle or CONNECT BY PRIOR or LEVEL or Start with

http://welcometooracle.wordpress.com/2012/10/18/hierarchical/