Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Felix Beaudoin
    Sales Orders from OM not being Interfaced into AR -...Answered
    Topic posted December 12, 2018 by Felix BeaudoinGold Crown: 30,000+ Points, last edited February 6, 2019, tagged Financials, Receivables 
    776 Views, 16 Comments
    Title:
    Sales Orders from OM not being Interfaced into AR - AutoInvoice Tables have No Customer Data
    Summary:
    When importing orders into the AR Interface Tables, the Customer Data is not being pulled.
    Content:

    Hello Gurus!
    We are facing an issue which is inconsistent and were hoping that one of you may have faced it in the past (we sure haven't and it is quite confusing).
    Basically, the Order Management team creates an order. They can select the customer, the bill-to and the ship-to. Once processed and shipped, the AR team runs AutoInvoice to create a bill as always.
    For some reason, the customer information is not being populated into the interface tables and we obtain the following error but only for some specific customers (the majority of them go through just fine).

    The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid.; The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid.; The ship-to customer identifier {SHIP_TO_PARTY_ID is invalid.; The ship-to party contact identifier {SHIP_TO_PARTY_CONTACT_ID is invalid. The party contact either does not exist or is not associated to the ship-to party.; The ship-to party site identifier {SHIP_TO_PARTY_SITE_ID is invalid. The party site either does not exist or is not associated to the ship-to party.; The ship-to party site identifier {SHIP_TO_PARTY_SITE_ID is invalid. The party site either does not exist or is not associated to the ship-to party.

    We have had these errors before and know the metalinks related to them but this is brand new and does not relate to any dates being incorrect, data set being invalid, etc.

    Would any of you have experienced this before?
     

    Let us know, thanks!
    Regards,
    Felix

    Best Comment

    Felix Beaudoin

    Ok, so I have the solution for two root causes:

    1- If your customer has just one site, it absolutely must be flagged as Primary for both the BILL_TO and SHIP_TO purposes. Without this, you cannot select the site when creating transactions for the customer.
    2- Any other customer where we cannot see the Ship_to or Bill_to sites, the issue was caused during the data upload. When uploading the CUSTOMER sites and its purposes, you also need to be 100% sure that you also upload these values in the PARTY tables. PARTY_SITES and PARTY_SITE_USES. We identified a total of 46 sites which are impacted by this. Small issue in the conversion but a big headache for figuring out what was wrong. Basically a needle in a hay stack with the amount of records we have!

    So the solution for point 2 is to either end-date those sites and reconfigure them so the PARTY tables are autogenerated OR to keep it 100% clean, you need upload those missing PARTY_SITE_USES through FBDI.

    Thanks for all the support Alexey! I hope that this can be useful for other Gurus facing this issue in the future!
    Cheers,
    Felix

    Comment

     

    • Alexey Shtrakhov

      So those fields are not populated at all?
      Otherwise I would suggest to check your AR source configuration for the Distributed Order Orchestration (DOO) source (Manage Transaction Sources - FSM task). I suppose this source is used for OM transactions on your side as well.
      Check that in the Import Information section <ID> is selected for Customer related fields.

       

       

    • Felix Beaudoin

      Hey Alexey!
      That is correct, the values are not being populated at all but only for a handful of customers. Dozens more are interfacing just fine. These are orders being imported through DOO so the transaction source is seeded and has never been modified. Just to make sure, I did validate it and they are all set to "ID".

      Oracle responded on my SR and indicated the following:
      After running queries on your tables, I think the issue is stemming from the party site use. Per your tables, your sites have a customer party site use of bill to and ship to, but there is no ship to use on party site use table. You need to re-import for that customer adding a ship to party site uses. If you still have the template that your originally used to import the customers, you can just add another line with ship to.

      Just curious as to how this would make any sense? When we load or configure a ship-to and bill-to site, shouldn't it populate the party table as well with the same purposes?
      Let me know what you think.
      Thanks!
      Felix

    • Alexey Shtrakhov

      One verification more. Can you make manual invoices for these customers? and do you see ship-to as well while creating manual invoice?

      Alexey

      • Felix Beaudoin

        Hey Alexey!
        We are able to select this customer for Bill-to but not for the Ship-to.
        Strange that we can select it in Order Management but not in Receivables.
        Felix

        • Alexey Shtrakhov

          hmmm..

          ship-to start date is after the transaction date?
          ship-to is end dated?

          ... check these first... then we can dig deeper

          Alexey

    • Felix Beaudoin

      Order date is Dec-6-2018
      Customer ship-to site date is 25-May-2004
      The site is not end-dated.

    • Alexey Shtrakhov

      is it a separate address or just a ship-to purpose on the same address? (same address has bill-to and ship-to purposes?)

      if it is a separate address can you verify that reference data set is the same as bill-to or your ar user has access to it.

      Alexey

       

      • Felix Beaudoin

        We only have one reference data set for all customer data (Enterprise) and it is just one Address for both bill-to and ship-to. Same address as the order itself.

        • Alexey Shtrakhov

          hmm... is it for all customers same issue? issue that you cannot add ship-to on the manual transaction..

          Alexey

          • Felix Beaudoin

            Nope, just a few customers which Oracle is apparently saying: "When you load customers with ship-to and bill-to sites, you have to assign the PARTY_SITE_PURPOSE of bill-to and ship-to as well".
            It's frustrating that a template let's you basically load useless data without any kind of validation whatsoever.

            • Alexey Shtrakhov

              I guess last question from my side. it is hard doing this blind (not seeing the data)

              Can you please try to create manual transaction for that problematic customer and just try to save it. Will you receive any error during save?


              Alexey

              • Felix Beaudoin

                Hey Alexey!
                I did not receive an error message and was able to create a bill. Still couldn't select the ship-to site though.
                They asked us to run the following:

                Synchronize CRM Search Indexes

                But that also did not resolve the issue.

    • Alexey Shtrakhov

      Hi Felix,

      I think this is finally a really weird issue. You have Ship-To site but you cannot use it due to missing ship-to site use record in party site table... As you have told already I think this shouldn't have happened during the import, but import should block this. Why would you want ship-to site without being able to properly use it in invoicing?

      By the way did you use FBDI template or simplified upload template?

      Alexey

      • Felix Beaudoin

        Hey Alexey!
        Completely agree with your statement above. Oracle should not let us load ship-to site information that we cannot use. It doesn't make any sense that we would want this to be a valid scenario in the first place. System should either reject the information completely or simply auto-generate the PARTY_SITE_USES value so the site can be used for OM and Billing.
        We used the full FBDI to convert all the customer data from EBS 11i to Cloud.
        Currently working with Oracle to test their proposed solution of just loading the PARTY_SITE_USE attribute for one of the customers which is not working to determine if this will fix the issue. If not, I will request a data fix from Oracle since their system has a lack of data validation during upload.
        Will keep you posted!
        Regards,
        Felix

        • Felix Beaudoin

          Hey Alexey!

          Wanted to provide you an update around this issue. After taking with Oracle can basically split-it up into two issues:
          1- AR business users updated configurations which end-dated various sites which we're being processed by OM. The site we're completely end-dated, reconfigured and then the sites in the ADFdi for AutoInvoice were updated. The invoice went through to AR.
          2- The issue where we cannot select the customers whatsoever is different. We queried the tables and the data is there. The purposes are there. The sites are there. Everything is active. We just can't select nor use the customers for billing, orders, receipts, etc. Oracle is stumped and currently doing a full analysis to determine what is wrong with the system.
          Will keep you posted.
          Felix

          • Felix Beaudoin

            Ok, so I have the solution for two root causes:

            1- If your customer has just one site, it absolutely must be flagged as Primary for both the BILL_TO and SHIP_TO purposes. Without this, you cannot select the site when creating transactions for the customer.
            2- Any other customer where we cannot see the Ship_to or Bill_to sites, the issue was caused during the data upload. When uploading the CUSTOMER sites and its purposes, you also need to be 100% sure that you also upload these values in the PARTY tables. PARTY_SITES and PARTY_SITE_USES. We identified a total of 46 sites which are impacted by this. Small issue in the conversion but a big headache for figuring out what was wrong. Basically a needle in a hay stack with the amount of records we have!

            So the solution for point 2 is to either end-date those sites and reconfigure them so the PARTY tables are autogenerated OR to keep it 100% clean, you need upload those missing PARTY_SITE_USES through FBDI.

            Thanks for all the support Alexey! I hope that this can be useful for other Gurus facing this issue in the future!
            Cheers,
            Felix