6 Replies Latest reply: May 11, 2012 12:31 PM by 932844 RSS

    Bill and Routing Interface concurrent program is not processing component

    932844
      Hi All,

      While running Bill and Routing Interface concurrent program,not processing the component item(Line Item) from bom_inventory_comps_interface,still it show process flag as 1. where as billing item(Header Item) is successfully done..i have tried with all the option by giving component sequence id and batch id still it is not processing component item..
      Is it recommendable to give bill sequence id and component sequence id in interface table using bom_inventory_component_s sequence..

      I will be very pleased if i listen from u guys... Plz help me in resolving this issue..

      My Header Insert Stmt..

      INSERT INTO apps.bom_bill_of_mtls_interface@system_link_visma
      (assembly_item_id, organization_id,
      alternate_bom_designator, last_update_date,
      last_updated_by, creation_date, created_by,
      revision, item_number, item_description,
      implementation_date, transaction_type,
      process_flag, assembly_type, batch_id
      )
      VALUES (l_inv_item_id, l_org_id,
      NULL, SYSDATE,
      1318, SYSDATE, 1318,
      l_revision, l_item_num, l_description,
      SYSDATE, 'CREATE',
      1, 1, 10003535
      );

      Component Insert stmt

      INSERT INTO apps.bom_inventory_comps_interface@system_link_visma
      (operation_seq_num, component_item_id,
      item_num, basis_type, component_quantity,
      auto_request_material, effectivity_date,
      disable_date, planning_factor,
      component_yield_factor,
      enforce_int_requirements,
      include_in_cost_rollup, wip_supply_type,
      supply_subinventory, supply_locator_id,
      check_atp, optional,
      mutually_exclusive_options,
      low_quantity, high_quantity,
      so_basis, shipping_allowed,
      include_on_ship_docs, required_to_ship,
      required_for_revenue, component_remarks,
      transaction_type, process_flag,
      assembly_item_id, component_item_number,
      batch_id,component_sequence_id
      )
      VALUES (l_operation_seq, l_comp_item_id,
      cur2.item_sequence, l_basis, cur2.quantity,
      l_auto_request_mtls, cur2.from_date,
      cur2.TO_DATE, cur2.planning_factor,
      cur2.yield_factor,
      l_enforce_int_requirements,
      l_include_in_cost_rollup, l_supply_type,
      l_supply_subinventory, NULL,
      l_check_atp, l_optional,
      l_mutually_exclusive_options,
      cur2.minimum_quantity, cur2.maximum_quantity,
      l_sale_order_basis, l_shippable_flag,
      l_include_on_ship_docs, l_required_to_ship,
      l_required_for_revenue, cur2.comments,
      'CREATE', 1,
      l_inv_item_id, l_comp_item_num,
      10003535,apps.bom_inventory_components_s.nextval@system_link_visma
      );

      For Subcomponent Insert Stmt

      INSERT INTO apps.bom_sub_comps_interface@system_link_visma
      (substitute_component_id,
      substitute_item_quantity,
      assembly_item_id, component_item_id,
      operation_seq_num, organization_id,
      substitute_comp_number,
      component_item_number,
      assembly_item_number,
      transaction_type, process_flag,
      enforce_int_requirements,
      effectivity_date,component_sequence_id,batch_id
      )
      VALUES (l_sub_comp_item_id,
      cur3.quantity,
      l_inv_item_id, l_comp_item_id,
      cur2.operation_sequence, l_org_id,
      l_sub_comp_item_num,
      l_comp_item_num,
      l_item_num,
      'CREATE', 1,
      l_enforce_int_requirements,
      SYSDATE,apps.bom_inventory_components_s.currval@system_link_visma,10003535
      );

      Thanks
      Raman Sharma

      Edited by: 929841 on May 4, 2012 12:28 AM

      Edited by: 929841 on May 4, 2012 2:58 AM
        • 1. Re: Bill and Routing Interface concurrent program is not processing component
          Sandeep Gandhi, Consultant
          You need to populate the organization_id or organization_code in bom_inventory_comps_interface.

          Here is a minimal insert
          INSERT INTO bom.bom_inventory_comps_interface
                      (operation_seq_num, last_update_date, last_updated_by,
                       creation_date, created_by, process_flag, transaction_type,
                       bom_item_type,
                       effectivity_date, organization_code, assembly_item_number,
                       item_num, component_item_number, component_quantity
                      )
               VALUES (1                                                   -- op_seq_num
                       ,SYSDATE, 1433
                       ,SYSDATE, 1433, 1                                  -- process_flag
                       ,'Create',
                       4 -- bom_item_type 1 Model; 2 Option class; 3 Planning; 4 Standard; 5 Product family
                       ,SYSDATE - 1, 'PUB', 'SSGPARENT1'          -- assembly_item_number
                       ,10                                                     --item_num
                       , 'SSGCOMP1'                           -- component_item_number
                       , 10                                          --qty
                      )
          Sandeep Gandhi
          • 2. Re: Bill and Routing Interface concurrent program is not processing component
            932844
            Hi Sandeep...


            Thanks a lot for ur answer..Asembly Item and component item is successfully processed but while processing substitue component item,process flag become 3 and program end with warning..
            Log file error message is as follows

            "You cannot insert, update or delete substitute component 200-A because its parent component WD-VC2-SUV9 does not exist for item CM62000."

            Please help me in coming out of this error..

            Thanks
            Raman Sharma
            • 3. Re: Bill and Routing Interface concurrent program is not processing component
              Sandeep Gandhi, Consultant
              Try doing this in 2 steps.
              First create the bom header and component.
              Once that is imported, then create the substitute by inserting records in BOM_SUB_COMPS_INTERFACE and creating a row in bom_inv_comps_interface as update.

              Sandeep Gandhi
              • 4. Re: Bill and Routing Interface concurrent program is not processing component
                932844
                Hi Sandeep,

                I am able to import header and component without giving substitute component,But while importing subtitute component it is giving warning..

                I didn't understand your logic for inserting records in BOM_SUB_COMPS_INTERFACE and creating a row in bom_inv_comps_interface as update.


                Thanks
                Raman Sharma
                • 5. Re: Bill and Routing Interface concurrent program is not processing component
                  Sandeep Gandhi, Consultant
                  If you are having problem creating the substitute, I was suggesting that you can try to create the BOM first and then create the substitute as a separate update to the BOM component record.

                  Sandeep Gandhi
                  • 6. Re: Bill and Routing Interface concurrent program is not processing component
                    932844
                    Hi Sandeep,

                    Thanks for your suggestion.It was problem with dates.Component and substitute component both effective dates was different,because of this program ended with the warning.Now i able to resolved it..

                    Thanks
                    Raman Sharma