Accounts Payable Invoice Rejection to OAGIS 10.1 Acknowledge Invoice
The OAGIS 10.1 predefined message definitions for invoice acknowledgment outbound are:
- OAGIS_10.1_ACKNOWLEDGE_INVOICE_COLLAB_MSG_OUT: Use this message definition when you want to send invoice acknowledgments and use CollaborationMessagingService for message delivery.
- OAGIS_10.1_ACKNOWLEDGE_INVOICE_OUT: Use this message definition when you want to send invoice acknowledgments and use either CollaborationMessagingService or CollaborationMessagingV2Service for message delivery.
The message definitions have a predefined, configured email format. When you associate an email delivery method with these message definitions during the setup of outbound collaboration messages for either a service provider or trading partner, the email will have a table with the following columns:
-
Supplier Number
-
Supplier
-
Invoice Number
-
Invoice Date
-
Currency
-
Invoice Amount
-
Line Number
-
Reason
-
Description
In the email properties, the columns appear from one through nine for the configured message definitions. The columns are populated with data as outlined in this table.
getSupplierRejectionsXMLResponse/result or getSupplierRejectionsResponse/result |
Table Columns in Predefined Email |
---|---|
Vendornumber |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="1"]/ColumnValue |
VendorName |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="2"]/ColumnValue |
Invoicenum or Invoicenumber Note: If root is getSupplierRejectionsResponse Invoicenum is mapped or
if root is getSupplierRejectionsXmlResponse Invoicenumber is
mapped.
|
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="3"]/ColumnValue |
InvoiceDate |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="4"]/ColumnValue |
InvoiceCurrencyCode |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="5"]/ColumnValue |
InvoiceAmount |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="6"]/ColumnValue |
Linenumber |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="7"]/ColumnValue |
DisplayedField |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="8"]/ColumnValue |
Description |
EmailContent/EmailBodyTableHeader/ColumnName[@ColumnNumber="9"]/ColumnValue |
Mapping Table
This table shows the data mapping for the OAGIS_10.1_ACKNOWLEDGE_INVOICE_COLLAB_MSG_OUT and OAGIS_10.1_ACKNOWLEDGE_INVOICE_OUT message definitions. You can access the XSD file by exporting the message transformation package for additional information.
getSupplierRejectionsXmlResponse/result or getSupplierRejectionsResponse/result |
OAGIS_10.1_ACKNOWLEDGE_INVOICE_COLLAB_MSG_OUT OAGIS_10.1_ACKNOWLEDGE_INVOICE_OUT |
---|---|
/processOutboundCollaboration/OutboundCollaboration/CollaborationEvent/@testFlag = true() |
AcknowledgeInvoice/@systemEnvironmentCode Note: When testFlag is true, this is set to Test, when testFlag is
not equal to true, this is set to Production
|
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/GlobalSenderIdType |
AcknowledgeInvoice/ApplicationArea/Sender/LogicalID/@schemeID |
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/GlobalSenderId |
AcknowledgeInvoice/ApplicationArea/Sender/LogicalID |
/processOutboundCollaboration/OutboundCollaboration/CollaborationEvent/@testResult |
AcknowledgeInvoice/ApplicationArea/Sender/ConfirmationCodes/ProcessingConfirmationCode |
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/B2bPartnerIdType |
AcknowledgeInvoice/ApplicationArea/Intermediary/LogicalID/@schemeID |
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/B2bPartnerId |
AcknowledgeInvoice/ApplicationArea/Intermediary/LogicalID |
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/ExtPartnerIdType |
AcknowledgeInvoice/ApplicationArea/Receiver/LogicalID/@schemeID |
/processOutboundCollaboration/OutboundCollaboration/ProcessingConfiguration/ExtPartnerId |
AcknowledgeInvoice/ApplicationArea/Receiver/LogicalID |
current-dateTime |
AcknowledgeInvoice/ApplicationArea/CreationDateTime |
/processOutboundCollaboration/OutboundCollaboration/MessageID |
AcknowledgeInvoice/ApplicationArea/BODID |
Invoicenum or Invoicenumber Note: If the root is getSupplierRejectionsResponse Invoicenum is
mapped or if root is getSupplierRejectionsXmlResponse
Invoicenumber is mapped.
|
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/ID |
InvoiceId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/DocumentIDSet[typeCode="InvoiceId"]/ID[typeCode="InvoiceId"] |
ParentId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/DocumentIDSet[typeCode="ParentId"]/ID[typeCode="ParentId"] |
LoadRequestedId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/DocumentIDSet[typeCode="LoadRequestedId"]/ID |
DisplayedField |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/Status/Extension[typeCode="Fields"]/ValueText/@typeCode |
Description |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/Status/Extension[typeCode="Fields"]/ValueText |
Vendornumber |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/ID |
VendorId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/PartyIDSet[typeCode="VendorId"]ID[typeCode="VendorId"] |
VendorName |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/Name |
VendorSiteCode |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/Location/ID |
VendorSiteId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/Location/IDSet[typeCode="VendorSiteId"]ID[typeCode="VendorSiteId"] |
VendorEmailAddress |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/SupplierParty/Contact/EMailAddressCommunication/EMailAddressID |
OrgId |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/CustomerParty/PartyIDSet[typeCode="OrgId"]ID[typeCode="OrgId"] |
TokenName1....TokenName10 |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/Extension[@typeCode="UserArea"]/ValueText/@typeCode |
TokenValue1...TokenValue10 |
AcknowledgeInvoice/DataArea/Invoice/InvoiceHeader/Extension[@typeCode="UserArea"]/ValueText |
Linenumber Note: For each unique line number an InvoiceLine is created.
|
AcknowledgeInvoice/DataArea/Invoice/InvoiceLine/LineNumberID |
DisplayedField Note: For each DisplayedField a Status is created.
|
AcknowledgeInvoice/DataArea/Invoice/InvoiceLine/Status/Extension[typeCode="Fields"]/ValueText/@typeCode |
Description |
AcknowledgeInvoice/DataArea/Invoice/InvoiceLine/Status/Extension[typeCode="Fields"]/ValueText |
Sample Payload
Here's a sample of the transformed outbound payload:
<sendCollaborationDocument xmlns="http://xmlns.oracle.com/apps/scm/cmk" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<CollaborationEvent testFlag="true" testResult="Success">
<CollaborationEventName>InvoiceRejected</CollaborationEventName>
<RecipientKey1>1245</RecipientKey1>
<RecipientKey2>2959</RecipientKey2>
<RecipientKeyType>Supplier Site</RecipientKeyType>
<RecipientEmailID>your.email@test.com</RecipientEmailID>
<ObjectKey1>300100035338808</ObjectKey1>
<ObjectKey2>1002676</ObjectKey2>
<ObjectKey3>Vision Operations</ObjectKey3>
</CollaborationEvent>
<Document>
<tns:getSupplierRejectionsResponse xmlns:tns="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/types/">
<tns:result xmlns:ns1="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/">
<ns1:InvoiceId>123</ns1:InvoiceId>
<ns1:Invoicenum>123</ns1:Invoicenum>
<ns1:Linenumber>1</ns1:Linenumber>
<ns1:InvoiceDate>2021-06-05</ns1:InvoiceDate>
<ns1:InvoiceCurrencyCode>USD</ns1:InvoiceCurrencyCode>
<ns1:InvoiceAmount currencyCode="USD" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">1000</ns1:InvoiceAmount>
<ns1:OrgId>204</ns1:OrgId>
<ns1:VendorId>300100542269069</ns1:VendorId>
<ns1:VendorSiteId>300100542269084</ns1:VendorSiteId>
<ns1:VendorSiteCode>SITE1</ns1:VendorSiteCode>
<ns1:VendorEmailAddress>123@mycompany.com</ns1:VendorEmailAddress>
<ns1:ParentId>300100543623232</ns1:ParentId>
<ns1:LoadRequestId>-1</ns1:LoadRequestId>
<ns1:DisplayedField>Duplicate invoice number</ns1:DisplayedField>
<ns1:Description>Invoice number for this supplier or party already exists.</ns1:Description>
<ns1:TokenName1>INVOICE NUMBER</ns1:TokenName1>
<ns1:TokenValue1>LJ_0624_1a</ns1:TokenValue1>
<ns1:TokenName2 xsi:nil="true"/>
<ns1:TokenValue2 xsi:nil="true"/>
<ns1:TokenName3 xsi:nil="true"/>
<ns1:TokenValue3 xsi:nil="true"/>
<ns1:TokenName4 xsi:nil="true"/>
<ns1:TokenValue4 xsi:nil="true"/>
<ns1:TokenName5 xsi:nil="true"/>
<ns1:TokenValue5 xsi:nil="true"/>
<ns1:TokenName6 xsi:nil="true"/>
<ns1:TokenValue6 xsi:nil="true"/>
<ns1:TokenName7 xsi:nil="true"/>
<ns1:TokenValue7 xsi:nil="true"/>
<ns1:TokenName8 xsi:nil="true"/>
<ns1:TokenValue8 xsi:nil="true"/>
<ns1:TokenName9 xsi:nil="true"/>
<ns1:TokenValue9 xsi:nil="true"/>
<ns1:TokenName10 xsi:nil="true"/>
<ns1:TokenValue10 xsi:nil="true"/>
<ns1:VendorName>LJ_CMK_Supplier_1</ns1:VendorName>
<ns1:Vendornumber>1488256647</ns1:Vendornumber>
</tns:result>
<tns:result xmlns:ns1="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/">
<ns1:InvoiceId>123</ns1:InvoiceId>
<ns1:Invoicenum>1234</ns1:Invoicenum>
<ns1:Linenumber>20</ns1:Linenumber>
<ns1:InvoiceDate>2021-06-05</ns1:InvoiceDate>
<ns1:InvoiceCurrencyCode>USD</ns1:InvoiceCurrencyCode>
<ns1:InvoiceAmount currencyCode="USD" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">1000</ns1:InvoiceAmount>
<ns1:OrgId>204</ns1:OrgId>
<ns1:VendorId>300100542269069</ns1:VendorId>
<ns1:VendorSiteId>300100542269084</ns1:VendorSiteId>
<ns1:VendorSiteCode>SITE1</ns1:VendorSiteCode>
<ns1:VendorEmailAddress>123@mycompany.com</ns1:VendorEmailAddress>
<ns1:ParentId>300100543623243</ns1:ParentId>
<ns1:LoadRequestId>-1</ns1:LoadRequestId>
<ns1:DisplayedField>Inconsistent price, quantity, and amount</ns1:DisplayedField>
<ns1:Description>Unit price, invoiced quantity, and line amount are not consistent.</ns1:Description>
<ns1:TokenName1>x</ns1:TokenName1>
<ns1:TokenValue1>xValue</ns1:TokenValue1>
<ns1:TokenName2 xsi:nil="true"/>
<ns1:TokenValue2 xsi:nil="true"/>
<ns1:TokenName3 xsi:nil="true"/>
<ns1:TokenValue3 xsi:nil="true"/>
<ns1:TokenName4 xsi:nil="true"/>
<ns1:TokenValue4 xsi:nil="true"/>
<ns1:TokenName5 xsi:nil="true"/>
<ns1:TokenValue5 xsi:nil="true"/>
<ns1:TokenName6 xsi:nil="true"/>
<ns1:TokenValue6 xsi:nil="true"/>
<ns1:TokenName7 xsi:nil="true"/>
<ns1:TokenValue7 xsi:nil="true"/>
<ns1:TokenName8 xsi:nil="true"/>
<ns1:TokenValue8 xsi:nil="true"/>
<ns1:TokenName9 xsi:nil="true"/>
<ns1:TokenValue9 xsi:nil="true"/>
<ns1:TokenName10 xsi:nil="true"/>
<ns1:TokenValue10 xsi:nil="true"/>
<ns1:VendorName>LJ_CMK_Supplier_1</ns1:VendorName>
<ns1:Vendornumber>1488256647</ns1:Vendornumber>
</tns:result>
</tns:getSupplierRejectionsResponse>
</Document>
</sendCollaborationDocument>