IZ0-451 Q&A 2

2. In Oracle Business Rules, __________ describes a restricted list of values, or range of values for a given data type of a fact. Mark for Review
(1) Points

Bucketkit

Buckethandle

Bucketgroup

Bucketset


Correct: In Oracle Business Rules, Bucketset describes a restricted list of values, or range of values for a given data type of fact.


Go to HOME_PAGE

IZ0-451 Q&A 1

The SOA governance framework is centered on ___________, process, technology, and services.

1) People

2) Value

3) Strategy

4) Risk

Correct: The SOA governance framework is centered on people, process, technology, and services.


Go to HOME_PAGE

IZ0-451 Oracle SOA Foundation sample orhttp://www.blogger.com/img/blank.gif practice question and Answers

This article would help for sure who ever preparing for the "Oracle SOA Foundation Practitioner" IZ0-451. And for one who want to know more about the SOA suite 11g.

1) Q&A1

2) Q&A2

3) Q&A3

4) Q&A4

5) Q&A5

6) Q&A6

7) Q&A7

8) Q&A8

9) Q&A9

10) Q&A10

11) Q&A11

12) Q&A12

13) Q&A13

14) Q&A14

15) Q&A15

16) Q&A16

17) Q&A17

18) Q&A18

19) Q&A19

20) Q&A20

21) Q&A21

22) Q&A22

23) Q&A23

24) Q&A24

25) Q&A25

26) Q&A26

27) Q&A27

28) Q&A28

29) Q&A29

30) Q&A30

31) Q&A31

32) Q&A32

33) Q&A33

34) Q&A34

35) Q&A35

36) Q&A36

37) Q&A37

38) Q&A38

39) Q&A39

40) Q&A40

41) Q&A41

42) Q&A42

43) Q&A43

44) Q&A44

45) Q&A45

46) Q&A46

47) Q&A47

48) Q&A48

49) Q&A49

50) Q&A50

51) Q&A51

52) Q&A52

53) Q&A53

54) Q&A54

55) Q&A55

56) Q&A56

57) Q&A57

58) Q&A58

59) Q&A59

60) Q&A60

61) Q&A61

62) Q&A62

63) Q&A63

64) Q&A64

65) Q&A65

66) Q&A66

67) Q&A67

68) Q&A68

69) Q&A69

70) Q&A70

71) Q&A71

72) Q&A72

73) Q&A73

74) Q&A74

75) Q&A75

76) Q&A76

77) Q&A77

78) Q&A78

79) Q&A79

80) Q&A80


Declaimer: The Answers given for all the questions are best of my knowledge. I may be wrong. for few of them. I would be Appreciate if you can correct me.

More would be Added soon..................... Keeping watching.

Know license applications

Know license applications:-
-------------------------------

Lot many times we would not be known if the client has the specific application license or not.

We can ask the client is one way. If you have access to the back-end for the production Instance. Then you could know with following query. This is the Other way.

All the applications which are Installed status are license one.

SELECT application_name
, application_short_name
,DECODE (status, 'I', 'Installed', 'S', 'Shared', 'Not Installed') status
, a.application_id
,i.patch_level
FROM fnd_application_all_view a
, fnd_product_installations i
WHERE a.application_id = i.application_id
ORDER BY 1;

Install base creation issue approach

Install base creation issue approach:-
-----------------------------------------------

I have made some package which could help creating the Install base for the sales order.

You can find above package posting under (OM) Ready scripts.

http://alloracletech.blogspot.com/2009/04/install-base-creation-for-all-sales.html

This posting helps you understand Install base issues.

After running the program, if we are still not able to see the Install base created. Check the following steps.

1) Query for the item in the Master item Form and Under Service Tab, you could find option "Installed Base Tracking" Option. This should be enabled for the Install base Creation.

2) Transaction's should be there for the Orders to created the Install base.

You can use the following Query to know the transaction ID's for your Order.

SELECT transaction_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

3) If Transactions are created for the Order but still there is no Install base created then check if there is any error for the Transaction in the Error Table.

You can use the following Query to get Error Information.

select * from csi.csi_txn_errors where TRANSACTION_ID IN (SELECT transaction_id--, trx_source_line_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33);

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

Based on the Error Message, you can go ahead for the Solution. Metalink would be best to get the Solution with the complete error message you found.

4) If there is no errors for this transaction then there is possibility that records are in Interface tables.

In this case you can run the following program to hit records from Interface tables to the Install base tables.

Program Name: Resubmit Interface Process

You can verify if the Install base created or not from the following Query.

select * from csi.csi_item_instances
where last_oe_order_line_id IN (Your Order Line ID);

Example:-

select * from csi.csi_item_instances
where last_oe_order_line_id IN (6912858, 6912859, 6912860);

I hope you find the above information help full.

Note:- I have tested above script in the 11i Instances.

Know Instance Name

Know Instance Name:-
-------------------------

Following Query can be used to know the Instance Name you are working from the Backend.

SELECT UPPER(sys_context('USERENV','DB_NAME')) "Instance"
FROM DUAL;

On-hand inventory information

On-hand inventory information:-
--------------------------------------

The following select statement would extracts all on-hand inventory information from Oracle
Applications base tables.

Note:- You may need to modify the query to match with your instance conditions and your requirements.

SELECT
NVL(substr(org.organization_code, 1,3), ' ') orgcode
,NVL(substr(msi.segment1, 1, 8), ' ') seg11
,NVL(substr(msi.segment1, 9, 8), ' ') seg12
,NVL(substr(msi.segment1, 17, 4), ' ') seg13
,NVL(moq.subinventory_code, ' ') sub_inv_code
,NVL(to_char(round(sum(moq.transaction_quantity))), ' ') trans_qnty
FROM mtL_system_items msi
,org_organization_definitions org
,mtl_onhand_quantities moq
,hr_organization_units hou
WHERE moq.inventory_iteM_id = msi.inventory_item_id
AND moq.organizatioN_id = msi.organizatioN_id
AND moq.organizatioN_id = org.organizatioN_id
AND moq.organization_id = hou.organization_id
-- AND hou.type = 'DC'
GROUP BY org.organization_code
, moq.subinventory_code
, msi.segment1;

I hope the above information would be helpful to you.