Query to find the Organization structure of a business

Run this script giving inventory org as the parameter

SELECT MP.ORGANIZATION_CODE,
       HAOU.NAME,

      HAOUBG.NAME BUSINESS_GROUP,
      GSOB.NAME SOB_NAME, /*gsob.short_name,*/
      GSOB.CURRENCY_CODE,
      GSOB.PERIOD_SET_NAME,
      (SELECT SEGMENT1 || ‘.’ || SEGMENT2 || ‘.’ ||SEGMENT3 || ‘.’ ||
              SEGMENT4 || ‘.’ || SEGMENT5 || ‘.’ ||SEGMENT6 || ‘.’ ||
              SEGMENT7 || ‘.’ || SEGMENT8 || ‘.’ ||SEGMENT9
         FROM APPS.GL_CODE_COMBINATIONS
        WHERE CODE_COMBINATION_ID =GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,
      HLE.NAME LE_NAME,
      HLE.VAT_REGISTRATION_NUMBER,
      HOU.NAME OU_NAME
—  ,hri.*
 FROM APPS.HR_ALL_ORGANIZATION_UNITS   HAOU,
      APPS.HR_ORGANIZATION_INFORMATION HRI,
      APPS.MTL_PARAMETERS              MP,
      APPS.GL_SETS_OF_BOOKS            GSOB,
      APPS.HR_LEGAL_ENTITIES           HLE,
      APPS.HR_OPERATING_UNITS          HOU,
      APPS.HR_ALL_ORGANIZATION_UNITS   HAOUBG,
      APPS.HR_ORGANIZATION_INFORMATION HRIBG

WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
  AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
  AND MP.ORGANIZATION_CODE IN (‘V1’)
  AND HRI.ORG_INFORMATION_CONTEXT = ‘Accounting Information’
  AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1
  AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2
  AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3
  AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID
  AND HRIBG.ORG_INFORMATION_CONTEXT = ‘Business Group Information’
  AND HRIBG.ORGANIZATION_ID =HAOUBG.ORGANIZATION_ID; 

Oracle SCM Functional Interview Questions: Purchasing

Purchasing

1. What are the approval hierarchy
2. What approval hierarchy you use in your implementation?
3. How to check what is the approval hierarchy used in your system?                                        Ans: If Use Approval Hierarchy option is enabled in the Financial Options form, it will use the position based hierarchy. If it is disabled then it will use the supervisor based hierarchy.
4. How to send the PO to a person before even approval who has that approval limit not through workflow hierarchy
5. Where to do the setup for specific approval limit for a person?

Oracle SCM Functional Interview Questions: Inventory

Inventory

1. What are different planning methods in Inventory
2. What are the setups for different planning method (Min-Max)
3. What is the concurrent program for the planning
4. What are the setups for expense item?
5. How many key flexfields are there in Inventory?
6. What is the use of sales order KFF?
7. How we can have the item key flexfield with 2 segments, is it possible, if yes then how, if no then why?
8. How will you inactivate the Inventory locations
9. What all setups you have done in inventory organization implementation

Oracle SCM Functional Interview Questions : Order Management

Order Management

1. How can we create a normal order line and a return line in a single order
2. How to change price in sales order line after booking without using any modifier. Is it possible, if Yes how?
3. Advanced Pricing
4. Configurator
5. What is Item validation org and how it is different from Item Master Org
6. Is it possible to do any transaction (receiving) transaction in Item master org?
7. What steps you will do to check if picking did not happen for an order after pick release?
8. What is system parameter and what is its significance?
9. What all setups required for an ATO order?
10. What all setups required for Back to Back order?
11. In an IR, the price of the item, from where it populates?
12. How can you change the price of the item in an IR?
13. How invoice get generated for IR?
14. What is the accounting entry happens for an IR invoice?
15. What is allocation means in sales order and in which step it happens?
16. What is the difference between allocation and reservation?
17. If an item is not allowed to enter in any sales order form, what is the setup behind this?
18. What is the difference between customer ordered and customer order enabled flag?
19. What are the drop shipment setups and explain the flow?
20. What are the tables involved in Drop Shipment
21. What is the difference between Pick Slip and Pack Slip?
22. What is Bill Of Lading?
23. If I want to have single invoice generated for all the lines of a sales order even if the lines were shipped in different delivery, what can I do?
24. What to do if I want to create a same delivery for all the lines of an order even if they were picked in different pick slip and delivery already created for few lines?
25. Any major issue you have faced in order management during implementation from standard oracle process, not customization

Applying Deposit to an AR Invoice

 1.        Create an AR transaction type for Advance Invoice with class Deposit 
 2.        Using this transaction type, create a Deposit for the same customer 
 3.        After receiving the amount from customer against this Deposit Invoice, create a Receipt 
 4.        Apply the receipt with the Deposit 
 5.        Now Create the required Sales order for the customer and ship confirm 
 6.        This will create the end customer invoice with full amount 
 7.        Now query the end customer invoice and apply deposit(Action–> Apply Deposit) by querying the deposit which created earlier 
 8.        Save the transaction and then click the refresh button in the Balance Due block, you can now see the difference amount after Deposit deduction 
 9.        Also you can see all adjustments in the Details button

Note: Final Invoice date should fall in between Deposit Invoice effective dates 

To Query Profile option details for any user or responsibility

SELECT FPO.PROFILE_OPTION_ID,
      FPO.PROFILE_OPTION_NAME,
      FPOT.USER_PROFILE_OPTION_NAME,
      FPOV.LEVEL_ID,
      DECODE(FPOV.LEVEL_ID,
             ‘10001’,
             ‘Site’,
             ‘10002’,
             ‘Appllication’,
             ‘10003’,
             ‘Responsibility’,
             ‘10004’,
             ‘User’,
             FPOV.LEVEL_ID) LEVEL_TYPE,
      FPOV.LEVEL_VALUE,
      DECODE(FPOV.LEVEL_ID,
             ‘10001’,
             ‘Site’,
             ‘10002’,
             (SELECT APPLICATION_NAME
                FROM APPS.FND_APPLICATION_TL
               WHERE APPLICATION_ID =FPOV.LEVEL_VALUE),
             ‘10003’,
             (SELECT RESPONSIBILITY_NAME
                FROM APPS.FND_RESPONSIBILITY_TL
               WHERE RESPONSIBILITY_ID =FPOV.LEVEL_VALUE),
             10004,
             (SELECT DESCRIPTION
                FROM APPS.FND_USER
               WHERE USER_ID = FPOV.LEVEL_VALUE),
             FPOV.LEVEL_ID) LEVEL_VALUE,
      FPOV.PROFILE_OPTION_VALUE,
      FPOV.LAST_UPDATE_DATE,
      FPO.SQL_VALIDATION,
      TRUNC(FPOV.LAST_UPDATE_DATE),
      (SELECT DESCRIPTION
         FROM APPS.FND_USER
        WHERE USER_ID = FPOV.LAST_UPDATED_BY)UPDATED_BY
 FROM APPS.FND_PROFILE_OPTIONS       FPO,
      APPS.FND_PROFILE_OPTION_VALUES FPOV,
      APPS.FND_PROFILE_OPTIONS_TL    FPOT
WHERE FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
  AND FPOT.PROFILE_OPTION_NAME =FPO.PROFILE_OPTION_NAME
  AND FPOV.LEVEL_VALUE =
      (SELECT USER_ID FROM FND_USER WHERE USER_NAMEIN (‘305030341’)) –for user
  /*AND (FPOV.LEVEL_ID = 10003 AND
      FPOV.LEVEL_VALUE IN
      (SELECT RESPONSIBILITY_ID
          FROM FND_RESPONSIBILITY_TL
         WHERE RESPONSIBILITY_NAME LIKE ‘%%’)) –for responsibility*/
  /*AND UPPER(FPOT.USER_PROFILE_OPTION_NAME) LIKE ‘%WMS%TCP%’ — for profile option*/