is there a way to customize the error message going to IP_IN_QUEUENo, it cannot be customized as B2B generates it automatically as per a predefined format.
Is this the only way to go to B2B_InstanceMessage to get the order number to find out the failed transaction?You should use xpath functionality of B2B 11g. In the document definition, under xpath tab, you may provide the xpath of Order number and at runtime B2B will evaluate the XPATH and store it's value in xpath_value column. So to get order number, you need not to query the payload. You may provide three xpath's at max for a doc def. You may refer -