9 Replies Latest reply: Jun 23, 2011 1:32 AM by 593970 RSS

    UPDATE and SEARCH product

    631429
      hi there!!! i'm creating and updating items with the same pl/sql on ebusiness suite (ego_item_pub.process_item) with the following information...

      <proc:P_API_VERSION>1.0</proc:P_API_VERSION>
      <proc:P_INIT_MSG_LIST>T</proc:P_INIT_MSG_LIST>
      <proc:P_COMMIT>T</proc:P_COMMIT>
      <proc:P_TRANSACTION_TYPE>UPDATE</proc:P_TRANSACTION_TYPE>---UPDATE
      <proc:P_ITEM_NUMBER>vane3003</proc:P_ITEM_NUMBER>
      <proc:P_SEGMENT1>vane3003</proc:P_SEGMENT1>
      <proc:P_ORGANIZATION_ID>204</proc:P_ORGANIZATION_ID>
      <proc:P_DESCRIPTION>desc2</proc:P_DESCRIPTION>

      creation woks FINE

      update is returning an error when i execute it through bpel, the error is on the return XML that says "status E" and it returns the org_id and that's it... if i use the wsdl through soapUI it updates successfully

      BPEL error:

      <CambioPIM_CambioPIM_OutputVariable><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="OutputParameters"><db:OutputParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:db="http://xmlns.oracle.com/pcbpel/adapter/db/APPS/EGO_ITEM_PUB/PROCESS_ITEM/">
      <X_INVENTORY_ITEM_ID xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      <X_ORGANIZATION_ID>204</X_ORGANIZATION_ID>
      *<X_RETURN_STATUS>E</X_RETURN_STATUS>*
      <X_MSG_COUNT xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      </db:OutputParameters>
      </part><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="response-headers">[]</part></CambioPIM_CambioPIM_OutputVariable></messages>

      ****************************************************

      for SEARCH we are using GET_USR_ATTRS_FOR_ITEM but it's failing, do you know which are mandatory fields?? what kind or information should i send?? here the bpel input and output:
      <messages><ConsultaPIM_Consulta_InputVariable><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="InputParameters"><InputParameters xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/APPS/EGO_ITEM_PUB/GET_USER_ATTRS_FOR_ITEM/">
      <P_API_VERSION>1.0</P_API_VERSION>
      <P_INVENTORY_ITEM_ID>232211</P_INVENTORY_ITEM_ID>
      <P_ORGANIZATION_ID>204</P_ORGANIZATION_ID>
      <P_ATTR_GROUP_REQUEST_TABLE/>
      <P_ENTITY_ID/>
      <P_ENTITY_INDEX/>
      <P_ENTITY_CODE/>
      <P_DEBUG_LEVEL>0</P_DEBUG_LEVEL>
      <P_INIT_ERROR_HANDLER>FND_API.G_TRUE</P_INIT_ERROR_HANDLER>
      <P_INIT_FND_MSG_LIST>FND_API.G_FALSE</P_INIT_FND_MSG_LIST>
      <P_ADD_ERRORS_TO_FND_STACK>FND_API.G_FALSE</P_ADD_ERRORS_TO_FND_STACK>
      <P_COMMIT>FND_API.G_FALSE</P_COMMIT>
      </InputParameters>
      </part></ConsultaPIM_Consulta_InputVariable><ConsultaPIM_Consulta_OutputVariable><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="OutputParameters"><db:OutputParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:db="http://xmlns.oracle.com/pcbpel/adapter/db/APPS/EGO_ITEM_PUB/GET_USER_ATTRS_FOR_ITEM/">
      <X_ATTRIBUTES_ROW_TABLE xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      <X_ATTRIBUTES_DATA_TABLE xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      *<X_RETURN_STATUS>E</X_RETURN_STATUS>*
      <X_ERRORCODE xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      <X_MSG_COUNT>2</X_MSG_COUNT>
      <X_MSG_DATA xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      </db:OutputParameters>
      </part><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="response-headers">[]</part></ConsultaPIM_Consulta_OutputVariable></messages>


      any clue???

      thanks!!!!!! thanks!! for any help!!
        • 1. Re: UPDATE and SEARCH product
          759762
          Hi Vanessa,

          Unfortunately, I do not have an answer to your questions. But I want to do the same as you want, so maybe you can help me with the knowledge you already have.

          As you mentioned, you can create items using the API "PROCESS_ITEM". I tried it as a web service call with almost the same parameters as you mentioned:

          <q1:InputParameters>
          <q1:P_API_VERSION>1.0</q1:P_API_VERSION>
          <q1:P_INIT_MSG_LIST>T</q1:P_INIT_MSG_LIST>
          <q1:P_COMMIT>T</q1:P_COMMIT>
          <q1:P_TRANSACTION_TYPE>UPDATE</q1:P_TRANSACTION_TYPE>
          <q1:P_ITEM_NUMBER>KHR_WS_01</q1:P_ITEM_NUMBER>
          <q1:P_SEGMENT1>KHR_WS_01</q1:P_SEGMENT1>
          <q1:P_ORGANIZATION_ID>204</q1:P_ORGANIZATION_ID>
          <q1:P_DESCRIPTION>desc2</q1:P_DESCRIPTION>
          </q1:InputParameters>

          But I think, I got an error:

          <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
          - <env:Body>
          - <OutputParameters xmlns="http://xmlns.oracle.com/apps/ego/soaprovider/plsql/ego_item_pub/process_item/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
          <X_INVENTORY_ITEM_ID xsi:nil="true" />
          <X_ORGANIZATION_ID>204</X_ORGANIZATION_ID>
          <X_RETURN_STATUS>U</X_RETURN_STATUS>
          <X_MSG_COUNT xsi:nil="true" />
          </OutputParameters>
          </env:Body>
          </env:Envelope>

          Do you know what that means? Is it telling me, that INVENTORY_ITEM_ID is a mandatory field? And does he ORGANIZATION_ID 204 not exist in my system? Where can I find all existing ORGANIZATION_IDs? And I guess that I should I use "CREATE" as P_TRANSACTION_TYPE, right?

          It would be great, if you could help me out here and again, I'm sorry, that I do not have an answer for your questions...

          btw: If you know already how to use GET_USR_ATTRS_FOR_ITEM, please let know. This is my next step ;-)

          Many thanks,
          Konrad
          • 2. Re: UPDATE and SEARCH product
            631429
            Hi Konrad!

            we've "solved" the situation... for the creation, you're right, you should send "create" as transaction type.. with those values i created the items successfully via webservice... in case that you still see an error, maybe you need to send another parameter.. "P_MASTER_ORGANIZATION_ID" with the same value as your organization_id... this one is 204 and it seems that is a default value....

            btw... your output says some error type "u", you can find some documentation of this inside pl/sql code.. yeah, i know it sounds weird but the documentation is really inside the pl's! hehe.. and the status "u" means "FND_API.G_RET_STS_UNEXP_ERROR" (unexpected error)... inventory id is NOT required.. it is create by PIM and returned as part of success creation message.

            for the case of update and search (get_usr_attr_for_item), some people from india helped us because it seems that the ebusiness suite (pim) web services are not working as they should.. so these people sent me a couple of pl/sql's to search and update items.. unfortunately we couldn't integrate PIM via webservices, instead we made it via pl/sql's through bpel... let me know if these pl/sql's help you so i can send it by mail. The pl code in fact is using the existent pl's but they are modified by the engineers.

            Regards,
            • 3. Re: UPDATE and SEARCH product
              759762
              Hi Vanessa,

              many thanks for your reply and sorry for my delayed answer. I'm on holiday right now... In the meantime, I managed to create items via web service. But still, I'm struggling with update, search and read.
              for the case of update and search (get_usr_attr_for_item), some people from india helped us because it seems that the ebusiness suite (pim) web services are not working as they should.. so these people sent me a couple of pl/sql's to search and update items.. unfortunately we couldn't integrate PIM via webservices, instead we made it via pl/sql's through bpel... let me know if these pl/sql's help you so i can send it by mail. The pl code in fact is using the existent pl's but they are modified by the engineers.
              This would be really, really great. I MUST use web services (bpel is not an option) for my ebs integration. So if you could send me the pl/sql's, I would be more than happy. But to honest, I have no idea how to browse through pl/sql's (for the documentation) or how to implement a new pl/sql. Is this an easy task which you could explain in a few words?

              You mentioned, that get_usr_attr_for_item is used to search items. What about reading detailed information about an existing one? Is there an api for that?

              Best,
              Konrad
              • 4. Re: UPDATE and SEARCH product
                759762
                I really would like to reward your answer, but I cannot find a button to do so... sorry!
                • 5. Re: UPDATE and SEARCH product
                  759762
                  Hi Vanessa,
                  for the case of update and search (get_usr_attr_for_item), some people from india helped us because it seems that the ebusiness suite (pim) web services are not working as they should.. so these people sent me a couple of pl/sql's to search and update items.. unfortunately we couldn't integrate PIM via webservices, instead we made it via pl/sql's through bpel... let me know if these pl/sql's help you so i can send it by mail. The pl code in fact is using the existent pl's but they are modified by the engineers.
                  In case you did not get ma last post, I would like to ask again if you could send me those modified functions.

                  Many thanks,
                  Konrad
                  • 6. Re: UPDATE and SEARCH product
                    631429
                    hi konrad!! sure!! at what email should i send the example pl's?? k.hammerer@tesis.de ???

                    regards,
                    • 7. Re: UPDATE and SEARCH product
                      759762
                      Vanessa Peralta wrote:
                      hi konrad!! sure!! at what email should i send the example pl's?? k.hammerer@tesis.de ???
                      Yeah, if you could send them to this address, this would be great...

                      Best,
                      Konrad
                      • 8. Re: UPDATE and SEARCH product
                        568123
                        Hi,

                        I am also willing to use get_usr_attr_for_item rather PIM webservices. can you please share farther details of using this proc or any sample code will be helpfull.

                        thanks
                        • 9. Re: UPDATE and SEARCH product
                          593970
                          Hi Vanessa,

                          We are too trying to use the GET_USER_ATTRS_FOR_ITEM webservice. Can you please share what all are the parameters i need to pass for that.

                          Regards,
                          S

                          Edited by: user590967 on Jun 22, 2011 11:31 PM