1. Configuring and Managing B2B Messaging
  2. Accounts Payable Invoice Rejection to OAGIS 10.1 Acknowledge Invoice

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>