Oracle SCM, as you know, is a suite of cloud-based applications. It combines end-to-end business processes to fulfil the evolving supply chain needs of modern organisations. With organisations quickly adopting Oracle SCM Cloud applications, there’s also an increase in the demand for skilful candidates who could manage the supply chain of their company using Oracle SCM. Not to mention, there are immense opportunities out there in the same field.
However, you need to clear the interview in order to get such a life-changing opportunity. And since the competition is high, the Oracle SCM interview in organisations is usually tough.
At IQ Stream, we understand the challenges a candidate face during the interviews. While we offer the best Oracle Fusion SCM Online Training to all our trainees, we also offer them job assistance. And helping them in preparing for the interviews is also a part of our training program.
So, here we are sharing some Oracle SCM interview questions and their answers to help you prepare for your upcoming Oracle SCM interview.
Oracle SCM Cloud Functional Consultant
Oracle SCM Cloud Technical Consultant
Oracle SCM Cloud Solutions Architect
Oracle Fusion Cloud Project Manager
Oracle SCM Cloud Testing Engineer
Oracle SCM Cloud Business Analyst
Oracle SCM Consultant
ORACLE FUSION SCM INTERVIEW QUESTIONS
Some of the important Oracle SCM interview questions to crack the interview are:
What all setups have you done in Inventory Organisation Implementation?
I’ve worked on setting up:
- Intercompany Transaction flows
- Cost Group
- Stock Locator
- Sub inventory
- Shipping Networks
- Receiving Options
- Cost Sub elements
What are the different setups for expense items?
The various setups are:
- Should not be Inventory Item
- No Transactable
- No Stackable
- No Costing Inventory Asset
Explain Inter Organisation Shipping Networks?
Inter-organisation shipping networks explain the relationship between a shipping organisation and a destination organisation. It is a must to define the shipping network between two organisations before transferring material between them. When setting up a shipping network, you must select a transfer type. There are two types:
●In transit: Before reaching the destination organisation, the Oracle Inventory moves material to an intermediary state. On arriving at the destination organisation, a receipt transaction is required to retrieve it. In transit type, you can specify the shipping methods, material ownership during transfer, GL Accounts to use in transit, transfer charges and planning lead times.
●Direct: If this is selected, the material will be directed moved to the destination organisation by the Oracle Inventory.
For both transfer types, however, you can determine default receipt routing.
Explain Re-order Point Planning?
If you want to decide when to order a new quantity to refill the inventory, you need reorder point planning. It uses demand forecasts to make such a decision. It does do for an item when the existing quantity (planned receipts and on-hand quantity) goes below the safety stock level of a particular item.
The suggested quantity is an economic order quantity, which reduces the overall cost of ordering and carrying inventory.
Define Abc Analysis?
Also known as Selective Inventory Control Method (SIM). It is used to determine the relative value of a group of inventory items according to the user-specified valuation. With Abc Analysis technique, the inventory is divided into three categories A, B & C. Their annual consumption value is the basis of categorising the inventory.
What is the concurrent program for planning?
It is the Min-Max planning report in Inventory responsibility under the planning menu.
Describe Various Inventory Transaction Types?
The different types of inventory transaction are:
●Sub-inventory Transfer: Transfers goods between several sub-inventory within the same inventory organisation.
●Miscellaneous Transaction: Used to make adjustments in the stock in case of obsolescence, damages, issuing items for R & D, etc.
●Receiving Transaction: Helps move goods from receiving dock to a locator and a specified sub-inventory.
●InterORG Transfer: Used to transfer goods from one inventory organisation to another.
●WIP Issue: Issues materials against production orders.
●Sales Issue: Used to move goods from pick to staged sub inventory.
Where can you use Miscellaneous Transaction? Give any 4 purposes of it.
Physical inventory adjustment, Cycle count adjustment, decrementing on-hand balances and adjusting inventory quantity within an inventory organisation.
What is the difference between bill of distribution and sourcing rules?
Bill of distribution helps you determine how a particular item is distributed in a company. It specifies the warehouses to which an item is to be distributed. On the other hand, sourcing rules determine the source of an item. It determines the suppliers of a particular item in a company.
ORACLE APPS SCM FUNCTIONAL INTERVIEW QUESTIONS AND ANSWERS
Want to crack Oracle SCM Functional interview? Practise the below set Oracle SCM interview questions:
What is back flushing?
All components with the supply type are automatically backflushed upon assembly completion. When components for assemblies under serial number control, lot control, or lot and serial control are backflushed, it is crucial to assign lot and/or serial numbers to each component.
What are the setups that govern the creation of PO in an OSP Sub-assembly?
You must define Sourcing Rules for the item. You should map it to the item and organisation under the respective assignment set.
What is meant by Charge type in a Resource definition?
A Charge type determines how each resource is moved into the “Work in Process”. When an operation completes, the Work in Process status records all the units applied to the repetitive schedule in the resource unit of measure or the job. You can charge resources automatically or manually.
What is Use-up date?
It is the date when on-hand quantity is finished depending on the anticipated gross requirements. Use-up date calculates this by applying any on-hand quantity in the inventory (supply) against any gross requirements (demand).
What do you understand by ‘Genealogy’ in Inventory Management?
It’s like a standard maintained for all Serial-controlled and Lot-controlled items. A Lot Genealogy records the relationship between lots. Whereas the Serial genealogy tracks the multilevel composition history of any serial-controlled item and transaction. It collects this data from the receipts through inventory and works in process to your customer sale.
The Lot Genealogy offers lot traceability obtained from inventory transactions.
If an item costs X in Average costing organisation and is transferred to a Standard costing enabled organisation, what do you think will happen?
Average costing will be compared with the standard cost of the item. This difference will then be accounted for under the variance account.
What is Value Set?
It is a collection of values. A Value set provides a list of values to the end user allowing them to accept one of the values as the report parameter value.
What is Application Top?
When we connect to the server, the top we see is called an application top. There are two types of Application Top.
●Product top – The default top built by the manufacturer.
●Custom top – Used to select the Client for their business purposes. Usually, customizations are done using Custom top.
What are Placeholder Columns?
These are empty containers you see at the design time. These can hold values (one value) at run time.
What is the difference between Quick Codes and Quick Pick?
Quick Pick is a variable as it picks values from user-defined tables. Whereas Quick selects values from system table called FND_LOOKUPS. It is static. Also, Quick Code is faster than Quick Pick since it uses internal CACHE.
Interested in Oracle Fusion SCM Training at IQ Stream? Enrol with us today at https://www.iqstreamtech.com/oracle-fusion-scm-online-training/ and clear that interview with confidence by practicing our Oracle SCM interview questions.
ORACLE R12 SCM INTERVIEW QUESTIONS
What is the difference between Job hierarchy and position hierarchy?
When there is a single approval hierarchy system in an organisation, we use Job hierarchy. But, if multiple positional approvals are required for the same job, we use Position hierarchy. Here, a junior buyer’s requisition needs to be approved by the senior buyer. Further, the senior buyer’s requisition should be approved by the Supply Chain Manager and then finally by the Finance manager.
Imagine a client needs control over procurement for each department. How using Oracle EBS can help the client handle such a requirement?
With Oracle EBS, it is possible to handle such a requirement. By using Encumbrance functionality, the client can allocate a specific amount and purchasing to each department. With this, the client can ensure that the system doesn’t approve PO more than the set budget.
What is the difference between Blanket Purchase Agreement and Contract Purchase Agreement?
With Blanket purchase agreements, you get details of the goods or services you plan to buy from a specific supplier in a particular time. However, it doesn’t specify the details of your delivery schedule. On the other hand, you can create contract purchase agreements with your suppliers to agree on specific conditions. However, you don’t need to specify the goods and services that you will be buying.
Blanket purchase agreements are created to specify negotiated prices for your items prior to buying them. With Contract Purchase, you can issue standard purchase orders with reference to your contracts later.
How can you auto-create each requisition grouped by a buyer using Oracle Fusion App?
To achieve this, you will have to set the requisition group by parameter to ‘Buyer’ in the “Purchasing” option.
ORACLE APPS SCM TECHNICAL INTERVIEW QUESTIONS
According to research, Oracle Applications Technical has a market share of about 4.7%. This means that you have a huge opportunity to build your career in Oracle Applications Technical Development. Check out these Oracle Apps SCM Technical Interview Questions that will help you in cracking your interview & acquire your dream career as Oracle Applications Technical Developer.
What is responsibility?
It is an assortment of request security groups, menus, and data groups, where:
●Request security groups are a collection of programs.
●Menus are a collection of forms
●Data groups is a group of modules which can be accessed by the user through Responsibility System admin.
What is ERP? Explain the architecture of apps.
ERP is a packaged business software system. It allows organizations to automate and integrate their end-to-end business processes, generate and access information in a real-time environment, and share common data and practices across the enterprise.
Explain Oracle Applications Architecture.
It is a framework for 3-tier, distributed computing. It supports Oracle Applications products. The three tiers include:
●Application Tier manages Oracle Apps and other tools.
●Desk Top Tier offers the user interface displace.
●DataBase Tier manages Oracle database.
How can you register a table and columns at the back end?
Here are the steps:
●Use AD_DD package to register a table.
●Note: AD_DD BPI doesn’t check for the existence of the registered table or column in the database schema. Instead, it only updates the required SQL tables.
●You should ensure that all the tables and columns actually exist. They should also have the same format as defined using the AD_DD API.
●Also, register the Views.
What are Handlers?
It is a group of packaged procedures used by Oracle Applications. It helps in organizing PL/SQL code into forms. Further,
1.Handlers allow you to centralize the code. This makes it easier to develop, maintain and debug the code.
2.Handlers also have packaged procedures called form.
3.These reside in program units or in stored packed in the database.
Types of Handlers are:
What are security Attributes?
Oracle self-service web applications use security attributes to allow data rows to be accessible to specified users’ responsibilities.
What are the steps involved in developing a flex field?
The steps are:
●Design the table structure
●Then, create fields on the form (Visible/Hidden)
●Next, call appropriate routines
●Register the flex field.
●Define the flex field.
ORACLE APPS SCM TECHNICAL INTERVIEW QUESTIONS ANSWERS
These Oracle SCM interview questions will help you build your career. If you are looking for the best training in Oracle Fusion, enroll with us now.
Look at some more technical oracle apps SCM interview questions which are often asked in the interview:
How can businesses use Oracle Applications flexfields to their benefit?
The following businesses needs are served by FlexField:
●Businesses can query the key fields.
●Customize applications to collect data that is not been tracked.
●Allow customizing the data fields without programming.
●Helps in validating the values.
What are different types of invoices? Explain a recurring invoice?
There are 6 types of Invoices:
●Credit Memo Invoice
●Debit Memo Invoice
●Recurring Invoice With-hold tax Quick Match, and
Recurring Invoice is the invoice that occurs at regular interval.
What do you understand by concurrent Program?
These are the programs that run in the background without interrupting the user. These are batch jobs that push and fetch data between the applications and database.
What are the steps to register Reports as Concurrent Program?
The steps are as follow:
●Develop a report.
●Save it in the local machine.
●Upload it into custom_top/11.5.0/reports/us/
●Now, go to the system administrator and open executable form.
●Create an executable. Mention executable method as reports (report name).
●Go to cc program form and create ccprogram by attaching executable name in the Executable Section.
●Now, attach the ccprogram to the request group.
●Finally, attach Request group to Responsibility and then Responsibility to the User.
What is Schema and Apps Schema?
Schema: It is a location in a database that contains database objects including tables, views, synonyms, etc.
Apps Schema: Used to connect the all schemas to fetch information from the database.
What is the difference between Function and Menu?
A function is a part of an application. These are registered under a unique name.
Whereas, a menu is a hierarchical arrangement of functions. Each responsibility has a menu allotted to it.
What is a Value Set?
It is a collection of values. A value set offers a list of values to the end-user enabling them to accept one of the values as a report parameter value.
Differentiate between Bind and Lexical parameters?
LEXICAL REFERENCE: These can be used to replace the clauses that appear AFTER select,
group by, from, having, start with, connect by. A user cannot make lexical reference in pl/sql statements.
BIND VARIABLES: These are used to replace a single value in sql, pl/sql. These can be used to replace expressions in where, select, order, group, by, connect by, having, start with cause of queries.
Define the Request Group?
It is the collection of requests, concurrent programs, and request sets that a user can select from the Submit Requests window. The user here should be operating under a given responsibility.
What are the different Validation Types?
●Dependant & Independent
●Pair and None
●Special and Table
What is a Token?
Tokens are used to transfer values to the report builder. These are not case sensitive.
If you need any further assistance, contact experienced professionals at IQ Stream. And to enrol into any of our Oracle Fusion Training programs, https://www.iqstreamtech.com/contact-us/