Top 20 Oracle SCM Interview Questions and Answers

 

Ques: 1. What is the difference between ‘Accrue On Receipt’ and ‘Accrue at Period End’?

Answer:

Accrue On Receipt means that when a receipt is saved, accrual transactions are immediately recorded and sent to the general ledger interface. This is also known as “online” accruals.

Accrue at Period End means that when a receipt is saved, the accrual transactions are not immediately recorded and sent to the general ledger; instead, the accounting entries are generated and sent at the end of the month by running the Receipt Accruals – Period-End Process.

All items with a destination type of either Inventory and Outside Processing are accrued on receipt. For items with a destination type of Expense, you have the option of accruing on receipt or at period end.

 

Oracle Fusion Applications interview Questions and Answers

Ques: 2. How many Key Flex Fields are there in inventory?

Answer:

Seven KFF are there in Inventory:

1. Account Alias 
2. Item 
3. Item Category 
4. Item Catalogues 
5. Stock Locators 
6. Sales Order 
7. Service Items

 

Oracle Accounts Payables Interview Questions and Answers

 

Ques: 3. What is the significance of the Document Total and Account Range types on the Approval Groups form?

Answer:

The Document Total type sets the maximum limit for any approval actions taken by the user whom the approval group applies to. If multiple Document Totals are specified, the restriction will be to the Document Total, which is the lowest. 

The Account Range also allows for a document total which is then tied to a specific range of accounts listed on the same line. It is possible to have different account ranges with different amount Limits. This allows the same user to have a different dollar/account limit. 

It is mandatory to have an account range specified in each approval group defined. By default, if there is not an account range defined, all accounts will then be excluded from the document approval process, which means that the documents will not have an ability to become approved.

 

Oracle ADF Interview Questions and Answers                                 

 

Ques: 4. How an requisition line with item number and without item number [one time item] be combined to single document line in autocreate?

Answer:

If you want to combine two requisition lines for the same item, one with an item number and one without, you have to manually autocreate the document and use Modify on the Tools menu to add the predefined item to the requisition line for the one time item.

 

Oracle Access Manager Interview Questions and Answers

 

Ques: 5. What is the difference between Purchased and Purchasable Flag for an item?

Answer: 

• Purchasable is a status attribute flag, so based on this flag, certain transactions can be controlled for an item. 
• Purchased flag decides whether to purchase and receive this item. 
• Purchasable flag decides whether to order this item in a purchase order. 
• If purchasable is enabled, item can be ordered in a purchase order, if not, new purchase orders can’t be created and approved for the items. 
• If purchased is enabled, item can be received if already present in an approved purchase order.

Oracle Fusion HCM Interview Questions and Answers

Ques: 6. I am using encumbrance accounting and when I forward a Purchase Order for approval, I am encountering the following error: APP-14166: Please enter a forward to employee or funds are not reserved. How would you resolve it?

Answer:

You must check the Reserve Funds check box when forwarding and/or approving a Purchase Order if you are using encumbrance. You can check to see if you are using encumbrance in Purchasing by doing the following:

1. Setup/Organizations/Financial Options
2. Change the Alternate Region to Encumbrance and see if the Use PO Encumbrance check box is checked.
3. Refer Note 1064155.6 for more details.

 

Oracle Financials Interview questions and Answers

 

Ques: 7. What are Reminder notifications?

Answer:

Once an approver doesn’t respond to approval notification for quite sometime, then a reminder notification can be sent out to the approver. You can send up to two reminders to an approver using the Timeout feature. You can also specify that after a certain period of time, the document be forwarded automatically to the next approver in the hierarchy. This feature has to be setup by you by changing the PO and/or Requisition approval workflow in Oracle Workflow Builder.

 

Oracle Cloud Interview Questions and Answers

Ques: 8. What is the significance of “PO: Convert Requisition UOM to Source Document UOM” profile option?

Answer:

Earlier in Autocreate if the requisition UOM is different from the BPA UOM the user would not be allowed to create a release. But in Create releases program this was possible. To make the behavior consistent we have introduced this profile option. If this profile is set to yes we allow the autocreation of the release with the quantity and UOM converted to that of the BPA. If the profile is set to yes we do not allow the creation of the req both in autocreate as well as the create releases program.

Oracle PL/SQL Interview Questions and Answers

 

Ques: 9. What are the difference in Lot and Serial?

Answer: 

Lot control is to control a whole batch of items. for example, in drug industry we have batch number which can be controlled using lot where we can track the complete batch using specific data.

Serial control is to monitor and track every single qty of an item like electronic devices where we track by serial number.

Oracle SQL Interview Questions and Answers

 

Ques: 10. What is the difference between the agreed amount and the amount limit fields while entering a contract purchase agreement and issues related to these fields?

Answer: 

i) The agreed amount field at the header level is copied to the amount limit in the terms and conditions block. This is also the amount that is printed on the blanket agreement and represents the contract amount between you and the vendor.

ii)The amount limit field will restrict the cumulative releases applied to this purchase agreement from exceeding the specified dollar amount entered here. The value of this field must be equal to or greater than the agreed amount field. This column is used for release approval amount validation. If the total cumulative releases exceed this amount approval will fail. The purpose of this field is to allow user to set a higher approval amount limit than the amount agreed.

Oracle RDMS Interview Questions and Answers

 

Ques: 11. How Warehouse Management System (WMS) is helpful compared to Inventory?

Answer:

Warehouse Management (WMS) enables companies to maximize their utilization of labor, space and equipment investments by coordinating and optimizing resource usage and material flows. Specifically designed to support the needs of distribution, manufacturing, asset-intensive, and service businesses, Oracle WMS provides a single-platform across your entire global supply chain.

BI Publisher Interview Questions and Answers

 

Ques: 12. Why is there no category displayed or list of values for the category field in the purchase order you are creating?

Answer:

You must also create category codes for your items. Then create a Category set for Purchasing controlled at the master level. Assign your items to a category code and the Purchasing category set you have created. Confirm that in Default Category Sets the Purchasing application points to the Purchasing Category set. This will populate the category and description when the item number is selected at the PO line level.

Oracle 10g Interview Questions and Answers 

 

Ques: 13. When the charge account field is non updateable?

Answer:

In the following cases the charge account field is not updateable:

1. If the destination type code is INVENTORY or SHOP FLOOR.
2. If the distribution is already encumbered.
3. If the PO is created from a encumbered Requisition
4. If the destination type code is Expense and
 

If the project is entered and the profile option PA_ALLOW_FLEXBUILDER_OVERRIDES is set to NO. If the expense accrual code= RECEIPT

 

Ques: 14. How many Transaction Types exist?

Answer:

Receive – Receive the items into Receiving Dock.
Deliver – Deliver the items into expense or inventory destination.
Return to Vendor – Return the received items directly to vendors.
Return to Receiving – Return the delivered items to Receiving Dock or inspection.
Accept – Accept items following an inspection.
Reject – Reject items following an inspection.
Transfer – Transfer items between locations.
Correct – Enter a positive or negative adjustment to a receiving or delivery transaction.
Match – Match unordered receipts to purchase orders.
Unordered – Receive items without purchase orders

 

Ques: 15. What is a Sub Inventory?

Answer:

Sub inventories can be defined as:

Subinventiries are unique physical or logical separations of material inventory. These can be raw material, finished goods or defective material sub inventory. You must define at least one sub inventory. 

Sub inventories are of two types: storage and receiving.

• Storage sub inventories are intermediate, or final put away locations for material. Material that resides in a storage sub inventory appears in on hand quantity and is tracked by the system. The system can book orders against and use manufacturing processes on material that resides in a storage sub inventory. You must define at least one storage sub inventory for your implementation. 
• Receiving type sub inventory is only used for receiving items. Items in this sub inventories cannot be on-hand or reserved.

 

Ques: 16. How are Lot and Serial Numbers handled in Inter-Organization Transfers?

Answer:

When you perform an inter organization transfer, the source and destination organization may have different lot/serial controls. Purchasing handles this situation as follows:

1. When the source organization uses controls and the destination organization does not, the control numbers are recorded as being issued from the source organization. Lot/serial transactions are recorded for the destination organization.
 

2. When the source organization does not use controls and the destination organization does, the transaction is processed normally.
 

3. When both source and destination organizations use controls, the control numbers are recorded as being issued from the source organization. These control numbers are tracked to insure that the same control numbers that were shipped are the ones
that are received. When items are returned from inventory to receiving or to the supplier, only the control numbers originally recorded for the delivery transaction can be used.

 

Ques:17. What is Pay On Receipt?

Answer:

Pay on Receipt (also known as ERS (Evaluated Receipt Settlement) or Self-Billing) is an Oracle Purchasing’s concurrent program, which automatically creates invoices in Oracle Payables and matches them with PO’s automatically for the received amount. The short name for the program is POXPOIV.

 

Ques: 18. How can you have specific Requestor defaulted on Requisition form?

Answer:

In order to have a specific requestor default onto the requisitions form, the user will have to set the following in the user’s requisition preferences. 

Navigation: /Purchasing -> Requisitions -> Requisitions Go to special ->preferences 

• Click in the requestor field Choose a requestor from the list of values Click the ‘apply’ button, a message ‘ new preferences now in effect.’ 
• Close the requisitions form Re-open the requisitions form Click in the lines region, the requestor from requisition preferences should appear in the requestor field. 
• The requisition preferences are only valid while working on it , user needs to re enter requisition preferences each time he starts the applications.

 

Ques: 19. How does the Payment due days calculated if 30 days means will it be from invoice date or material receiving date?

Answer: Due days calculation is based on what you set up in the PAYMENT tab window of Supplier Master form.

It has Four options:

1. Goods Received
2. Invoice
3. Invoice received
4. System

 

Ques: 20.. Is it possible to have all requisitions created from Inventory – Min-Max Planning to be imported with a status of INCOMPLETE?

Answer:

Yes, it is possible to have all requisitions created from Min-Max Planning with a status of INCOMPLETE. If the desired outcome is Min-Max requisitions showing a status of INCOMPLETE, it is necessary to set the profile option: INV: MinMax Reorder Approval to Incomplete. Conversely, if this profile option is set to Approved, all requisitions imported from Min-Max Planning will be imported with an approval status based on the approval authority of the user initiating the Requisition Import process.

 

Top 20 BlockChain interview Questions & Answers

Ques: 1. What are the differences between a traditional database and Blockchain database?

Ans: The difference between a traditional database and blockchain database is as follows:

1. Storage of Records: In a traditional system the records are centralized whereas in Blockchain the records are decentralized.

2. Operations Done: In a Blockchain system, you can only perform insert operations whereas in the traditional system you can read, edit, create and update the transactions.

3. Validations of transactions: You can validate any number of transactions on the network in a Blockchain whereas in the traditional database only specific nodes are allowed to validate the transactions.

Ques: 2. What are Ethereum Smart Contracts and in which language is Ethereum written?

Ans: A Smart Contract is a set of program that gets automatically executed on meeting the certain requirements of Blockchain. Ethereum is generally written in Solidity programming language.

Ques: 3. What are the types of record that can be kept in Blockchain?

Ans: In Blockchain, you can keep any number of records. Few of the records that can be kept in the blockchain ledger are:

1. Medical Transactions and history

2. The identity of numerous persons

3. Several numbers of events that take place in an organization and organizational records

4. Management records of companies that can be accessed from anywhere in the world with proper secure transactions

5. Documents that are to be kept at high-level security

Ques: 4. What are the benefits of Blockchain in business?

Ans: European Banks have already launched their projects to use this technology. The international payments system VISA has also joined them. Blockchain gives several advantages to the financial sector some of which are listed below:

• Money Transfer will become faster and cheaper payments are possible and significantly reduce their costs. 
• With the help of the Smart Contracts are computer programs which facilitate to verify and negotiation of the agreement. 
• In stock exchange Blockchain can remove brokers as intermediaries and decentralize the stock exchange system.

Ques: 5. What are the basic components of the Blockchain Ecosystem?

Ans: There are four basic components of Blockchain ecosystem as explained here:

• Shared Ledger:  It is a distributed data structure shared among peers managed inside Node application. 
• Node Application: Each of the nodes is installed and run on a computer to become a part of the blockchain network. 
• Virtual Machine: Here the implementation of instruction takes place and every participant runs that VM. 
• Consensus Algorithm: It is implemented as a part of node application which provides the rules for validation of transactions.

Ques: 6. How many cryptographic algorithms are used in Blockchain?

Ans: Here are some of the widely used cryptographic algorithms:

• Triple DES: DES stands for digital encryption system which uses 3 different keys of 56 bits. 
• RSA: It is used in several areas in the digital certificate which is a public key encryption algorithm to encrypt the information transferred on the internet. 
• Blowfish: It is highly effective and works with great speed which encrypts the cipher messages individually. 
• Twofish: It is similar to blowfish with keys of length 256 bits. 
• AES: Of all algorithms, AES is the strongest encryption algorithm to breach out as it uses 192 and 256 length bit keys for heavy encryption.

Ques: 7. Can you explain pragma and provide its syntax?

Ans: Pragma is a version of Solidity that will be used by the code that is written in the solidity. For using solidity as a compiler and writing smart contracts the version should be higher than 0.4.0. Every Smart contract starts with pragma only.

Syntax: version pragma ^0.4.00.

Ques: 8. What do you mean by Merkle trees and explain its importance in Blockchain?

Ans: Also called as the hash tree, Merkle tree is the fundamental part of a Blockchain. merkle tree uses cryptographic blocks which are used to securely transact large chunks of data. Both Ethereum and Bitcoin use Merkle trees.

Ques: 9. What do you understand by 51% attack?

Ans: The blockchain is a chain of blocks that stores all transactional data in a period. Once the block enters the system it cannot be altered, and the fraudulent data would be automatically rejected by network users. However, if 51% of the miners are controlled then a group of attackers can interfere with the process of recording of new blocks. 

They can block other users transactions and reverse it also. It is also known as double spending. A network that would allow double spending could suffer a loss of confidence. Then this kind of attack is called a 51% attack.

Ques: 10. What is a block in blockchain technology?

Ans: Blocks are the storage unit of the blockchain. They are fundamental to the network, and the transactions data is stored within them. They be books with each page equivalent to a transaction. Blocks are immutable. This means if a data is recorded, it cannot be changed or deleted. Also, blocks are organized linearly in a blockchain.

A block is mined by a miner which acts to verify the transaction. This means that until a transaction is not mined, it will not be shown on the blockchain and the transaction will be deemed incomplete.

Ques: 11. What is the role of encryption in blockchain?

Ans: Encryption is an age-old technique to protect data from third parties or leak. It is the basics of data security in the modern world. Blockchain also utilizes encryption to good effect. The data before it is sent off to the receiver is encrypted. The received will only be able to unlock it as it is only meant for him. Once the receiver receives it, it is unencrypted and can be used as liked.

Blockchain also uses encryption in other ways. Also, modern blockchain solution tends to improve encryption and provide complete privacy-based experience for users.

Ques: 12. What is the difference between the standard ledger and a blockchain ledger?

Ans: The biggest difference between these two types of ledger is the decentralization that they have to offer. Blockchain ledger is decentralized which means that it offers unique capabilities such as trust, immutability, transparency, and security. Standard ledger does carry these features but is limited to certain extent.

As humans create, modify and monitor the standard ledger, there is always a chance of an error creeping in or worse a security breach. Blockchain ledger solves all the problems that standard ledger has by providing a decentralized version.

Ques: 13. What is Node Application? Explain in detail.

Ans: Node application is a computer application that a computer needs to be part of the ecosystem. Without the node application, it is not possible for a device to participate in blockchain activity.

There is different node application when it comes to the blockchain. Bitcoin, for example, uses the Bitcoin wallet application to make a computer compatible with the blockchain.

Technically, there is a service overlay network(SON) that interfaces between the blockchain and the computer. The computer needs to use the node application to read and reply in a specific manner,

Not all node application is free from restriction. Some blockchains are stick when allowing a node to join the application. It needs permission to do so.

Ques: 14. What are the different types of Consensus Algorithm? Explain each of them briefly.

Ans: There are three main types of consensus algorithm.

1. Proof-of-Work(PoW): Proof-of-Work(PoW) is used by the most popular cryptocurrencies out there. Bitcoin, Ethereum, and Litecoin use it. It works by solving complex mathematical problems. The hash needs to be solved for the block to be mined. Once it is done, the transaction is validated, and the consensus is made.
2. Proof-of-Stake(PoS): Proof-of-Stake(PoS) works by staking coins. The nodes need to stake a minimum amount of coins to become part of the consensus network. Once they become part, they actively take part in making decisions on the network. Unlike Proof-of-Work, PoS doesn’t require huge computational power, and hence power. 
3. Delegated Proof-of-Stake(DPoS): Delegated Proof-of-Stake is a centralized approach to a blockchain network. In this consensus method, the stakes choose delegates which in turn validate the transactions.

Ques: 15. What is ‘blind signature’ and why is it used?

Ans: Blind Signature is a digital signature wherein all the information pertaining to a contract is made blind before it is actually agreed upon and sealed with a sign. This approach is a crucial component of cryptography and is mainly used for privacy-related protocols (for example, digital cash scheme) where the author and the signing parties are different.

Ques: 16. What are the fundamental principles in Blockchain that are used to eliminate security threats?

Ans: The fundamental principles in Blockchain that must be followed to eliminate security threats are:

1. Auditing 
2. Securing applications 
3. Securing testing and similar approaches 
4. Database security 
5. Continuity planning 
6. Digital workforce training

Ques: 17. What do you understand by the terms – ‘public key’ and ‘private key.’?

Ans: A public key is one which is used in cryptographic algorithms that allow all the users/peers in a Blockchain network to receive funds in their wallet. This key is essentially an alphanumeric string that is unique to a particular node or address.

A private key, on the other hand, is an alphanumeric phrase that is used in pair with a public key for encryption and decryption purposes. This key remains with a single individual who is the key generator for it. In case, anyone else gets their hand on the private key, the data within the wallet of the generator will be compromised.

Ques: 18. What do you mean by ‘off-chain’ transactions?

Ans: An off-chain transaction occurs when values are moved or placed outside the Blockchain. In this sense, it is merely a ‘transaction’ and not a ‘Blockchain transaction.’ Such transactions have no bearings on the values stored within the blocks of a Blockchain. 

Ques: 19. Explain ‘secret sharing.’

Ans: Secret Sharing is a method dedicated to protecting data integrity in Blockchain. In this method, the information or data is divided into different units and then transferred to the users on the Blockchain network. To complete the entire information, users who received the chunks of broken information must agree to share their pieces of information and combine them together.

Ques: 20. Explain a real-time blockchain use case?

Ans: Healthcare can use blockchain to their advantage. Many startups are currently working on a blockchain powered health app that lets patients store their information on the blockchain. The decentralized nature means that they don’t have to carry documents. Healthcare specialist can also take advantage of it as they can access the patient’s data anytime they want. Researchers also benefit from public blockchain where they can access large public data.