Friday 30 October 2015

How to add Telangana in state LOV of india address style.

Log in to Support.oracle.com
Please refer the Oracle Support Documents Document id=1676224.1
Apply the applicable Patch according to your application version

Saturday 17 October 2015

CONTAINERIZATION (CONTAINER) SETUP AND FLOW STEPS IN ORACLE APPS R12

   CONTAINERIZATION SETUP AND FLOW STEPS IN     ORACLE APPS R12

SETUP STEPS:-

Step 1: Navigate to the Item Types window 
            Navigation : Inventory--> Setup--> Items-->Item Types


Step 2: Navigate to the Container Types window 
            Navigation: Inventory --> Setup --> Items --> Container Types


Step 3: Create a Container Item
            Navigate to the Master Item window 
            Navigation: Inventory --> Items --> Master Items 
Step 4: The Physical Attributes for Items are defined to Include in Containers (Load Items)
            Navigate to the Master Item window 
            Navigation: Inventory --> Items --> Master Items
Step 5: Container-Load Relationships for Containers and Items are defined.
            Navigate to the Container-Item Relationships window 
            Navigation: Order Management > Shipping > Setup > Container Load Details 

FLOW STEPS:-

Step 1: Create Sales Order 



Step 2: Enter the item in the sales order which will be packed after picking from the sub inventory.


Step 3: Pick the sales order line quantity .


Step 4: Select the Create LPN Line from the Actions and select the container from the LOV and set                  the prefix for the Container line.


Step 5: Select Packing Workbench from the Actions and click on Go , the LPN item with the                            container details are displayed.


Step 6: Select both the container and item line and then click on ship confirm .


Step 7: After the Delivery search the record with the delivery id and check the status both are shipped             and sales order line is interfaced.










Tuesday 13 October 2015

Windows 10 and Java Update for E-Business Suite 11.5.10.2, 12.1, and 12.2

Windows 10 and E-Business Suite 11.5.10.2, 12.1, and 12.2


Good news for EBS Customer is "Microsoft Windows 10 ( both 32-bit and 64-bit) " is certified as a desktop client operating system for end-users accessing Oracle E-Business Suite 11.5.10.2, 12.1, and 12.2 with the following components.
  • Microsoft Internet Explorer 11 [ Certified to EBS 12.1 ,12.2 and 11.5.10.2 ]
  • Mozilla Firefox ESR 38 [ Certified to EBS 12.1 ,12.2 and 11.5.10.2 ]
  • Java Client Plugin [JRE 1.8.0_51 and higher/JRE 1.7.0_85 and higher]
All E-Business Suite customers encourged to apply all JRE updates to end-user desktops.
You can check details are Steven Chan Blog .
Microsoft Edge Browser
The Edge browser is the new browser included with Windows 10 integrated with the OS and is not a separate install under Program Files. Seems to be more of an APP.
The new default browser "Microsoft Edge" may not work and it will need some time before it gets certified.
The certification of Microsoft Edge on Windows 10 with Oracle E-Business Suite 12.1 and 12.2 is currently in progress. Most likly , there is no plans to certify anything for 11i.[ Source Steven Chan Blog]
Further Reading

BASIC I-PROCUREMENT (iPROC) SET UP STEPS BY STEP

BASIC  I-PROCUREMENT SET UP STEPS

Step-1: I-Procurement Preference set
            Navigation: I-Procurement catalog Administrator > preference> I-Procurement preference
            Favorite List- Create own favorite list
            Delivery- Delivery to location

        


Step-2 Define information templates
           Navigation: India local purchasing> setup> item> informational template
           Define template name
           Select attachment category-  To supplier
           Associate template -Assign the Item





Step 3: Profile Options
            POR : Amount Based Services Line Type - (Fixed Price Services)
            POR : Goods Line Type - (Goods) 
            POR : Rate Based Services Line Type - (Goods)
            PO: Enable Services Procurement(Yes)
            POR: Auto Load Category Descriptors(Yes)
            POR: Auto Load Root Descriptors (Yes)
            POR: Auto Load Shopping Categories(Yes)
            POR: Auto create Shopping Category and Mapping(Yes)
            POR: My Favorite Store(Store that you created)
            IL: Access iprocurement tax information(Yes)

Step 4:  Creation Of store
             Default item information - select from LOV
            Assign information templates- (Select the template that was created)


Step 5: Create Content Zone


Step 6: Create informational content zone

Step 7: Create Store
            Define Name, Description
            Assign Content Zone, Assign Smart Form.

Step 8: Now assign the favorite store from the LOV
            Navigation: I-Procurement> preference> I-Procurement Preference> favorite store

Step 9: Define schema
            Navigation: I-Procurement catalog administrator> Store> Schema

Step 10: Create Purchasing category name
              Select the category and Click on Map tab for mapping to your shopping category

Step 11: Create Non Catalog Request




Step 12: View the Item

             Navigation: India Local i-procurement > shop> Shopping List


NOTE: Requisition to receipt with tax 
Add new Resposibility- India Local iprocurement
Profile option-IL: Access iprocurement tax information





















I-Procurement (iPROC) Process Flow Step by Step

I-Procurement Flow Steps

Step 1: Navigation: India local I-Procurement> Shop> Shopping List


Step 2: Requisition
            In Shopping Cart, Click on View cart and check out






Step 3: Click on submit button for requision submit and reserved for purchase order

     

Step 4: Purchase Order
            Navigation: India Local Purchasing> Auto create



Step 5: India local I-Procurement
            Click on receiving option


Step 6: Click on Express receive button and receive the item

Step 7: Select the requisition and click next button


Step 8: Click on Submit Button


Step 9: Submit your Requisition and create receive number

Step 10: Invoice
              Navigation : India Local Payables> Invoice> Entry> Invoices

Step 11: Click on action button to Validate  invoice
               Select pay in full and click on OK button

Step 12: I-Procurement Responsibility
              Click on "View Receipts" Option then put the receipt number















Monday 12 October 2015

ERROR in "Material cost transaction worker" Request - The inter-organization transfer transaction is from and to the same organization (CST_INVALID_INTERORG).

ERROR in "Material cost transaction worker" Request -  The inter-organization transfer transaction is from and to the same organization.

Step 1:   Check the Error Transactions for which the material cost transaction is showing Error.
               SQL Query

SELECT
     MTT.TRANSACTION_TYPE_NAME,
     COUNT(*) "Total"
FROM
     mtl_material_transactions MMT ,   MTL_TRANSACTION_TYPES MTT
WHERE
         mmt.TRANSACTION_SOURCE_TYPE_ID IN (7,13)
     AND mmt.TRANSACTION_ACTION_ID =12
     AND mmt.costed_flag = 'E'
     AND (mmt.ERROR_CODE LIKE '%CST_INVALID_INTERORG%' or mmt.ERROR_EXPLANATION LIKE '%CST_INVALID_INTERORG%')
     AND MMT.TRANSFER_ORGANIZATION_ID =MMT.organization_id
     AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
GROUP BY
     MTT.TRANSACTION_TYPE_NAME;

Step 2:  After that execute this query to solve the Error

DECLARE
CURSOR  incorrect_mmt is
SELECT  rsl.from_organization_id, rsl.to_organization_id,
        mmt.transfer_organization_id, mmt.organization_id,
        mmt.cost_group_id,mmt.transfer_cost_group_id,
        mmt.xfr_owning_organization_id,mmt.xfr_planning_organization_id,
        mmt.transaction_action_id, mmt.transaction_source_type_id,
        mmt.transaction_id,mmt.fob_point
FROM    mtl_material_transactions mmt,
        rcv_shipment_lines rsl,
        rcv_transactions rt
WHERE   mmt.transaction_type_id IN (12,61)
AND     mmt.transaction_action_id =12
AND     mmt.transaction_source_type_id IN (13,7)
AND     mmt.costed_flag = 'E'
AND     (mmt.ERROR_CODE LIKE '%CST_INVALID_INTERORG%' or mmt.ERROR_EXPLANATION LIKE '%CST_INVALID_INTERORG%')
AND     mmt.transfer_organization_id = mmt.organization_id
AND     mmt.rcv_transaction_id = rt.transaction_id                                              
AND     rt.shipment_line_id = rsl.shipment_line_id;


BEGIN
  dbms_output.enable(500000);

  FOR i IN incorrect_mmt LOOP
   IF ( i.fob_point = 1 ) THEN      ---  If fob_point is shipment
     UPDATE  mtl_material_transactions mmt
     SET     TRANSFER_ORGANIZATION_ID     = i.FROM_ORGANIZATION_ID,
             XFR_OWNING_ORGANIZATION_ID   = i.FROM_ORGANIZATION_ID,
             XFR_PLANNING_ORGANIZATION_ID = i.FROM_ORGANIZATION_ID,
             costed_flag = 'N',
             error_code = NULL,
             error_explanation = NULL,
             transaction_group_id = NULL,
             transaction_set_id = NULL,
             last_update_date   = SYSDATE
     WHERE   transaction_id = i.transaction_id
     AND EXISTS --cost group match the CG of receving org
         ( SELECT COST_GROUP_ID
           FROM cst_cost_groups
           WHERE  COST_GROUP_ID  = i.COST_GROUP_ID
           AND   ORGANIZATION_ID = i.TO_ORGANIZATION_ID
         )
     AND EXISTS -- transfer cost group match the CG of receving org
         ( SELECT COST_GROUP_ID
           FROM cst_cost_groups
           WHERE  COST_GROUP_ID= i.TRANSFER_COST_GROUP_ID
           AND   ORGANIZATION_ID = i.TO_ORGANIZATION_ID
         );
   ELSIF ( i.fob_point = 2 ) THEN       ---  If fob_point is Receiving
     UPDATE  mtl_material_transactions mmt
     SET     TRANSFER_ORGANIZATION_ID     = i.FROM_ORGANIZATION_ID,
             XFR_OWNING_ORGANIZATION_ID   = i.FROM_ORGANIZATION_ID,
             XFR_PLANNING_ORGANIZATION_ID = i.FROM_ORGANIZATION_ID,
             costed_flag = 'N',
             error_code = NULL,
             error_explanation = NULL,
             transaction_group_id = NULL,
             transaction_set_id = NULL,
             last_update_date   = SYSDATE
     WHERE   transaction_id = i.transaction_id
     AND EXISTS --cost group match the CG of receving org
         ( SELECT COST_GROUP_ID
           FROM cst_cost_groups
           WHERE  COST_GROUP_ID= i.COST_GROUP_ID
            AND   ORGANIZATION_ID = i.TO_ORGANIZATION_ID
         )
     AND  EXISTS -- transfer cost group match the CG of shipping org
         ( SELECT COST_GROUP_ID
           FROM cst_cost_groups
           WHERE  COST_GROUP_ID   = i.TRANSFER_COST_GROUP_ID
            AND   ORGANIZATION_ID = i.FROM_ORGANIZATION_ID
         );
   END IF;
  END LOOP;
 
    dbms_output.put_line('**********************************');
    dbms_output.put_line('Congratulations! You have successfully executed script');
    dbms_output.put_line('!!! The script does not COMMIT !!!');
    dbms_output.put_line('Please verify in detail about the results before COMMIT.');
    dbms_output.put_line('End of script..');
END ;
/

Then you need to stop and start the cost manager(Inventory>Interface Manager)


Friday 9 October 2015

PROMOTIONAL GOODS APPLICATION THROUGH ADVANCED PRICING (QP) IN ORACLE SALES ORDER (OM)

PROMOTIONAL GOODS IN ADVANCED PRICING 

SETUP STEPS REQUIRED:

STEP 1:  Create Modifer with Type as Promotion.
               Navigation: Order Management Super User(Responsibility)--> Pricing--> Modifiers.


  •     Mention a criteria eg: Specific Item number to be mentioned


  • Mention the the range of values for which the modifier will work.


  • Mention the Item that will be provided as the promotional item with quantity.


Flow Steps:
Step1: Create the sales order


  • Provide the same item in the order lines while saving it will display a note


  • On saving another line of  promotional goods with quantity will appear.


  • Click on Actions--> View Adjustment (To check the modifier that is been applied).



APPLY COUPONS (DISCOUNT ON SALES ORDER (OM) PRICE) THROUGH ADVANCE PRICING (QP) MODULE IN ORACLE APPLICATION R12






APPLY COUPONS THROUGH ADVANCE PRICING

SET UP Required for creating Coupons: 

Step1: Creating two type of Modifiers:
  •  Discount
  • Coupon Issue
         Navigation:  Oracle Pricing Manager Responsibility--> Modifiers--> Modifier Setup         Modifier for the Discount Purpose .




       Step2:  Modifier for the Coupon issue.

      

 

           Step 3: Run a Request "Build Attribute Mapping Rules" 
                      Navigation: Oracle Pricing Manager(Responsibility)--> View--> Request-->
                      Submit a New Request.


  •   Flow of the sales order with the coupon apply.
Step1: Create the sales order

     




 Step2: Click on Actions--> View Adjustment (Coupon No with be displayed in List Line)

Step3: Create another Sales Order where the coupon is to be applied 



Step 4: Create the Line of the sales order with the same price 500.


Step5: Click on Actions--> Promotions/ Pricing Attributes. Click on coupon tab and select the particular coupon that is been generated.


Step 6: After applying the coupon check the order line the unit price got reduced by 200 amount.