Q: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions from one environment to another without re-Keying? Will you use FNDLOAD?
A: FNDLOAD can not be used in this scenario. You can use migrator available in "Oracle iSetup" Responsibility
Q: Which Form in Oracle Applications has most number of Form Functions?
A: "Run Reports". And why not, the Form Function for this screen has a parameter to which we pass name of the "Request Group", hence securing the list of Concurrent Programs that are visible in "Run Request" Form. Just so that you know, there are over 600 form functions for "Run Reports"
Q: Which responsibility do you need to extract Self Service Personalizations?
A: Functional Administrator
A: FNDLOAD can not be used in this scenario. You can use migrator available in "Oracle iSetup" Responsibility
Q: Which Form in Oracle Applications has most number of Form Functions?
A: "Run Reports". And why not, the Form Function for this screen has a parameter to which we pass name of the "Request Group", hence securing the list of Concurrent Programs that are visible in "Run Request" Form. Just so that you know, there are over 600 form functions for "Run Reports"
Q: Which responsibility do you need to extract Self Service Personalizations?
A: Functional Administrator
Q: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10
A:You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
Q: You have just created two concurrent programs namely "XX PO Prog1" & "XX PO Prog2". Now you wish to create a menu for Concurrent Request submission such that only these two Concurrent Programs are visible from that Run Request menu. Please explain the steps to implement this?
A: a) Define a request group, lets say with name "XX_PO_PROGS"
b) Add these two concurrent programs to the request group "XX_PO_PROGS"
c) Define a new Form Function that is attached to Form "Run Reports"
d) In the parameter field of Form Function screen, enter
REQUEST_GROUP_CODE="XX_PO_PROGS" REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS"
e) Attach this form function to the desired menu.
Q: Does Oracle 10g support rule based optimization?
A: The official stance is that RBO is no longer supported by 10g.
Q: Does oracle support partitioning of tables in Oracle Apps?
A: Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records can be archived.
Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive data to a tape).
Q: What will be your partitioning strategy on GL_BALANCES? Your views please?
A: This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, or on the status of the GL Period.
Q: Does Oracle support running of gather stats on SYS schema in Oracle Apps?
A: If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');
Alternately using command dbms_stats.gather_schema_stats('SYS',cascade=>TRUE,degree=>20);
I will prefer the former with default values.
If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats('SYS');
You can schedule a dbms_job for running stats for SYS schema.
A:You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
Q: You have just created two concurrent programs namely "XX PO Prog1" & "XX PO Prog2". Now you wish to create a menu for Concurrent Request submission such that only these two Concurrent Programs are visible from that Run Request menu. Please explain the steps to implement this?
A: a) Define a request group, lets say with name "XX_PO_PROGS"
b) Add these two concurrent programs to the request group "XX_PO_PROGS"
c) Define a new Form Function that is attached to Form "Run Reports"
d) In the parameter field of Form Function screen, enter
REQUEST_GROUP_CODE="XX_PO_PROGS" REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS"
e) Attach this form function to the desired menu.
Q: Does Oracle 10g support rule based optimization?
A: The official stance is that RBO is no longer supported by 10g.
Q: Does oracle support partitioning of tables in Oracle Apps?
A: Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records can be archived.
Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive data to a tape).
Q: What will be your partitioning strategy on GL_BALANCES? Your views please?
A: This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, or on the status of the GL Period.
Q: Does Oracle support running of gather stats on SYS schema in Oracle Apps?
A: If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');
Alternately using command dbms_stats.gather_schema_stats('SYS',cascade=>TRUE,degree=>20);
I will prefer the former with default values.
If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats('SYS');
You can schedule a dbms_job for running stats for SYS schema.
Q: Can you use concurrent program "Gather Schema Statistics" to gather stats on sys schema in oracle apps?
A: No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job.
A: No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job.
Q: Which table is used to provide drill down from Oracle GL into sub-ledger?
A: GL_IMPORT_REFERENCES
Q: What is the significance of profile option “Node Trust Level” in Oracle Apps.
A: If this profile option is set to a value of external against a server, then it signifies that the specific mid-tier is External i.e. it will be exposed to the www. In other words this server is not within the firewall of your client. The idea behind this profile option is to flag such middle-tier so that special restrictions can be applied against its security, which means a very restricted set of responsibilities will be available from such Middle-Tier.
Q: What is the significance of profile option “Responsibility Trust Level”.
A: In order to make a responsibility accessible from an external web tier, you must set profile option “Responsibility Trust Level” at responsibility level to “External”. Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.
Q: What else can you suggest to restrict the access to screens from external web tiers?
A: You may use URL filtering within Apache.
Q: What is the role of Document Manager in Oracle Purchasing?
A: POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.
Q: How to debug a document manager in Oracle Apps?
A: Document manger runs within the concurrent manager in Oracle Applications. When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager.
There are two mechanisms by which to trace the document manager
1. Set the debugging on by using profile option
STEP 1. Set profile option "Concurrent:Debug Flags" to TCTM1
This profile should only generate debugs when set at Site level(I think), because Document Manager runs in a different session.
STEP 2. Bounce the Document Managers
STEP 3. Retry the Workflow to generate debugs.
STEP 4. Reset profile option "Concurrent:Debug Flags" to blank
STEP 5. have a look at debug information in table fnd_concurrent_debug_info
2. Enable tracing for the document managers
This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.
Q: You have written a Java Concurrent Program in Oracle Apps. You want to modify the CLASSPATH such that new class CLASSPATH is effective just for this program.
A: In the options field of the concurrent program you can enter something similar to below.
-cp :/home/xxvisiondev/XXDEVDB/comn/java/appsborg.zip:/home/xxvisiondev/XXDEVDB/comn/java
Q: How will you open a bc4j package in jdeveloper?
A: Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).
Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.
Q: In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?
A: The tabs on OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page.
Q: In self service, you wish to change the background color and the foreground text of the OA Framework screens to meet your corporate standards. How will you do it?
A: You will need to do the below steps
a….Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss
b…Enter below text( change colours as needed)
c… cd $OA_HTML/cabo/styles/cache
d…Take a backup of all the css files.
e…Delete all the files of following pattern oracle-desktop*.css
The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css file if found missing for your browser.
Q: Can you extend and substitue a root AM ( Application Module) in OA Framework using JDeveloper.
A: You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9).
Q: In a workflow notification, you have a free text response field where the user enters the Vendor Number for the new vendor. You want to validate the value entered in the notification response field upon the submission of a response. How will you do it?
A: You will need to attach a post notification function to the Workflow Notification.
The PL/SQL code will look similar to below:-
The below code will display an error in the notification when user attempts to create a Duplicate Vendor Number.
PROCEDURE validate_response_from_notif
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
) IS
l_nid NUMBER;
l_activity_result_code VARCHAR2(200);
v_newly_entered_vendor_num VARCHAR2(50);
CURSOR c_get_response_for_new_vendor IS
SELECT wl.lookup_code
FROM wf_notification_attributes wna
,wf_notifications wn
,wf_message_attributes_vl wma
,wf_lookups wl
WHERE wna.notification_id = l_nid
AND wna.notification_id = wn.notification_id
AND wn.message_name = wma.message_name
AND wn.message_type = wma.message_type
AND wna.NAME = wma.NAME
AND wma.SUBTYPE = 'RESPOND'
AND wma.format = wl.lookup_type
AND wna.text_value = wl.lookup_code
AND wma.TYPE = 'LOOKUP'
AND decode(wma.NAME, 'RESULT', 'RESULT', 'NORESULT') = 'RESULT';
BEGIN
IF (funcmode IN ('RESPOND'))
THEN
l_nid := wf_engine.context_nid;
OPEN c_get_response_for_new_vendor;
FETCH c_get_response_for_new_vendor
INTO l_activity_result_code;
CLOSE c_get_response_for_new_vendor;
v_newly_entered_vendor_num := wf_notification.getattrtext(l_nid,'NEWLY_ENTERED_VENDOR_NUM_4_PO');
IF l_activity_result_code = 'NEW_VENDOR'
AND does_vendor_exist(p_vendor => v_newly_entered_vendor_num)
THEN
RESULT := 'ERROR: VendorNumber you entered already exists';
RETURN;
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
RESULT := SQLERRM;
END validate_response_from_notif;
Q: How to make concurrent program end with warning?
A: If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.
For a Java Concurrent program, use the code similar to below
ReqCompletion lRC;
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
lRC.setCompletion(ReqCompletion.WARNING, "WARNING");
Q: How do you link a Host type concurrent program to Concurrent Manager?
A: Assuming your executable script is LOADPO.prog, then use the commands below
cd $XXPO_TOP/bin
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO
Q: How do you know if a specific Oracle patch has been applied in apps to your environment.
A: Use table ad_bugs, in which column bug_number is the patch number.
SELECT bug_number
,to_char(creation_date, 'DD-MON-YYYY HH24:MI
S') dated
FROM apps.ad_bugs
WHERE bug_number = TRIM('&bug_number') ;
Q: How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.
A: If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.
Q: What are the various ways to kick-off a workflow
A: You can either use wf_engine.start_process or you can attach a runnable process such that it subscribes to a workflow event.
Q: When starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?
--a)if initiating the process using start_process, do the below
wf_engine.threshold := -1;
wf_engine.createprocess(l_itemtype
,l_itemkey
,'');
wf_engine.startprocess(l_itemtype, l_itemkey)
--B) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.
Q: On 10g, how will you use awr?
A: By running below scripts. These are both the same scripts, but with differing parameters.
$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
Q : How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10).
A: After 11.5.10, FND Logging can be used for debugging Oracle iProcurement.
Prior to 11.5.10
----STEPS IN A NUTSHELL-----
cd $ORACLE_HOME/../iAS/Apache
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
DebugOutput=/home/<>/ora9/iAS/Apache/Apache/logs/debug.log
DebugLevel=5
DebugSwitch=ON
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
ApJServLogLevel debug
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
log=true
Q: How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?
A: Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps :-
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.
Q: Can you do fnd_request.submit_request from SQL Plus in Oracle?
A: You will need to initialize the global variables first using fnd_global.initialize
DECLARE
v_session_id INTEGER := userenv('sessionid') ;
BEGIN
fnd_global.initialize
(
SESSION_ID => v_session_id
,USER_ID =>
,RESP_ID =>
,RESP_APPL_ID =>
,SECURITY_GROUP_ID => 0
,SITE_ID => NULL
,LOGIN_ID => 3115003--Any number here
,CONC_LOGIN_ID => NULL
,PROG_APPL_ID => NULL
,CONC_PROGRAM_ID => NULL
,CONC_REQUEST_ID => NULL
,CONC_PRIORITY_REQUEST => NULL
) ;
commit ;
END ;
/
Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize
fnd_global.apps_initialize(user_id => :user_id,
resp_id => :resp_id,
resp_appl_id => :resp_appl_id,
security_group_id => :security_group_id,
server_id => :server_id);
By doing the above, your global variables upon which Concurrent Managers depend upon will be populated. This will be equivalent to logging into Oracle Apps and submitting the concurrent request from a responsibility.
A: GL_IMPORT_REFERENCES
Q: What is the significance of profile option “Node Trust Level” in Oracle Apps.
A: If this profile option is set to a value of external against a server, then it signifies that the specific mid-tier is External i.e. it will be exposed to the www. In other words this server is not within the firewall of your client. The idea behind this profile option is to flag such middle-tier so that special restrictions can be applied against its security, which means a very restricted set of responsibilities will be available from such Middle-Tier.
Q: What is the significance of profile option “Responsibility Trust Level”.
A: In order to make a responsibility accessible from an external web tier, you must set profile option “Responsibility Trust Level” at responsibility level to “External”. Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.
Q: What else can you suggest to restrict the access to screens from external web tiers?
A: You may use URL filtering within Apache.
Q: What is the role of Document Manager in Oracle Purchasing?
A: POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.
Q: How to debug a document manager in Oracle Apps?
A: Document manger runs within the concurrent manager in Oracle Applications. When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager.
There are two mechanisms by which to trace the document manager
1. Set the debugging on by using profile option
STEP 1. Set profile option "Concurrent:Debug Flags" to TCTM1
This profile should only generate debugs when set at Site level(I think), because Document Manager runs in a different session.
STEP 2. Bounce the Document Managers
STEP 3. Retry the Workflow to generate debugs.
STEP 4. Reset profile option "Concurrent:Debug Flags" to blank
STEP 5. have a look at debug information in table fnd_concurrent_debug_info
2. Enable tracing for the document managers
This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.
Q: You have written a Java Concurrent Program in Oracle Apps. You want to modify the CLASSPATH such that new class CLASSPATH is effective just for this program.
A: In the options field of the concurrent program you can enter something similar to below.
-cp :/home/xxvisiondev/XXDEVDB/comn/java/appsborg.zip:/home/xxvisiondev/XXDEVDB/comn/java
Q: How will you open a bc4j package in jdeveloper?
A: Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).
Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.
Q: In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?
A: The tabs on OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page.
Q: In self service, you wish to change the background color and the foreground text of the OA Framework screens to meet your corporate standards. How will you do it?
A: You will need to do the below steps
a….Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss
b…Enter below text( change colours as needed)
c… cd $OA_HTML/cabo/styles/cache
d…Take a backup of all the css files.
e…Delete all the files of following pattern oracle-desktop*.css
The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css file if found missing for your browser.
Q: Can you extend and substitue a root AM ( Application Module) in OA Framework using JDeveloper.
A: You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9).
Q: In a workflow notification, you have a free text response field where the user enters the Vendor Number for the new vendor. You want to validate the value entered in the notification response field upon the submission of a response. How will you do it?
A: You will need to attach a post notification function to the Workflow Notification.
The PL/SQL code will look similar to below:-
The below code will display an error in the notification when user attempts to create a Duplicate Vendor Number.
PROCEDURE validate_response_from_notif
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
) IS
l_nid NUMBER;
l_activity_result_code VARCHAR2(200);
v_newly_entered_vendor_num VARCHAR2(50);
CURSOR c_get_response_for_new_vendor IS
SELECT wl.lookup_code
FROM wf_notification_attributes wna
,wf_notifications wn
,wf_message_attributes_vl wma
,wf_lookups wl
WHERE wna.notification_id = l_nid
AND wna.notification_id = wn.notification_id
AND wn.message_name = wma.message_name
AND wn.message_type = wma.message_type
AND wna.NAME = wma.NAME
AND wma.SUBTYPE = 'RESPOND'
AND wma.format = wl.lookup_type
AND wna.text_value = wl.lookup_code
AND wma.TYPE = 'LOOKUP'
AND decode(wma.NAME, 'RESULT', 'RESULT', 'NORESULT') = 'RESULT';
BEGIN
IF (funcmode IN ('RESPOND'))
THEN
l_nid := wf_engine.context_nid;
OPEN c_get_response_for_new_vendor;
FETCH c_get_response_for_new_vendor
INTO l_activity_result_code;
CLOSE c_get_response_for_new_vendor;
v_newly_entered_vendor_num := wf_notification.getattrtext(l_nid,'NEWLY_ENTERED_VENDOR_NUM_4_PO');
IF l_activity_result_code = 'NEW_VENDOR'
AND does_vendor_exist(p_vendor => v_newly_entered_vendor_num)
THEN
RESULT := 'ERROR: VendorNumber you entered already exists';
RETURN;
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
RESULT := SQLERRM;
END validate_response_from_notif;
Q: How to make concurrent program end with warning?
A: If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.
For a Java Concurrent program, use the code similar to below
ReqCompletion lRC;
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
lRC.setCompletion(ReqCompletion.WARNING, "WARNING");
Q: How do you link a Host type concurrent program to Concurrent Manager?
A: Assuming your executable script is LOADPO.prog, then use the commands below
cd $XXPO_TOP/bin
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO
Q: How do you know if a specific Oracle patch has been applied in apps to your environment.
A: Use table ad_bugs, in which column bug_number is the patch number.
SELECT bug_number
,to_char(creation_date, 'DD-MON-YYYY HH24:MI
S') datedFROM apps.ad_bugs
WHERE bug_number = TRIM('&bug_number') ;
Q: How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.
A: If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.
Q: What are the various ways to kick-off a workflow
A: You can either use wf_engine.start_process or you can attach a runnable process such that it subscribes to a workflow event.
Q: When starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?
--a)if initiating the process using start_process, do the below
wf_engine.threshold := -1;
wf_engine.createprocess(l_itemtype
,l_itemkey
,'');
wf_engine.startprocess(l_itemtype, l_itemkey)
--B) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.
Q: On 10g, how will you use awr?
A: By running below scripts. These are both the same scripts, but with differing parameters.
$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
Q : How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10).
A: After 11.5.10, FND Logging can be used for debugging Oracle iProcurement.
Prior to 11.5.10
----STEPS IN A NUTSHELL-----
cd $ORACLE_HOME/../iAS/Apache
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
DebugOutput=/home/<>/ora9/iAS/Apache/Apache/logs/debug.log
DebugLevel=5
DebugSwitch=ON
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
ApJServLogLevel debug
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
log=true
Q: How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?
A: Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps :-
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.
Q: Can you do fnd_request.submit_request from SQL Plus in Oracle?
A: You will need to initialize the global variables first using fnd_global.initialize
DECLARE
v_session_id INTEGER := userenv('sessionid') ;
BEGIN
fnd_global.initialize
(
SESSION_ID => v_session_id
,USER_ID =>
,RESP_ID =>
,RESP_APPL_ID =>
,SECURITY_GROUP_ID => 0
,SITE_ID => NULL
,LOGIN_ID => 3115003--Any number here
,CONC_LOGIN_ID => NULL
,PROG_APPL_ID => NULL
,CONC_PROGRAM_ID => NULL
,CONC_REQUEST_ID => NULL
,CONC_PRIORITY_REQUEST => NULL
) ;
commit ;
END ;
/
Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize
fnd_global.apps_initialize(user_id => :user_id,
resp_id => :resp_id,
resp_appl_id => :resp_appl_id,
security_group_id => :security_group_id,
server_id => :server_id);
By doing the above, your global variables upon which Concurrent Managers depend upon will be populated. This will be equivalent to logging into Oracle Apps and submitting the concurrent request from a responsibility.
Q: You are told that the certain steps in the Oracle Apps Form/Screen are running slow, and you are asked to tune it. How do you go about it.
A: First thing to do is to enable trace. Preferably, enable the trace with Bind Variables. This can be done by selecting menu Help/Diagnostics/Trace/”Trace With Binds and Wait”
Internally Oracle Forms issues a statement similar to below:-
alter session set events='10046 trace name context forever, level 12' ;
Enable Trace with Bind Variables in Apps
This will enable the trace with Bind Variable values being shown in the trace file.
The screen in Oracle Apps will also provide the name of the trace file which is located in directly identified by
select value from v$parameter where name like '%us%r%dump%'
Doing a tkprof with explain plan option, reviewing plans and stats in trace file can help identify the slow performing SQL.
Q: What is the difference between running Gather Stats and “Program – Optimizer[RGOPTM]” in Oracle General Ledger?
A: “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled,
Q: You have written a piece of code in POR_CUSTOM_PKG for Oracle iProcurement, but its not taking any effect? What may be the reason?
A: Depending upon which procedure in POR_CUSTOM_PKG has been programmed, one or more of the below profile options must be set to Yes
POR: Enable Req Header Customization
POR: Enable Requisition Line Customization
POR: Enable Req Distribution Customization
Q: What is the key benefit of punching out to suppliers catalogs rather than loading their catalogs locally in Oracle iProcurement?
A: Punchout has several advantages like, Catalogs don’t need to be loaded locally saves space on your system. You can get up-to-date list of catalogs by punching out and also you get the benefit of up-to-date pricing information on vendor items.
Q: Does Oracle Grants use its own schema or does it uses Oracle Project Accounting schema?
A: Although Oracle Grants has its own schema i.e. GMS, it reuses many of the tables with in Oracle Projects Schema like PA_PROJECTS_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES etc.
Q: How to make an Oracle Report Type concurrent program produce an excel friendly output?
A: Comma can be concatenated between the column values, however a better option is to create tab delimited file, as it takes care of commas within the string.
For this, use SQL similar to below in the report
select 'a' || chr(9) || 'b' from dual;
Q: What are the settings needed for printing bitmap reports?
A: Get your DBA to configure two files i.e. uiprint.txt & default.ppd
For details, refer to Metalink Note 189708.1
Q: For a PL/SQL based concurrent program do you have to issue a commit at the end?
A: The concurrent program runs within its own new session. In APPS, the default database setting enforces a commit at the end of each session. Hence no explicit COMMIT is required.
Q: What is the best way to add debugging to the code in apps?
A: Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging uses autonomous transaction to insert records in a table named fnd_log_messages.
For example
DECLARE
BEGIN
fnd_log.STRING(log_level => fnd_log.level_statement
,module => 'xxxx ' || 'pkg/procedurename '
,message => 'your debug message here');
END ;
Three profile options effecting FND Logging are
FND: Debug Log Mode
FND: Debug Log Enabled
FND: Debug Log Module
Q: If you wish to trigger of an update or insert in bespoke table or take some action in response to a TCA record being created or modified, how would you do it? Will you write a database triggers on TCA Tables?
A: There are various pre-defined Events that are invoked from the Oracle TCA API’s.
TCA was Oracle’s first initiative towards a fully API based approach, which means the screen and the processes all use the same set of APIs for doing same task.
In order to take an action when these events occur, you can subscribe a custom PL/SQL procedure or a Custom Workflow to these events. Some of the important TCA events are listed below:-
oracle.apps.ar.hz.ContactPoint.update
oracle.apps.ar.hz.CustAccount.create
oracle.apps.ar.hz.CustAccount.update
oracle.apps.ar.hz.CustAcctSite.create
oracle.apps.ar.hz.CustAcctSite.update
oracle.apps.ar.hz.CustAcctSiteUse.create
oracle.apps.ar.hz.CustAcctSiteUse.update
oracle.apps.ar.hz.Location.create
oracle.apps.ar.hz.Location.update
oracle.apps.ar.hz.Organization.create
oracle.apps.ar.hz.Organization.update
oracle.apps.ar.hz.PartySite.create
oracle.apps.ar.hz.PartySite.update
oracle.apps.ar.hz.PartySiteUse.create
oracle.apps.ar.hz.PartySiteUse.update
oracle.apps.ar.hz.Person.create
oracle.apps.ar.hz.Person.update
Q: In Oracle OA Framework, is the MDS page/document definition stored in database or in the file system?
A: The MDS document details are loaded into database, in the following sets of tables.
JDR_ATTRIBUTES
JDR_ATTRIBUTES_TRANS
JDR_COMPONENTS
JDR_PATHS
The Document is loaded via XMLImporter
Q: In a Oracle Report data group, you have a “data link” between two queries. How do you ensure that the data link is made Outer Joined?
A: The data link is an Outer Join by default.
Q: How does substitution work in OA Framework?
What are the benefits of using Substitution in OA Framework?
A: Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization are applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the personalizations. The above listed steps occur as soon as Root Application module has been loaded.
The benefit of using Substitution is to extend the OA Framework without customization of the underlying code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. I think Root AM’s can’t be substituted given that substitution kicks off after Root AM gets loaded.
A: First thing to do is to enable trace. Preferably, enable the trace with Bind Variables. This can be done by selecting menu Help/Diagnostics/Trace/”Trace With Binds and Wait”
Internally Oracle Forms issues a statement similar to below:-
alter session set events='10046 trace name context forever, level 12' ;
Enable Trace with Bind Variables in Apps
This will enable the trace with Bind Variable values being shown in the trace file.
The screen in Oracle Apps will also provide the name of the trace file which is located in directly identified by
select value from v$parameter where name like '%us%r%dump%'
Doing a tkprof with explain plan option, reviewing plans and stats in trace file can help identify the slow performing SQL.
Q: What is the difference between running Gather Stats and “Program – Optimizer[RGOPTM]” in Oracle General Ledger?
A: “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled,
Q: You have written a piece of code in POR_CUSTOM_PKG for Oracle iProcurement, but its not taking any effect? What may be the reason?
A: Depending upon which procedure in POR_CUSTOM_PKG has been programmed, one or more of the below profile options must be set to Yes
POR: Enable Req Header Customization
POR: Enable Requisition Line Customization
POR: Enable Req Distribution Customization
Q: What is the key benefit of punching out to suppliers catalogs rather than loading their catalogs locally in Oracle iProcurement?
A: Punchout has several advantages like, Catalogs don’t need to be loaded locally saves space on your system. You can get up-to-date list of catalogs by punching out and also you get the benefit of up-to-date pricing information on vendor items.
Q: Does Oracle Grants use its own schema or does it uses Oracle Project Accounting schema?
A: Although Oracle Grants has its own schema i.e. GMS, it reuses many of the tables with in Oracle Projects Schema like PA_PROJECTS_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES etc.
Q: How to make an Oracle Report Type concurrent program produce an excel friendly output?
A: Comma can be concatenated between the column values, however a better option is to create tab delimited file, as it takes care of commas within the string.
For this, use SQL similar to below in the report
select 'a' || chr(9) || 'b' from dual;
Q: What are the settings needed for printing bitmap reports?
A: Get your DBA to configure two files i.e. uiprint.txt & default.ppd
For details, refer to Metalink Note 189708.1
Q: For a PL/SQL based concurrent program do you have to issue a commit at the end?
A: The concurrent program runs within its own new session. In APPS, the default database setting enforces a commit at the end of each session. Hence no explicit COMMIT is required.
Q: What is the best way to add debugging to the code in apps?
A: Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging uses autonomous transaction to insert records in a table named fnd_log_messages.
For example
DECLARE
BEGIN
fnd_log.STRING(log_level => fnd_log.level_statement
,module => 'xxxx ' || 'pkg/procedurename '
,message => 'your debug message here');
END ;
Three profile options effecting FND Logging are
FND: Debug Log Mode
FND: Debug Log Enabled
FND: Debug Log Module
Q: If you wish to trigger of an update or insert in bespoke table or take some action in response to a TCA record being created or modified, how would you do it? Will you write a database triggers on TCA Tables?
A: There are various pre-defined Events that are invoked from the Oracle TCA API’s.
TCA was Oracle’s first initiative towards a fully API based approach, which means the screen and the processes all use the same set of APIs for doing same task.
In order to take an action when these events occur, you can subscribe a custom PL/SQL procedure or a Custom Workflow to these events. Some of the important TCA events are listed below:-
oracle.apps.ar.hz.ContactPoint.update
oracle.apps.ar.hz.CustAccount.create
oracle.apps.ar.hz.CustAccount.update
oracle.apps.ar.hz.CustAcctSite.create
oracle.apps.ar.hz.CustAcctSite.update
oracle.apps.ar.hz.CustAcctSiteUse.create
oracle.apps.ar.hz.CustAcctSiteUse.update
oracle.apps.ar.hz.Location.create
oracle.apps.ar.hz.Location.update
oracle.apps.ar.hz.Organization.create
oracle.apps.ar.hz.Organization.update
oracle.apps.ar.hz.PartySite.create
oracle.apps.ar.hz.PartySite.update
oracle.apps.ar.hz.PartySiteUse.create
oracle.apps.ar.hz.PartySiteUse.update
oracle.apps.ar.hz.Person.create
oracle.apps.ar.hz.Person.update
Q: In Oracle OA Framework, is the MDS page/document definition stored in database or in the file system?
A: The MDS document details are loaded into database, in the following sets of tables.
JDR_ATTRIBUTES
JDR_ATTRIBUTES_TRANS
JDR_COMPONENTS
JDR_PATHS
The Document is loaded via XMLImporter
Q: In a Oracle Report data group, you have a “data link” between two queries. How do you ensure that the data link is made Outer Joined?
A: The data link is an Outer Join by default.
Q: How does substitution work in OA Framework?
What are the benefits of using Substitution in OA Framework?
A: Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization are applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the personalizations. The above listed steps occur as soon as Root Application module has been loaded.
The benefit of using Substitution is to extend the OA Framework without customization of the underlying code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. I think Root AM’s can’t be substituted given that substitution kicks off after Root AM gets loaded.
Q: In OA Framework, once your application has been extended by substitutions, is it possible to revert back to remove those substitutions?
A: yes, by setting profile option “Disable Self-Service Personal%” to Yes, keeping in mind that all your personalizations will get disabled by this profile option. This profile is also very useful when debugging your OA Framework based application in the event of some error. By disabling the personalization via profile, you can isolate the error, i.e. is being caused by your extension/substitution code or by Oracle’s standard functionality.
A: yes, by setting profile option “Disable Self-Service Personal%” to Yes, keeping in mind that all your personalizations will get disabled by this profile option. This profile is also very useful when debugging your OA Framework based application in the event of some error. By disabling the personalization via profile, you can isolate the error, i.e. is being caused by your extension/substitution code or by Oracle’s standard functionality.
Q: How can you import invoices into Oracle Receivables?
A: You can either use AutoInvoice by populating tables RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL & RA_INTERFACE_SALESCREDITS_ALL.
Alternately you may decide to use API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.
A: You can either use AutoInvoice by populating tables RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL & RA_INTERFACE_SALESCREDITS_ALL.
Alternately you may decide to use API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.
Q: How do you setup a context sensitive flexfield
A: Note: I will publish a white paper to sho step by step approach.
But for the purpose of your interview, a brief explanation is…a)Create a reference field, b) Use that reference field in “Context Field” section of DFF Segment screen c) For each possible value of the context field, you will need to create one record in section “Context Field Value” ( beneath the global data elements).
A: Note: I will publish a white paper to sho step by step approach.
But for the purpose of your interview, a brief explanation is…a)Create a reference field, b) Use that reference field in “Context Field” section of DFF Segment screen c) For each possible value of the context field, you will need to create one record in section “Context Field Value” ( beneath the global data elements).
Q: Does Oracle iProcurement use same tables as Oracle Purchasing?
A: Yes, iProcurement uses the same set of requisition tables as are used by Core Purchasing.
A: Yes, iProcurement uses the same set of requisition tables as are used by Core Purchasing.
Q: What is the name of the schema for tables in tca
A: AR (at least till 11.5.10, not sure about 11.5.10).
A: AR (at least till 11.5.10, not sure about 11.5.10).
Q: Are suppliers a part of TCA?
A: Unfortunately not yet. However, Release 12 will be merging Suppliers into TCA.
A: Unfortunately not yet. However, Release 12 will be merging Suppliers into TCA.
Q: What is the link between order management and purchasing
A: Internal Requisitions get translated into Internal Sales Orders.
A: Internal Requisitions get translated into Internal Sales Orders.
Q: How would you know if the purchase order XML has been transmitted to vendor, looking at the tables.
A: The XML delivery status can be found from a table named ecx_oxta_logmsg. Use the query below
SELECT edoc.document_number
,decode(eol.result_code, 1000, 'Success', 'Failure') AS status
,eol.result_text
FROM ecx_oxta_logmsg eol
,ecx_doclogs edoc
,ecx_outbound_logs eog
WHERE edoc.msgid = eol.sender_message_id
AND eog.out_msgid = edoc.msgid
ORDER BY edoc.document_number
A: The XML delivery status can be found from a table named ecx_oxta_logmsg. Use the query below
SELECT edoc.document_number
,decode(eol.result_code, 1000, 'Success', 'Failure') AS status
,eol.result_text
FROM ecx_oxta_logmsg eol
,ecx_doclogs edoc
,ecx_outbound_logs eog
WHERE edoc.msgid = eol.sender_message_id
AND eog.out_msgid = edoc.msgid
ORDER BY edoc.document_number
Q: You have done forms personalization, now how will you move it from one environment to another?
A: Use FNDLOAD. For examples visit FNDLOAD Article
Q: What are the key benefits of forms personalization over custom.pll?
A:
A: Use FNDLOAD. For examples visit FNDLOAD Article
Q: What are the key benefits of forms personalization over custom.pll?
A:
-->Multiple users can develop forms personalization at any given point in time.
-->It is fairly easy to enable and disable forms personalizations.
-->A programmer is not required to do simple things such as hide/disable fields or buttons.
-->Provides more visibility on customizations to the screen.
-->It is fairly easy to enable and disable forms personalizations.
-->A programmer is not required to do simple things such as hide/disable fields or buttons.
-->Provides more visibility on customizations to the screen.
Q: Tell me some limitations of forms personalization when compared to CUSTOM.pll?
A:
-->Can't create record group queries, hence can’t implement LOV Query changes.
-->Can't make things interactive, i.e. can’t have a message box that gives multiple choices for example Proceed or Stop etc.
Q: Give me one example where apps uses partitioning?
A: WF_LOCAL_ROLES
Q: Give me one example of securing attributes in iProcurement.
A: You can define Realm to bundle suppliers into a Category. Such realm can then be assigned to the User using Define User Screen. Security Attribute ICX_POR_REALM_ID can be used. By doing so, the user will only be made visible those Punchout suppliers that belong to the realm against their securing attributes.
Q: Can you send blob attachments via workflow notifications?
A: Yes, you can send BLOB Attachments.
A:
-->Can't create record group queries, hence can’t implement LOV Query changes.
-->Can't make things interactive, i.e. can’t have a message box that gives multiple choices for example Proceed or Stop etc.
Q: Give me one example where apps uses partitioning?
A: WF_LOCAL_ROLES
Q: Give me one example of securing attributes in iProcurement.
A: You can define Realm to bundle suppliers into a Category. Such realm can then be assigned to the User using Define User Screen. Security Attribute ICX_POR_REALM_ID can be used. By doing so, the user will only be made visible those Punchout suppliers that belong to the realm against their securing attributes.
Q: Can you send blob attachments via workflow notifications?
A: Yes, you can send BLOB Attachments.
Q. What are the application objects that support View Accounting and Drilldown?
A.GL_Import_Reference_Table (modified) For Example Invoices imported from Payables into GL goes to these tables from GL_Inerface table.
GL_SL_LINK_ID
GL_SL_LINK_TABLE
GL_JE_LINES (modified)
New views in the database:
FA_AEL_GL_V
FA_AEL_SL_MRC_V
FA_AEL_SL_V
Q. Where in Oracle General Ledger 11i can Drilldown be accessed?
A. You can drilldown from GL Account Inquiry window and the GL Journal Entry and GL Journal Inquiry windows. (N) Tools -> Drilldown Open the Journal entry in GL and go to Tools – drilldown, its shows u the origin of the journal entry. It is used only for viewing the origin of the journal entry.
Q. What are the Release 11i Sub-ledger drilldown features?
A. Expanded Subledger drilldown to other subledgers. View Accounting Lines window.
Q. What are recurring invoices? What are AP setup steps?
A. Some times suppliers would not be sending any invoices, but still the payment have to be made to him. Ex: rent, lease rentals. In this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.
Setup: 1) Create one special calendar
2) Create one full distribution set
3) Enter payment terms in the recurring invoice window
4) Enter the template no., first invoice amount, special invoice amounts.
Recurring Entries are of 3 types-
1. Standard,
2. Skeleton,
3. Fornulae Based
In GL Module
1.Define Formula Batch (e.g. ABC Rent batch)
2.Enter Lines (Here u have both Debit as well as Credit lines)
3.Generate Recurring period
4.Review Journal Batch
5.Post the batch
1. Standard Recurring Journal: It is used for same accounts & same amounts e.g.
Utilities Dr
Cash Cr
2. Skeleton Recurring Journal: It is used for same accounts but for different amounts, e.g.
Recurring Fee Dr
Cash Cr
3.Formule Based Journal: It is used for different accounts with different amounts, e.g.
Salaries Dr
Cash Cr
A.GL_Import_Reference_Table (modified) For Example Invoices imported from Payables into GL goes to these tables from GL_Inerface table.
GL_SL_LINK_ID
GL_SL_LINK_TABLE
GL_JE_LINES (modified)
New views in the database:
FA_AEL_GL_V
FA_AEL_SL_MRC_V
FA_AEL_SL_V
Q. Where in Oracle General Ledger 11i can Drilldown be accessed?
A. You can drilldown from GL Account Inquiry window and the GL Journal Entry and GL Journal Inquiry windows. (N) Tools -> Drilldown Open the Journal entry in GL and go to Tools – drilldown, its shows u the origin of the journal entry. It is used only for viewing the origin of the journal entry.
Q. What are the Release 11i Sub-ledger drilldown features?
A. Expanded Subledger drilldown to other subledgers. View Accounting Lines window.
Q. What are recurring invoices? What are AP setup steps?
A. Some times suppliers would not be sending any invoices, but still the payment have to be made to him. Ex: rent, lease rentals. In this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.
Setup: 1) Create one special calendar
2) Create one full distribution set
3) Enter payment terms in the recurring invoice window
4) Enter the template no., first invoice amount, special invoice amounts.
Recurring Entries are of 3 types-
1. Standard,
2. Skeleton,
3. Fornulae Based
In GL Module
1.Define Formula Batch (e.g. ABC Rent batch)
2.Enter Lines (Here u have both Debit as well as Credit lines)
3.Generate Recurring period
4.Review Journal Batch
5.Post the batch
1. Standard Recurring Journal: It is used for same accounts & same amounts e.g.
Utilities Dr
Cash Cr
2. Skeleton Recurring Journal: It is used for same accounts but for different amounts, e.g.
Recurring Fee Dr
Cash Cr
3.Formule Based Journal: It is used for different accounts with different amounts, e.g.
Salaries Dr
Cash Cr
Q. If any conflict occurs in FSG who will override; Column Set or Row Set?
A. The override component is row set. However some times it depend on the column set also.
A. The override component is row set. However some times it depend on the column set also.
Q. What is the difference between discounts and adjustments?
A. Discount refers to the payment terms or on quantity (bulk order discount) ordered. In the invoice received from supplier, discounts term is specifically stated, e.g. “If paid with in 15 days discount @ 2%”, what you need to do is pay 2% less then the original invoice amount, however caution should be taken that the freight amount should not be considered while calculating the discount. Adjustment could be for various reasons- Over priced invoice, short delivery of quantity as per goods received note, poor quality etc. Agreed upon amount will be deducted from the invoice, while making the payments. In AR, discount is given to promote the business and cash flow. Adjustments are made to adjust the account balances, which is not possible in other means.
A. Discount refers to the payment terms or on quantity (bulk order discount) ordered. In the invoice received from supplier, discounts term is specifically stated, e.g. “If paid with in 15 days discount @ 2%”, what you need to do is pay 2% less then the original invoice amount, however caution should be taken that the freight amount should not be considered while calculating the discount. Adjustment could be for various reasons- Over priced invoice, short delivery of quantity as per goods received note, poor quality etc. Agreed upon amount will be deducted from the invoice, while making the payments. In AR, discount is given to promote the business and cash flow. Adjustments are made to adjust the account balances, which is not possible in other means.
Q. What are cycles of GL, AP, and AR?
A. GL Accounting cycle can be further elaborated like this…
1. Open Period.
2. Create Functional and foreign journal entries.(including the journal import from legacy systems and subledgers).
3. Reverse journal entries.
4. Post the journals.
5. Review and correct the balances.
6. Revalue foreign currency balances.
7. Translate foreign currency balances.
8. Consolidate set of books.
9. Run accounting reports.
10. Close the accounting periods.
AP cycle ——– Purchase Order –> Receipt –> AP voucher –> Payment made
AR Cycle ——–Sales Order –> Shipment –> Invoice –> Payment receipt
GL cycle ——– Direct GL JE / Transfer subledger data to GL –> Post
Q. What are Summary Accounts and Rollup groups?
A. Summary Account is an account whose balance represents consolidation of accounts. Rollup group is a collection / consolidation of parent accounts. e.g. Assets is a total of Current assets and Fixed Assets. Current assets / Fixed assets in turn are collection of assets.
Summary Account is an account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations. Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.
Summary accounts are consolidated balances of accounts and rollup groups is collection of parent accounts.
A. GL Accounting cycle can be further elaborated like this…
1. Open Period.
2. Create Functional and foreign journal entries.(including the journal import from legacy systems and subledgers).
3. Reverse journal entries.
4. Post the journals.
5. Review and correct the balances.
6. Revalue foreign currency balances.
7. Translate foreign currency balances.
8. Consolidate set of books.
9. Run accounting reports.
10. Close the accounting periods.
AP cycle ——– Purchase Order –> Receipt –> AP voucher –> Payment made
AR Cycle ——–Sales Order –> Shipment –> Invoice –> Payment receipt
GL cycle ——– Direct GL JE / Transfer subledger data to GL –> Post
Q. What are Summary Accounts and Rollup groups?
A. Summary Account is an account whose balance represents consolidation of accounts. Rollup group is a collection / consolidation of parent accounts. e.g. Assets is a total of Current assets and Fixed Assets. Current assets / Fixed assets in turn are collection of assets.
Summary Account is an account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations. Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.
Summary accounts are consolidated balances of accounts and rollup groups is collection of parent accounts.
Q. What Sub-ledgers does Oracle General Ledger 11i Drilldown support?
A. Accounts Receivable, Accounts Payable and Cash Management. Drilldown from Oracle General Ledger 11i also supports Oracle Purchasing module (displays POs and Requisitions) from 11.5.9 version onwards. Drilldown from Oracle General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle Assets (except depreciation), Projects, Purchasing, Inventory, and Work in Process (WIP).
A. Accounts Receivable, Accounts Payable and Cash Management. Drilldown from Oracle General Ledger 11i also supports Oracle Purchasing module (displays POs and Requisitions) from 11.5.9 version onwards. Drilldown from Oracle General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle Assets (except depreciation), Projects, Purchasing, Inventory, and Work in Process (WIP).
Q. Which are required steps in Inventory module set up?
Answer:
a) All the 6 key flexfields i.e Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category
b) Organizations
c) Change Organizations
d) Intercompany Relations
e) Unit of Measure Classes
f)Subunventories
g)Item Attribute Controls, Categories
h)Default Category set
i)Item Statuses
j) Cost types
k)Profile Options
l)Inventory Accounting Periods
Q. What do you mean by Required with Defaults Steps?
Answer:
Required Step With Defaults means that the setup functionality comes with pre-seeded, default values in the database; however, you should review those defaults /default values and decide whether to change them to suit your business needs
Q. Which are Required with Defaults Steps in Inventory module?
Answer:
There are no such steps in Inventory module
Q. There is no stock locator control in your Inventory organization.Do you still need to configure it?
Answer:
You need not to configure the flexfield in a specific way but you must still compile the Stock Locators key Flexfield because all Oracle Inventory transaction and on-hand inquiries and reports require a frozen flexfield definition
Q. What is the use of a picking rule?
Answer:
When you pick release a sales order in Order Management module , Order Shipping Execution module ( which is a part of Order Management) submits requests to Oracle Inventory module which uses the information given in picking rule to give priority to pick units of an items and then it generates pick lists for sales orders
Q. Can you apply material overheads to Average Costing Organization?
Answer:
No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization
Q. What is a Transaction Action?
Answer:
A transaction action is a predefined method of changing the quantity and/or location and/or cost of an item. It is used in Transaction Type form
Q. How many Predefined Transaction Actions are available in Inventory module?
Answer:
You may use one of six predefined transaction actions: --issue from stores, subinventory transfer, direct organization transfer, intransit shipment, cost update and receipt into stores.
Q. Can you do Inventory transactions in prior periods?
Answer:
Yes, you can do by setting the profile option INV: Transaction Date validation to Provide warning when date in past period or Allow date in any open period. It allows entry of a past date
Q. Can you change customer item name or Item after you save it?
Answer:
Yes, you can change it if you have set the profile option INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively
Q. What is item status? Name the related table.
INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INVSDOIS)like “easyapps”
Active
Inactive
Engineer
Obsolete
Phase-Out
Prototype
OPM
Lease
Production
Concept
Design
DEM_Status
Pending
Answer:
a) All the 6 key flexfields i.e Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category
b) Organizations
c) Change Organizations
d) Intercompany Relations
e) Unit of Measure Classes
f)Subunventories
g)Item Attribute Controls, Categories
h)Default Category set
i)Item Statuses
j) Cost types
k)Profile Options
l)Inventory Accounting Periods
Q. What do you mean by Required with Defaults Steps?
Answer:
Required Step With Defaults means that the setup functionality comes with pre-seeded, default values in the database; however, you should review those defaults /default values and decide whether to change them to suit your business needs
Q. Which are Required with Defaults Steps in Inventory module?
Answer:
There are no such steps in Inventory module
Q. There is no stock locator control in your Inventory organization.Do you still need to configure it?
Answer:
You need not to configure the flexfield in a specific way but you must still compile the Stock Locators key Flexfield because all Oracle Inventory transaction and on-hand inquiries and reports require a frozen flexfield definition
Q. What is the use of a picking rule?
Answer:
When you pick release a sales order in Order Management module , Order Shipping Execution module ( which is a part of Order Management) submits requests to Oracle Inventory module which uses the information given in picking rule to give priority to pick units of an items and then it generates pick lists for sales orders
Q. Can you apply material overheads to Average Costing Organization?
Answer:
No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization
Q. What is a Transaction Action?
Answer:
A transaction action is a predefined method of changing the quantity and/or location and/or cost of an item. It is used in Transaction Type form
Q. How many Predefined Transaction Actions are available in Inventory module?
Answer:
You may use one of six predefined transaction actions: --issue from stores, subinventory transfer, direct organization transfer, intransit shipment, cost update and receipt into stores.
Q. Can you do Inventory transactions in prior periods?
Answer:
Yes, you can do by setting the profile option INV: Transaction Date validation to Provide warning when date in past period or Allow date in any open period. It allows entry of a past date
Q. Can you change customer item name or Item after you save it?
Answer:
Yes, you can change it if you have set the profile option INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively
Q. What is item status? Name the related table.
INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INVSDOIS)like “easyapps”
Active
Inactive
Engineer
Obsolete
Phase-Out
Prototype
OPM
Lease
Production
Concept
Design
DEM_Status
Pending
Q. Define steps of assigning items to an organization.
Create an item in Item master from and select the template to assign the corresponding item attributes from tools menu. Now save the item. After saving the item select the organizational assignment option from tools menu for that item and organizational assignment item form popups. Now u can select the organizations from the list by ticking in check box.save the work.
Q. In which table subinventory related information for item is stored?
MTL_ITEM_SUB_INVENTORIES
Q. What are the prerequisite set ups for interorganization transaction?
Prerequisites
Define an inventory item that is common to both organizations. See:Defining Items and Assigning Items to Organizations.Define at least two organizations, one of which is valid to receive material from the other. See: Creating an Organization, Oracle Human Resource Management Systems User’s Guide and Defining Organization Parameters.Set up inter–organization relationships and their corresponding accounts. See: Defining Inter–Organization Shipping Networks. For direct transfers, if the item to transfer is under serial number control, the item must have the same unit of measure in each organization. See: Defining Items.
Q. Where to define interorganization transaction charges and what are the different options?
Depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction value or a discrete amount that Oracle Inventory uses to compute transfer charges.
Q.What are stock locators and how to define them?
Stock locators are an optional entity that may be used to represent physical locations within a subinventory. You may choose to use stock locators for selected subinventories or selected items within selected subinventories. If locators are used, subinventory and locator track on-hand balances. Therefore, if locators are defined to represent a shelf within a stockroom, on-hand balances on the system would show the item and quantity down to the physical location within the facility.U can derfine them in stocklocator from (INVSAFDH) in inventory setups. MTL_ITEM_LOCATIONS is the main base table for this locators.
Q.Name the tables where the stock locator information is stored. At least two.
Refer above Q.One more table is MTL_ITEM_LOC_DEFAULTS
Q.What is unit of measure classes? Give atleast two examples. Name the underlying table.
Q.What is the prerequisite for difining unit of measure?
Q .In which tables the transaction details stored? Atleast two.
Q.What are centralized and decentralized level of control of item attributes?
Q.Name all status attributes.
Q.Differentiate between intra & inter uom class conversion with examples.
Q.Is uom maintained at master level or organization level or both?
Q.Mention the interface tables for item open interface and open transaction interface and also their respective production tables.
Q.Name atleast five reports in oracle inventory related to transaction ?
Q.What are the prerequsites for costing transactions?
Q.Which is the table for storing organization information?
Q.How to get the on hand quantity of an item across all organizations? Name the underlying tables.
Q.What is the purpose of standard cost update?
Q.Mention the navigational steps for abc analysis
Create an item in Item master from and select the template to assign the corresponding item attributes from tools menu. Now save the item. After saving the item select the organizational assignment option from tools menu for that item and organizational assignment item form popups. Now u can select the organizations from the list by ticking in check box.save the work.
Q. In which table subinventory related information for item is stored?
MTL_ITEM_SUB_INVENTORIES
Q. What are the prerequisite set ups for interorganization transaction?
Prerequisites
Define an inventory item that is common to both organizations. See:Defining Items and Assigning Items to Organizations.Define at least two organizations, one of which is valid to receive material from the other. See: Creating an Organization, Oracle Human Resource Management Systems User’s Guide and Defining Organization Parameters.Set up inter–organization relationships and their corresponding accounts. See: Defining Inter–Organization Shipping Networks. For direct transfers, if the item to transfer is under serial number control, the item must have the same unit of measure in each organization. See: Defining Items.
Q. Where to define interorganization transaction charges and what are the different options?
Depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction value or a discrete amount that Oracle Inventory uses to compute transfer charges.
Q.What are stock locators and how to define them?
Stock locators are an optional entity that may be used to represent physical locations within a subinventory. You may choose to use stock locators for selected subinventories or selected items within selected subinventories. If locators are used, subinventory and locator track on-hand balances. Therefore, if locators are defined to represent a shelf within a stockroom, on-hand balances on the system would show the item and quantity down to the physical location within the facility.U can derfine them in stocklocator from (INVSAFDH) in inventory setups. MTL_ITEM_LOCATIONS is the main base table for this locators.
Q.Name the tables where the stock locator information is stored. At least two.
Refer above Q.One more table is MTL_ITEM_LOC_DEFAULTS
Q.What is unit of measure classes? Give atleast two examples. Name the underlying table.
Q.What is the prerequisite for difining unit of measure?
Q .In which tables the transaction details stored? Atleast two.
Q.What are centralized and decentralized level of control of item attributes?
Q.Name all status attributes.
Q.Differentiate between intra & inter uom class conversion with examples.
Q.Is uom maintained at master level or organization level or both?
Q.Mention the interface tables for item open interface and open transaction interface and also their respective production tables.
Q.Name atleast five reports in oracle inventory related to transaction ?
Q.What are the prerequsites for costing transactions?
Q.Which is the table for storing organization information?
Q.How to get the on hand quantity of an item across all organizations? Name the underlying tables.
Q.What is the purpose of standard cost update?
Q.Mention the navigational steps for abc analysis
No comments:
Post a Comment