Oracle Apps: 2015

Sunday, 11 January 2015

Oracle Apps Interview Question

Oracle Apps Interview Question

---------------------------------------------------------

1. Multiple template (Sub template) how can call in xml and RDF ?

2. how to change the different logo based on organization for single report in RTF level?

3. how to send the report out to mail ?

4. What is pragma autonomous_transaction ?

5. Sequence of triggers in form ?

6. what is the API / function conversion from number to word ?

7. how can change the language from English to Arabic ?

8. how can print the amount in words in Oracle Apps ?

CRM interview Question in Oracle Apps

CRM Interview Question in Oracle Apps

---------------------------------------------------------------

1. Explain the usage of customizing includes in the business transaction in Oracle Apps ?

2. Explain the BADI framework for the business transaction ?

3. How are model access classes assigned in Oracle Apps?

4. What is the PCUI cookbook?

5. Explain the usage of the CRMV_EVENT framework in Oracle Apps ?

6. What is the GUID Concept in CRM and explain how it is used?

7. Explain the general ways of how a CRM can be enhanced?

8. What is the Easy Enhancement Workbench in Oracle Apps?

9. What are the limitations of the EEWB?

10.What tools are available to import/export data from a CRM system?

11.What function does the CRM middleware perform in Oracle Apps?

12.Explain the CRM One Order concept, and logical structure of a business transaction

13.List the primary header table for a CRM business transaction in Oracle Apps ?.

14.List the primary extension tables for CRM business transactions in Oracle Apps ?

Thursday, 8 January 2015

Oracle Apps FND Download Script

ORACLE Apps FND_DOWNLOAD Command

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---- Function Down load -----------------------------

FNDLOAD apps/Bs0r12 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXPCL_BO_AGENCY_TRANSFER_FUNC.ldt FUNCTION FUNCTION_NAME="XXPCLBO0083" APPLICATION_SHORT_NAME="XXBO"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXPCL_BO_AGENT_TERMINATION_FUNC.ldt FUNCTION FUNCTION_NAME="XXPCLBO0031" APPLICATION_SHORT_NAME="XXBO"

-----------------------------------------------------

Download the Personalization in Oracle Apps

----------------------------------------------------

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct

XXPCL_BO_AGENT_TERMINAT_PERZ.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME="XXPCLBO0031" APPLICATION_SHORT_NAME="XXBO"

FNDLOAD apps/Bs0r12 O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPCL_BO_AGENCY_TRANSFER_PERZ.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME="XXPCLBO0083" APPLICATION_SHORT_NAME="XXBO"

Down load the Concurrent Program lct ( for Report and Concurren Program )

------------------------------------------------------------------------------------------

( Note : for Report download two lct file – 1. Concurrent program and 2. Template )

FNDLOAD apps/Bs0r12 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPCL_BO_PROMOTION_STATUS_REP_CONC.ldt PROGRAM APPLICATION_SHORT_NAME=”XXBO” CONCURRENT_PROGRAM_NAME=” XXPCL Promotion Status Report”

FNDLOAD apps/Bs0r12 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPCL_BO_AUOT_PROMOTION_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XXBO" CONCURRENT_PROGRAM_NAME="XXPCLBO0068"

Download the Template for Report in Oracle Apps

-------------------------------------------------------------------------

FNDLOAD apps/Bs0r12 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXPCL_BO_PROMOTION_STATUS_REP_TEMP.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=”XXBO” DATA_SOURCE_CODE=”XXPCLBO0074”

Down load the Concurrent Program in Oracle Apps

-------------------------------------------------------------------

$FND_TOP/bin/FNDLOAD apps/Bs0r12 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct

XXPCL_BO_BONUS_GENERATION_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XXBO"

CONCURRENT_PROGRAM_NAME="XXPCL BONUS GENERATION"

-----------------------------------------------------

FND_DOWNLOAD Command in Oracle Apps

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---- Function Down load -----------------------------

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxpcl_so_chq_no_alloc.ldt FUNCTION FUNCTION_NAME="XXPCLSO0016" APPLICATION_SHORT_NAME="XXSO"

Down load the lookup in Oracle Apps

----------------------------------------------------------------

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct xxpcl_bo_service_request_lookup.ldt FND_LOOKUP_TYPE LOOKUP_TYPE="XXPCL_SR_SUBCAT_FORM_MAP" APPLICATION_SHORT_NAME ="XXBO"

Download the Personalization in Oracle Apps

------------------------------------------------------

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct xxpcl_bo_cond_prom_perz.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME="XXPCLBO0019" APPLICATION_SHORT_NAME="XXBO"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD aflvmlu.lct XX_TRX_BATCH_STATUS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='XXGMS' LOOKUP_TYPE="XX_TRX_BATCH_STATUS"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt FUNCTION APPLICATION_SHORT_NAME="FND" FORM_NAME="custom_form.fmb"
FUNCTION_NAME="custom_form_function"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct xxpcl_bo_conditional_prom.ldt FUNCTION APPLICATION_SHORT_NAME="XXPCLBO0019" FORM_NAME=" XXPCLBO0019.fmb"
FUNCTION_NAME=" XXPCLBO0019"

FNDLOAD apps/<my_password> O Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct g.ldt MENU_NAME="WIP_OTHER_10G"
FORM_APP_SHORT_NAME="CUSOM_APP" FORM_NAME="custom_form.fmb"
FUNCTION_NAME="custom_form_function"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

Personalization in Oracle Apps: Down load the ldt file from one instance

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt FND_FORM_CUSTOM_RULES function_name="HZ_ARXCUDCI_STD"

in Oracle Apps Up load the ldt file from one instance

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPCL_BO_CONDITIONAL_PROMOTION_PERS.ldt

Oracle Apps FND functions

Oracle Apps FND function

-----------------------------------------------------------------

Call Form from Another Form in Oracle Apps
------------------------------------------------------------

FND_FUNCTION.EXECUTE( FUNCTION_NAME=> ,
OPEN_FLAG=>'Y',
SESSION_FLAG=>'Y',
ACTIVATE_FLAG=>'ACTIVATE',
OTHER_PARAMS=>'P_MP_RANK="'||:BO_SERVICE_REQUEST_BLK.MP_RANK||'"');

FND_GLOBAL.APPS_INITIALIZE(p_user_id, p_resp_id, p_resp_appl_id);

To get the values of
p_user_id,
p_resp_id
p_resp_appl_id

use the following sql from sqlplus as apps user:

Oracle Apps FND Table Name
-----------------------------------------

select application_id, Responsibility_id, responsibility_name
from fnd_responsibility_vl
where responsibility_name like 'your_reponsibility_name'

select user_id, user_name
from FND_USER
where user_name = 'your_user_name'

Oracle Apps Report Initialization
---------------------------------------------------

For example:

exec fnd_global.APPS_INITIALIZE (1271,50243,222);

fnd_global.conc_request_id ----> To get the concurrent Request Id

MO_GLOBAL.init() API to execute the multiple organizations initialization.

The FND_GLOBAL.APPS_INITIALIZE routine does NOT automatically call mo_global.init routine.
You must explicitly invoke the mo_global.init routine to initialize the organization context.

fnd_submit.set_mode
fnd_submit.set_nls_options
fnd_submit.set_repeat_options
fnd_submit.set_rel_class_options
fnd_submit.set_print_options
fnd_submit.add_printer
fnd_submit.add_notification
fnd_submit.set_request_set
fnd_submit.submit_program
fnd_submit.submit_set

How to set org context in Oracle apps R12 and 11i
Set org context in R12
The SQL command to set the ORG_ID prior to running a script is:

SQL> exec mo_global.init('AR');
exec mo_global.set_policy_context('S','&org_id');

Enter the org_id when prompted.
The procedure - mo_global.set_policy_context has two parameters

p_access_mode & p_org_id

p_access_mode Description

S ----- > In case you want your current session to work against Single ORG_ID
M ----- > In case you want your current session to work against multiple ORG_IDs

p_org_id : Only applicable if p_access_mode is passed value of "S"

Oracle Apps Form Property
----------------------------------------------

set_item_property(:system.cursor_item,background_color,1);

SET_ITEM_PROPERTY(':CONTROL.CREATE', FOREGROUND_COLOR, 'red');

Bill of Material ( BOM ) Table Name in Oracle Apps

Some important Tables Joins in Oracle apps WIP, BOM, INV
----------------------------------------------------------
1) BOM in Oracle Apps :
-------------------------------------

BOM_RESOURCES (BR)

BOM_BILL_OF_MATERIALS (BBOM)

BOM_DEPARTMENTS (BD)

BOM_OPERATIONAL_ROUTINGS (BOR)

BOM_OPERATION_SEQUENCES (BOS)

BOM_INVENTORY_COMPONENTS (BIC)

BOM_STANDARD_OPERATIONS (BSO)

2) INV in Oracle Apps :
----------------------------------------------

MTL_PARAMETERS (MP)

MTL_SYSTEM_ITEMS_B (MSIB)

MTL_MATERIAL_TRANSACTION (MTT)

MTL_SERIAL_NUMBERS (MSN)

MTL_ITEM_REVISIONS (MIR)

MTL_ITEM_CATEGORIES (MIC)

MTL_DEMAND (MD)

MTL_TRANSACTION_TYPES (MTTY)

MTL_CATEGORIES (MC)

CST_ITEM_COSTS (CIC)

CST_COST_ELEMENTS (CCE)

3) WIP in Oracle Apps:
---------------------------------------

WIP_PARAMETERS (WP)

WIP_DISCRETE_JOBS (WDJ)

WIP_ENTITIES (WE)

WIP_OPERATIONS (WO)

WIP_REQUIREMENT_OPERATIONS (WRO)

WIP_OPERATION_RESOURCES (WOR)

WIP_TRANSACTIONS (WT)

WIP_TRANSACTION_ACCOUNTS (WTA)

WIP_LINES (WL)

WIP_EAM_WORK_REQUESTS (WEWR)

WIP_EAM_PARAMETERS (WEP)

1) Oracle Apps JOINS IN BOM and BOM - INV
-------------------------------------------------------------------------------------------------------------
BOM_BILL_OF_MATERIALS (BBOM) MTL_SYSTEM_ITEMS_B (MSIB)

organization_id organization_id
assembly_item_id inventory_item_id

MTL_SYSTEM_ITEMS_B (MSIB) BOM_OPERATIONAL_ROUTINGS (BOR)

inventory_item_id assembly_item_id
organization_id organization_id

BOM_BILL_OF_MATERIALS (BBOM) BOM_INVENTORY_COMPONENTS (BIC)

bill_sequence_id bill_sequence_id

BOM_INVENTORY_COMPONENTS (BIC) MTL_SYSTEM_ITEMS_B (MSIB)

component_item_id inventory_item_id

BOM_OPERATIONAL_ROUTINGS(BOR) BOM_OPERATION_SEQUENCES(B0S)

routing_sequence_id routing_sequence_id

BOM_OPERATION_SEQUENCES (BOS) BOM_STANDARD_OPERATIONS (BSO)

standard_operation_id standard_operation_id

BOM_OPEARATION_SEQUENCES(BOS) BOM_DEPARTMENTS (BD)

department_id department_id

BOM_DEPARTMENTS (BD) BOM_DEPARTMENT_CLASSES

department_id department_id
operation_sequence_id operation_sequence_id

BOM_OPERATION_RESOURCE (BORE) BOM_RESOURCES (BR)

resource_id resource_id

BOM_DEPARMTENTS (BD) BOM_RESOURCES (BR)

organization_id organization_id

2) Oracle Apps JOINS IN INV :
------------------------------------------------------------------------------------------------------------------
MTL_SYSTEM_ITEMS_B (MSIB) MTL_PARAMETERS (MP)

organization_id organization_id

MTL_MATERIAL_TRANSACTION (MMT) MTL_TRANSACTION_TYPES (MTT)

transaction_type_id transaction_type_id

MTL_MATERIAL_TRANSACTION (MMT) MTL_ITEM_CATEGORIES (MIC)

organization_id organization_id
inventory_item_id inventory_item_id

MTL_MATERIAL_TRANSACTION (MMT) MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id inventory_item_id

MTL_TRANSACTION_TYPES (MTT) MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id inventory_item_id

MTL_ITEM_REVISIONS(MIR) MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id inventory_item_id
organization_id organization_id

CST_ITEM_COSTS(CIC) MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id inventory_item_id
organization_id organization_id

MTL_ITEM_CATEGORIES (MIC) MTL_CATEGORIES (MC)

category_id category_id

JOINS IN INV WITH OTHER MODULES :

MTL_SYSTEM_ITEMS_B (MSIB) RCV_TRANSACTIONS

organization_id organization_id

MTL_SYSTEM_ITEMS_B (MSIB) HR_EMPLOYEES

buyer_id employee_id

3) Oracle Apps JOINS IN WIP :
------------------------------------------------------------------------------------------------------
WIP_ENTITIES (WE) WIP_TRANSACTIONS (WT)

organization_id organization_id
wip_entity_id wip_entity_id

WIP_TRANSACTION_ACCOUNTS (WTA) WIP_TRANSACTIONS (WT)

transaction_id transaction_id

WIP_LINES (WL) WIP_TRANSACTIONS(WT)

line_id line_id

WIP_DISCRETE_JOBS (WDJ) WIP_ENTITIES (WE)

wip_entity_id wip_entity_id

WIP_ENTITIES (WE) WIP_OPERATION_RESOURCES (WOR)

wip_entity_id wip_entity_id

WIP_ENTITITES (WE) WIP_REQUIREMENT_OPERATIONS

organization_id organization_id

WIP_ENTITIES WIP_OPERATIONS

wip_entity_id wip_entity_id
organization_id organization_id

Oracle Apps JOINS IN WIP WITH OTHER MODULES
----------------------------------------------------------------------------------------------------------

WIP_TRANSACTION_ACCOUNTS (WTA) PO_HEADERS_ALL (POH)

po_header_id po_header_id

CST_COST_ELEMENTS (CSE) WIP_TRANSACTIONS (WT)

cst_element_id cst_element_id

WIP_OPERATIONS (WO) BOM_DEPARTMENTS (BD)

department_id department_id

WIP_ENTITIES (WE) MTL_SYSTEM_ITEMS_B (MSIB)

organization_id organization_id
primary_item_id inventory_item_id

WIP_OPERATION_RESOURCES (WOR) BOM_RESOURCES (BR)

resource_id resource_id