Oracle R12 Supplier Headers, Sites and Contacts Query

  SELECT DISTINCT

         asp.vendor_id,

         asp.segment1 "Supplier Num",

         ASp.vendor_name "Supplier Name",

         ass.vendor_site_code "SITE NAME",

         hou.NAME "Operating Unit Name",

         ass.address_line1,

         ass.city,

         ass.state,

         ass.zip,

         ass.country,

         ass.phone,

         person.person_first_name,

         person.person_last_name,

         pty_rel.primary_phone_number,

         (SELECT HCP5.PHONE_AREA_CODE

            FROM HZ_CONTACT_POINTS HCP5

           WHERE     HCP5.OWNER_TABLE_NAME = 'HZ_PARTIES'

                 AND APSC.REL_PARTY_ID = HCP5.OWNER_TABLE_ID

                 AND HCP5.CONTACT_POINT_TYPE = 'PHONE'

                 AND HCP5.PHONE_LINE_TYPE = 'FAX'

                 AND HCP5.PRIMARY_FLAG = 'N'

                 AND ROWNUM < 2)

            FAX_AREA_CODE,

         (SELECT HCP6.PHONE_NUMBER

            FROM HZ_CONTACT_POINTS HCP6

           WHERE     HCP6.OWNER_TABLE_NAME = 'HZ_PARTIES'

                 AND APSC.REL_PARTY_ID = HCP6.OWNER_TABLE_ID

                 AND HCP6.CONTACT_POINT_TYPE = 'PHONE'

                 AND HCP6.PHONE_LINE_TYPE = 'FAX'

                 AND HCP6.PRIMARY_FLAG = 'N'

                 AND ROWNUM < 2)

            FAX,

         pty_rel.EMAIL_ADDRESS

    FROM ap_suppliers asp,

         ap_supplier_sites_all ass,

         ap_supplier_contacts apsc,

         hz_parties person,

         hz_parties pty_rel,

         hr_operating_units hou

   WHERE     1 = 1

         AND ass.vendor_id = asp.vendor_id

         AND apsc.per_party_id = person.party_id

         AND apsc.rel_party_id = pty_rel.party_id

         AND ass.org_id = hou.organization_id

         AND apsc.ORG_PARTY_SITE_ID = ASS.PARTY_SITE_ID

ORDER BY hou.NAME

Oracle R12 Supplier Bank, Bank Branch and Bank Account Creation Scripts

DECLARE

      x_response_rec          apps.iby_fndcpt_common_pub.result_rec_type;

      l_init_msg_list         VARCHAR2 (2000);

      o_bank_id               NUMBER;

      x_return_status         VARCHAR2 (3000);

      l_msg_count             NUMBER;

      l_msg_data              VARCHAR2 (3000);

      l_msg_dummy             VARCHAR2 (3000);

      l_output                VARCHAR2 (3000);

      l_extbank_rec           apps.iby_ext_bankacct_pub.extbank_rec_type;

      l_ext_bank_branch_rec   apps.iby_ext_bankacct_pub.extbankbranch_rec_type;

      l_bank_acct_rec         apps.iby_ext_bankacct_pub.extbankacct_rec_type;

      out_mesg                apps.iby_fndcpt_common_pub.result_rec_type;

      l_acct                  NUMBER;

      l_assign                apps.iby_fndcpt_setup_pub.pmtinstrassignment_tbl_type;

      l_payee_rec             apps.iby_disbursement_setup_pub.payeecontext_rec_type;

      l_return_status         VARCHAR2 (30);

      l_bank_id               NUMBER;

      l_branch_id             NUMBER;

      l_bank                  VARCHAR2 (1000);

      l_acct_owner_party_id   NUMBER;

      l_supplier_site_id      NUMBER;

      l_party_site_id         NUMBER;

------------------------------------------------------------------------------

-->  BANK

-------------------------------------------------------------------------------

BEGIN

            x_return_status := '';

            l_msg_count := '';

            l_msg_data := '';

            apps.fnd_msg_pub.delete_msg (NULL);

            apps.fnd_msg_pub.initialize ();

            l_extbank_rec.bank_name   := 'Test Supp Bank' ;

            l_extbank_rec.bank_number := 'TSB0000001';

            l_extbank_rec.country_code:= 'IN';

            APPS.IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK (1.0,

                                                       'F',

                                                       l_extbank_rec,

                                                       o_bank_id,

                                                       x_return_status,

                                                       l_msg_count,

                                                       l_msg_data,

                                                       x_response_rec

                                                      );

            l_output := ' ';

            IF x_return_status <> 'S'

            THEN

               FOR i IN 1 .. l_msg_count

               LOOP

                  apps.fnd_msg_pub.get (i,

                                        apps.fnd_api.g_false,

                                        l_msg_data,

                                        l_msg_dummy

                                       );

                  l_output := l_output || (TO_CHAR (i) || ': ' || SUBSTR (l_msg_data, 1, 250));

               END LOOP;

               apps.fnd_file.put_line (apps.fnd_file.output, 'Error Occured while Creating Bank: ');

            END IF;

      COMMIT;

END ;

------------------------------------------------------------------------------

-->  BANK BRANCH

/* Get The Bank ID from Banks */

-------------------------------------------------------------------------------

BEGIN

            x_return_status := '';

            l_msg_count := '';

            l_msg_data := '';

            apps.fnd_msg_pub.delete_msg (NULL);

            apps.fnd_msg_pub.initialize ();

            l_ext_bank_branch_rec.bank_party_id := '70117' --> Get The Bank ID from Banks;

            l_ext_bank_branch_rec.branch_name   := 'Test Supp Bank Branch';

            l_ext_bank_branch_rec.branch_number := 'TSBB000001';

            l_ext_bank_branch_rec.branch_type   := 'SWIFT';

            l_ext_bank_branch_rec.bic           := 'TSBBBIC001';

            APPS.IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH

                                                      (1.0,

                                                       'F',

                                                       l_ext_bank_branch_rec,

                                                       o_branch_id,

                                                       x_return_status,

                                                       l_msg_count,

                                                       l_msg_data,

                                                       x_response_rec

                                                      );

            l_output := ' ';

            IF x_return_status <> 'S'

            THEN

               FOR i IN 1 .. l_msg_count

               LOOP

                  apps.fnd_msg_pub.get (i,

                                        apps.fnd_api.g_false,

                                        l_msg_data,

                                        l_msg_dummy

                                       );

                  l_output := l_output || (TO_CHAR (i) || ': ' || SUBSTR (l_msg_data, 1, 250));

               END LOOP;

               apps.fnd_file.put_line(apps.fnd_file.output,'Error Occured while Creating Bank Branches: ');

            END IF;

        COMMIT;                

END;

------------------------------------------------------------------------------

--> BANK ACCOUNTS

/*  Get the bank ID and Branch ID from Branches and site ID , org id from suppliers */

-------------------------------------------------------------------------------

BEGIN

            l_return_status := '';

            l_msg_count := '';

            l_msg_data := '';

            apps.fnd_msg_pub.delete_msg (NULL);

            apps.fnd_msg_pub.initialize ();

            l_bank_acct_rec.branch_id                    := 70120 ;

            l_bank_acct_rec.bank_id                      := 70117 ;

            l_bank_acct_rec.acct_owner_party_id := 69118 ;

            l_bank_acct_rec.bank_account_num    := 'TSB0000001';

            l_bank_acct_rec.iban                                 := 'TSBIBAN001';

            l_bank_acct_rec.start_date                   := SYSDATE;

            l_bank_acct_rec.country_code                 := 'IN';

            l_bank_acct_rec.currency                    := 'INR';

            l_bank_acct_rec.foreign_payment_use_flag := 'Y';

            apps.iby_ext_bankacct_pub.create_ext_bank_acct

                        (p_api_version            => 1.0,

                         p_init_msg_list          => 'F',

                         p_ext_bank_acct_rec      => l_bank_acct_rec,

                         p_association_level      => 'SS',

                         p_supplier_site_id       => 5467,

                         p_party_site_id          => 64032,

                         p_org_id                 => 98,

                         p_org_type               => 'OPERATING_UNIT',

                         x_acct_id                => l_acct,

                         x_return_status          => l_return_status,

                         x_msg_count              => l_msg_count,

                         x_msg_data               => l_msg_data,

                         x_response               => out_mesg

                        );

            l_output := ' ';

            IF l_return_status = fnd_api.g_ret_sts_error

            THEN

               FOR i IN 1 .. l_msg_count

               LOOP

                  apps.fnd_msg_pub.get (i,

                                        apps.fnd_api.g_false,

                                        l_msg_data,

                                        l_msg_dummy

                                       );

                  l_output := l_output || (TO_CHAR (i) || ': ' || SUBSTR (l_msg_data, 1, 250));

               END LOOP;

               apps.fnd_file.put_line

                             (apps.fnd_file.output,'Error Occured while Creating Bank Account: ');

            END IF;

END;

END;  

--------------------------------------------------------------------------------------------------

Calendar Query in Oracle

SELECT

  LPAD (MONTH, 20 - (20 - LENGTH (MONTH)) / 2) MONTH,

  "Sun",

  "Mon",

  "Tue",

  "Wed",

  "Thu",

  "Fri",

  "Sat"

FROM

  (SELECT TO_CHAR (dt, 'fmMonthfm YYYY') MONTH,

    TO_CHAR (dt + 1, 'iw') week,

    MAX (DECODE (TO_CHAR (dt, 'd'), '1', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Sun",

    MAX (DECODE (TO_CHAR (dt, 'd'), '2', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Mon",

    MAX (DECODE (TO_CHAR (dt, 'd'), '3', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Tue",

    MAX (DECODE (TO_CHAR (dt, 'd'), '4', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Wed",

    MAX (DECODE (TO_CHAR (dt, 'd'), '5', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Thu",

    MAX (DECODE (TO_CHAR (dt, 'd'), '6', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Fri",

    MAX (DECODE (TO_CHAR (dt, 'd'), '7', LPAD (TO_CHAR (dt, 'fmdd'), 2) ) ) "Sat"

  FROM

    (SELECT TRUNC (SYSDATE, 'y') - 1 + ROWNUM dt

    FROM all_objects

    WHERE ROWNUM <= ADD_MONTHS (TRUNC (SYSDATE, 'y'), 12) - TRUNC (SYSDATE, 'y')

    )

  GROUP BY TO_CHAR (dt, 'fmMonthfm YYYY'),

    TO_CHAR (dt + 1, 'iw')

  )

ORDER BY

  TO_DATE (MONTH, 'Month YYYY'),

  TO_NUMBER (week)

Useful Tags in Xml Publisher Publisher Reports

1. Sort Tag :> "sort:VOUCHER_NUM;'ascending';data-type='number'"

2. Row Column Highlighting :> "if@row:position() mod 2=0"

3. Creation of page total Elements : "add-page-total:TotalFieldName;'element'"

4. Displaying Page Total: "show-page-total:TotalFieldName;'Oracle-number-format'"

5. Re grouping: "for-each-group:BASE Group;Grouping Element" , "for-each:current-group(); GROUPING-ELEMENT"

6. Last Page Only : "start@last-page:body" "end body"

7. Variable Declaration : :variable name="lpp" select="number(5)"

8. Assigning Value to Variable : "xdoxslt:set_variable($_XDOCTX, 'variable name', value)"

9. Get Value from Variable : "xdoxslt:get_variable($_XDOCTX, 'variable name')"

10. MICR font can be linked by moving it to a UNIX directory and referencing the location in the Template

11. Extended SQL and XSL Functions : xdofx:expression

12. Dynamic Data Column header : split-column-header:group element name

13 Dynamic Data Column Data : split-column-data:group element name

Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas

Nav : Control Panel -->Regional and Language -->Additional settings -->List Separator change the Comma(,) to Pipe(|)Then you can save file as CSV in excel, and it will use pipe as the delimiter

Oracle Navigations for DBC, Clear Cache, Create New Menu, Functions,Message, Enable Personalize Page, Enable Diagnostics, Database Properties, Right version of Jdev

How to find the location of the DBC file?
1.Login to the application.
2.Click About this page.
3.Go to Page Context.
4.In Database you can find the full path of the DBC file.

Where to do clear cache in the Application?
1.Login to the application.
2.Click on Functional Administrator responsibility.
3.Click on Core Services Tab.
4.Click on Caching Framework.
5.Click Global Configuration on the side bar.
6.Click Clear All Cache.

Where to go and Create New Menu, Functions,Message in Application?
1.Login to the application.
2.Click on Functional Administrator responsibility.
3.Click on Core Services Tab.
4.Click on Menus,Functions,Messages respectively.

How to enable Personalize page option?
1.Login to the application.
2.Click on Functional Administrator responsibility.
3.Click on Core Services Tab.
4.Click on Profiles.
5.Enter Pers%Self% in Name and click Go.
6.In the results you will see Personalise Self-Service Defn.Update it and enter Yes in the Site Value.

How to enable Diagnostics option?
1.Login to the application.
2.Click on Functional Administrator responsibility.
3.Click on Core Services Tab.
4.Click on Profiles.
5.Enter %Diag% in Name and click Go.
6.In the results you will see FND:Diagnostics.Update it and enter Yes in the Site Value.

How to find the database properties like host,port and SID?
1.Login to the application.
2.Click About this page.
3.Go to Page Context.
4.In the Database section you can find these details.

How to find the right version of Jdev for your Application Instance?
1.Login to the application.
2.Click About this page.
3.Click on Technology Components.
4.There you can see the OA Framework version . For example if the the version beside OA Framework is 12.0.4 then download the 12.0.4 patch from metalink.

Creating a Business Event:
1.Login to the application with user name and password as sysadmin/sysadmin.
2. Go to Workflow Administrator Web Applications.
3.Click on Business Events.
4.click on Create Event.

Creating Calendar and Period Types:
1.Login to the application as sysadmin/sysadmin.
2.Click on the responsibility General Ledger,Vision Operations(USA).
3.Click on any of the forms in the functions.
4.Click on Setup->Financials->Calendars->Types.
Similarly click on Accounting for Calendar period.

Oracle AR/AP NETTING

Cash Management setup prerequisites

1. Create a netting bank account
2. Define the bank account at the legal entity level
3. Define the netting control account i.e., cash and cash clearing accounts at bank account level.

Receivables setup prerequisites

1. Create a receipt class with creation method AR/AP Netting and assign the created bank account at receipt class. Usually we use seeded Netting bank account at agreement place
2. Enable the Allow Payment of Unrelated Transactions Receivables System Option.

Steps

1. Post an invoice in account receivables
2. Post an invoice in account payables
3. Create Netting agreement
4. Create Netting batch

1. Post an invoice in account receivables:

Post an invoice in AR module.

2. Post an invoice in account payables :

Navigation:  Invoices < Entry < Invoices

Save

Again Click on Actions …1 and Create Accounting/ final post

3. Create Netting agreement

Navigation: Receipts < AP AR Netting < Netting Agreement

4. Create Netting Batch

Navigation: Receipts < AP AR Netting < Netting Batch

Query with the Netting Batch name in the netting batch field if it shows the error than click on update and add transactions which are not picked .

Than select RECALCULATE and SUBMIT

Note: We cannot update netted receipts in the Receipts workbench

We can reverse the netting batch through Action after Netting in Netting batch

Error may case

• Enter the netting agreement date before the entries to be netted.
• Enter the same cash account and cash clearing account for payables and receivables while creating the bank account.
• And also enter the same cash account at receipt class.

Oracle Order Management Interview Questions

What is a Standard Item?
A standard item is a finished good that is not an assembled or configured item, a service or a component.

What happens when you enter an Order?
After you enter an order, the items on the order are validated in Oracle Inventory; a price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved; the items are then pick released and shipped to the customer.

Explain about Processing Constraints
Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.
Examples:
You cannot change the Order Type in the order header once the order is Booked.
You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

What are Defaulting Rules?
Defaulting Rules enable you to speed up data entry by passing values in the window based on some key values you have entered.
Examples:
In the order header, Ship-To Address and Bill-To Address values default in the window once you enter the customer name or number.
If you enter an item number, the Unit of Measure and Item Description automatically default on the order line.

How Drop Ship Order is created?
Drop shipments are created as sales orders in Order Management, indicated as drop shipments when their Source Type is entered as External.

When will you create a Drop Ship Order?
Drop shipments are used due to the following reasons:
·         Customer requires an item that is not normally stocked
·         Customer requires a large quantity of the item which is not available with you
·         It is more economical when the supplier ships directly to the customer.

What are the types of Drop Ship Order?
There are three types of drop shipments:
Full Drop Shipment:
The seller sends the purchase order to the supplier for the full quantity that the customer had ordered
Normal Shipments and Full Drop Shipment:
The seller ships some goods from inventory to the customer, and the other goods are always shipped from an external source (supplier)
Normal Shipments and Partial Drop Shipment:
If the seller has only part of the quantity available for shipping to the customer, then that quantity is shipped.
The user looks at the availability for the order qty by using the ATP check and if the whole qty is not available the balance qty is fulfilled using the drop ship process.
A purchase order is created for the remaining quantity which the seller was not able to fulfill.

What is a Sales Agreement?
A Sales Agreement is a supplier’s representation of an agreement with a customer for the supplier to sell and the customer to buy goods or services.

What is ASN?
ASN stands for Advanced Shipment Notice. ASN is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number, packing slip data, freight information, and item detail including cumulative received quantities, purchase order number, and returnable container information.

What are Modifiers and Qualifiers?
Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.
A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

Explain One Step Pick Release Process:
The one-step process consists of selecting the Auto Allocate box on the Inventory tab and the Auto Pick Confirm box on the Inventory tab when you run Pick Release, which means that the Pick Recommendation is automatically created and Pick Confirmed without any manual intervention.

Explain Two Step Pick Release Process:
The two-step process consists of selecting Auto Allocate (not Auto Pick Confirm), which creates a move order that is automatically detailed.  It enables you to view the Pick Recommendation and provides the opportunity to change quantity, location, and subinventory. You can report a missing quantity at the Pick Confirmation step in the Transact Move Orders window. Once you have made your changes, you can transact the move order to Pick Confirm the inventory.

Explain Three Step Pick Release Process:
The three-step process consists of selecting neither the Auto Allocate or Auto Pick Confirm check boxes. This creates a move order whose details you can enter manually or automatically in the Transact Move Orders window. After the details are entered, you can transact the move order to pick confirm the transaction.
What are various ways you can run Pick Release?
Release Sales Orders Window
Using a Concurrent Program
SRS – Pick Selection List Generation – SRS.
Release Rule Name need to be specified to proceed with the pick release when using the concurrent program or SRS.

At which stage the item is moved from ware house to staging inventory?
During Pick Confirm

What happens during Ship Confirm?
Ship Confirm indicate that the items are loaded onto the carrier from staging location.
At which stage the Oracle Inventory is decremented and Sales Order Line status is updated?
During Ship Confirm

What is Autoinvoice?
AutoInvoice is a concurrent program in Oracle Receivables that performs invoice processing at both the order and line levels. Once an order or line or set of lines is eligible for invoicing, the Invoice Interface workflow activity interfaces the data to Receivables. Oracle Order Management inserts records into the following interface tables: RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS.

If the order or lines are On Hold, what happens during Invoice Interface?
The Invoice Interface workflow activity will complete with a status of On Hold and the order details will not be interfaced to Receivables.

What is Credit Check?
Credit Checking feature is the process by which orders are validated and released against your credit checking business rules.

What are the two Invoicing Rules?
Advance Invoice and Arrears Invoice

1)      How many types of Purchase Order are there?
Ø  Standard Sales Orders.
Ø  RMA sales Order.
Ø  Back to Back Sales Orders.
Ø  Drop Ship.

2)      What happens when you enter an Order?
After you enter an order, the items on the order are validated in Oracle Inventory; a price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved; the items are then pick released and shipped to the customer

3)      Explain about Processing Constraints
Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.
Examples:
You cannot change the Order Type in the order header once the order is Booked.
You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

4)      What are Defaulting Rules?
Defaulting Rules enable you to speed up data entry by passing values in the window based on some key values you have entered.
Examples:
In the order header, Ship-To Address and Bill-To Address values default in the window once you enter the customer name or number.
If you enter an item number, the Unit of Measure and Item Description automatically default on the order line.

5)      When will you create a Drop Ship Order?
Drop shipments are used due to the following reasons:
·         Customer requires an item that is not normally stocked
·         Customer requires a large quantity of the item which is not available with you
·         It is more economical when the supplier ships directly to the customer

6)      What are Modifiers and Qualifiers?
Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.
A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

7)      At which stage the item is moved from ware house to staging inventory?
During Pick Confirm

8)      What happens during Ship Confirm?
Ship Confirm indicate that the items are loaded onto the carrier from staging location.

9)      What is Auto invoice?
Auto Invoice is a concurrent program in Oracle Receivables that performs invoice processing at both the order and line levels. Once an order or line or set of lines is eligible for invoicing, the Invoice Interface workflow activity interfaces the data to Receivables. Oracle Order Management inserts records into the following interface tables: RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS.

10)  If the order or lines are On Hold, what happens during Invoice Interface?
The Invoice Interface workflow activity will complete with a status of On Hold and the order details will not be interfaced to Receivables.

11)  What are the Inventory Set ups required for Back to Back Order Processing?
Order Management Tab: Customer Orderable, Assemble to Order (ATO), Purchasing Tab: Purchasable, WIP Tab: Build in WIP, General Planning Tab: Buy

12)  What is a Pick Release?
Pick Release finds and releases eligible delivery lines that meet the release criteria, and creates move orders. You can pick release by order, trip, stop, container, delivery, warehouse, and customer, scheduled or requested dates, shipment priority, or combinations of the above criteria.

13)  What is a Pick Slip?
The Pick Slip Report prints all picking line details in a picking batch. This report is used by warehouse personnel to collect all items included in shipments.

14)  What is Ship Confirming?
Ship Confirming the item removes the existing reservations and performs the sales order issue transaction

15)  What is a trip?
A trip is an instance of a specific freight carrier departing from a particular location containing deliveries. A trip is a carrier specific and contains at least two stops, such as a stop to pick up goods and another stop to drop off goods and may include intermediate stops

16)  What is Bill of Lading?
The Bill of Lading prints all sales orders that have been confirmed from a selected delivery. This document lists the ship date, carrier, bill of lading number, delivery name, shipper, ship-to address, carrier name, waybill number, quantity and description of unpacked items, quantity and total of items packed in containers, total quantity of items, and weight/volume information defined in shipping. Any hipping notes you may have created are also printed.

17)  What are the possible reasons for Interface trip stop to complete with Error?
Few reasons may be Order is on Hold, Tax is not applied properly, On-Hand qty is not available in the Inventory, Inventory Period is not open,  Make sure Schedule Ship Date or Requested Date is within the range of order Date.

18)  Explain Internal Sales Order
Internal Sales Orders are used to transfer material from one inventory organization to other inventory or warehouse organization with the same company.
Flow of Internal Sales Order
Internal requisition in PO/INV à Requisition Approval à Run Create Internal Sales Order Concurrent Program à Run Order Import Concurrent Program in OM à Pick Item in INV thru OM à Ship Confirm à Receive Internal Order in INV / PO
Select Order Source as Internal while importing Orders. Shipping Network (Intransit or Direct) to be defined between two organizations (Source and Destination). Destination (requesting) Organization should be defined as Internal Customer with a Ship to address in Order Management. An Internal Sales Order does not generate Accounts Receivable Invoice

19)  When scheduling, the line got error "ATP Error Scheduling failed". How will you resolve?
This error may be due to Item setup in Inventory & Order Transaction Type Setup Order management. Ensure the Below Setups
Ø  Inventory à Items à Organization Items à Order Management à Check ATP should be none.
Ø  Order Management à Setup à Transaction Types à Define. In 'Shipping' sub-tab uncheck 'Auto Schedule' check box.
Ø  Profile Option 'OM: Auto Schedule' should be 'No'.

20)  What is ASN?
ASN stands for Advanced Shipment Notice. ASN is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number, packing slip data, freight information, and item detail including cumulative received quantities, purchase order number, and returnable container information.