Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Atul Kumar
    Invoice getting rejected with Invalid PO Number error
    Topic posted December 20, 2018 by Atul KumarBronze Medal: 1,250+ Points, last edited February 6, 2019, tagged Accounting Hub Cloud Service, Assets, Budgetary control, Cash Management, Collections, Configuration, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, Invoice Imaging, OTBI, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Search, Setup, Setup / Administration, Subledger Accounting, Subscriptions, Tip 
    325 Views, 21 Comments
    Title:
    Invoice getting rejected with Invalid PO Number error
    Summary:
    Invoice getting rejected in Inteface with Invalid PO Number error
    Content:

    We are trying to create invoice in oracle using EDI and we have noticed that for particular LE/BU the invoice is getting processed and for other LE/BU, the invoices are getting rejected with Invalid PO Number, please let me know if we can overcome this issue, i have raised SR as well on the same...

     

    Thanks,

    Atul Kumar

    Comment

     

    • Felix Beaudoin

      Hey Atul!
      Is the AP invoice on the same BU than the PO being linked to that invoice?
      Seems like it is not recognizing your PO number as part of either that data set linked to the BU or it is not part of a Shared Services model so you cannot fetch the PO for that invoice.
      Let me know, thanks!
      Regards,
      Felix

      • Atul Kumar

        Hi Felix -

        We have centralized procurement BU and we have centralized Bill To BU but different Sold To LE, please find attached PO screen shot.  

        Yes, its not recognizing the PO, please let me know how we can fix this issue. We are able to create invoice successfully from UI by passing the PO number

        Appreciate your help.

        Thanks,

        Atul Kumar

        • Felix Beaudoin

          Thanks for the update Atul!
          Based on what you are saying, it works perfectly fine when you manually create the invoice and link the PO but when you do it through an interface, it rejects that record?

          • Atul Kumar

            Yes, thats correct. Please let me know if you faced this issue and how we can resolve this issue.

            • Felix Beaudoin

              Ok, thanks for the update. You face the error message when you run the import into Oracle itself or is it when you populate the staging tables?
              I've seen multiple issues around the import process where if you select the BU when creating the import, it will fail.
              Also, you need to make sure that the user running the import process has a DEFAULT_ORG in the Administrator Profile Values or it will face issues picking-up the records being imported as well.

              • Atul Kumar

                Hi Felix - Its rejecting in the interface when running Invoice Import

                • Felix Beaudoin

                  Can you please share the Parameters you are running to import the invoices?

                  • Atul Kumar

                    Im passing 

                    Ledger and

                    Source as B2B XML as we are loading it via EDI.

                    • Felix Beaudoin

                      Interesting. I don't see anything wrong there. Can you please share the exact error message you are receiving?

                      • Atul Kumar

                        The problem is, its not showing all the records in the excel however its showing others within same source B2B XML, im trying to find the table name which pulls the data on excel sheet

                          • Atul Kumar

                            I already have these tables:

                            select * from ap_invoices_interface order by creation_date desc
                            Select * from ap_invoice_lines_all order by CREATION_DATE desc
                            select * from ap_invoice_Lines_interface order by creation_date desc

                             

                            Im looking for error table where i can see the error message

                            • Felix Beaudoin

                              AP_INTERFACE_REJECTIONS

                              https://docs.oracle.com/en/cloud/saas/financials/18b/oedmf/AP-tables.html

                              • Atul Kumar

                                I don't see the Invoice in rejection table but in the AP_interface table, its showing as rejected. Where else can we find the rejected invoice details...Thanks

                                • Atul Kumar

                                  I still see its showing invalid PO number while running Invoice import, looks like its not able to recognize the PO for some reason. Do you think its setup issue or a bug?

                                • Atul Kumar

                                  I still see its showing invalid PO number while running Invoice import, looks like its not able to recognize the PO for some reason. Do you think its setup issue or a bug?

                                  • Felix Beaudoin

                                    Based on everything you have told me so far, I am really starting to think it's a bug. Especially if it is not populating the Interface Rejections table. Every invoice that gets rejected should populate in that table when there is an error. Raise an SR with Oracle and let us know of the results!

                                    • Atul Kumar

                                      Do you think of any invoice defaulting rules or LE and BU mapping with invoice generation, any setup?

                                      I already raised a SR on this but no response as of now...Thanks for your help. Appreciate it

                                      • Felix Beaudoin

                                        The only setup I think which could be causing this issue is that the LE of the PO is not linked to the Shared Services BU. I don't think that any invoice defaulting rules would cause this. Most likely related to Enterprise Structure setups or a bug with the import.