Posts

Showing posts with the label B2B

B2B Trading Partner Lookup sql query

How B2B looks for the Trading Partner Agreement in the MDS database SELECT * FROM DEV_SOAINFRA.B2B_LIFECYCLE WHERE ((SENDER_NAME        = <Sender Name e.g. MyCompany>) AND ((RECEIVER_NAME        = <Recipient Name e.g. ACME>) AND ((DOCTYPE_NAME         = <Document Name e.g. CUSDEC>) AND ((DOC_PROTOCOL_VERSION = <Document version e.g. D96B>) AND ((DIRECTION            = <Can be INBOUND or OUTBOUND>) AND (STATE                 = 'Active'))))));

Custom character set in Oracle B2B

Image
To add a custom character set in B2B follow the steps: 1. In Oracle B2B Document Editor, click Tools > Character Set Registry. In the Character Set Registry window, select the character set you want to duplicate. 2. Click the Duplicate icon, or Right click and Duplicate. 3. In the Duplicate Character Set Properties window, accept the defaults and add any other characters at the end of the Charset blank; then click OK. 4. Right click on the Custom Character Set and click the Export icon. Name the file CUST.cs and save it. 5. Copy CUST.cs to SOA_HOME\soa\thirdparty\edifecs\XEngine\config\charsets 6. Edit SOA_HOME\soa\thirdparty\edifecs\Common\Modules\XEngine.dat and add the entry File=XEngine\config\charsets\CUST.cs 7. Restart the SOA server.