Forum Stats

  • 3,826,928 Users
  • 2,260,726 Discussions
  • 7,897,123 Comments

Discussions

orabpel-11017 - Error during WriteFileAdapter INVOKE

user46999
user46999 Member Posts: 2
edited Sep 15, 2008 7:36AM in BPEL
Im seeing this error on the invoke for my file adapter.

<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="code"><code>null</code>
</part><part name="summary"><summary>file:/appl/BPLDVLP2/BPLDVLP2/10.1.3/bpel/domains/default/tmp/.bpel_DEAMS_CDS_O_006_1.1_827490e1edf9683bdeb0f6b178131bcb.tmp/WriteToCDS_File.wsdl [ Write_ptt::Write(Root-Element) ] - WSIF JCA Execute of operation 'Write' failed due to: Translation Error.
Error while translating message to native format [Caused by: Element 'A_RECORD' not expected.]
; nested exception is:
ORABPEL-11017
Translation Error.
Error while translating message to native format [Caused by: Element 'A_RECORD' not expected.]
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
</summary>
</part><part name="detail"><detail>null</detail>
</part></bindingFault>

The error does not occur If I removed the "for-each" XSLT Construct from the target in the transform activity that I use to map into my custom schema. I think this has to do w/ the nxsd: attributes for Record_A or the header_record.

Any suggestions would be greatly appreciated.



Below is the custom schema I created for the file adapter

<xsd:element name="Root-Element">
<xsd:complexType>
<xsd:choice minOccurs="1" maxOccurs="unbounded" nxsd:choiceCondition="fixedLength" nxsd:length="1">
<xsd:element name="HEADER" nxsd:conditionValue="C" nxsd:style="array" nxsd:arrayLength="354" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="FILE_ID" type="xsd:string" nxsd:style="fixedLength"
nxsd:length="4">
</xsd:element>
<xsd:element name="ADDRESS" type="xsd:string" nxsd:style="fixedLength" nxsd:length="36">
</xsd:element>
<xsd:element name="ORIGINATING_SITE_ID" type="xsd:string" nxsd:style="fixedLength" nxsd:length="2">
</xsd:element>
<xsd:element name="SYSTEM_ID" type="xsd:string" nxsd:style="fixedLength" nxsd:length="5">
</xsd:element>
<xsd:element name="PROCESSING_DATE_OF_FILE" type="xsd:string" nxsd:style="fixedLength" nxsd:length="8">
</xsd:element>
<xsd:element name="AGENCY_LOCATION_CODE" type="xsd:string" nxsd:style="fixedLength" nxsd:length="4">
</xsd:element>
<xsd:element name="TOTAL_NUMBER_OF_TRANSACTIONS" type="xsd:string" nxsd:style="fixedLength" nxsd:length="6">
</xsd:element>
<xsd:element name="TOTAL_VALUE_OF_TRANSACTIONS" type="xsd:string" nxsd:style="fixedLength" nxsd:length="18">
</xsd:element>
<xsd:element name="DATE_FILE_CREATED" type="xsd:string" nxsd:style="fixedLength" nxsd:length="8">
</xsd:element>
<xsd:element name="TIME_FILE_CREATED" type="xsd:string" nxsd:style="fixedLength" nxsd:length="4">
</xsd:element>
<xsd:element name="FILE_SEQUENCE_NUMBER" type="xsd:string" nxsd:style="fixedLength" nxsd:length="5">
</xsd:element>
<xsd:element name="FILLER1" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}">
</xsd:element>

<xsd:choice>
<xsd:element name="A_RECORD" nxsd:lookAhead="0" nxsd:lookFor=" "
nxsd:style="array" nxsd:arrayLength="354">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DOCUMENT_REFERENCE_NUMBER"
type="xsd:string" nxsd:style="fixedLength"
nxsd:length="30"/>
<xsd:element name="VOUCHER_NUMBER" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="15"/>
<xsd:element name="RECORD_TYPE" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="1"/>
<xsd:element name="PAYMENT_DATE" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="8"/>
<xsd:element name="SECURITY_CODE" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="2"/>
<xsd:element name="VOUCHER_CATEGORY" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="1"/>
<xsd:element name="PAYMENT_METHOD" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="1"/>
<xsd:element name="VOUCHER_AMOUNT" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="18"/>
<xsd:element name="CURRENCY_CODE" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="3"/>
<xsd:element name="OFFICIAL_EXCHANGE_RATE"
type="xsd:string" nxsd:style="fixedLength"
nxsd:length="13"/>
<xsd:element name="SUB_VOUCHER_CATEGORY" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="1"/>
<xsd:element name="TECHNICIAN_ID" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="3"/>
<xsd:element name="VOUCHER_STATUS" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="1"/>
<xsd:element name="PAYEE_NAME" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="95"/>
<xsd:element name="DUNS_NUMBER" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="20"/>
<xsd:element name="SSN_TIN" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="9"/>
<xsd:element name="ALGORITHM" type="xsd:string"
nxsd:style="fixedLength" nxsd:length="12"/>
<xsd:element name="FILLER1" type="xsd:string"
nxsd:style="terminated"
nxsd:terminatedBy="${eol}"/>
<xsd:sequence>
<xsd:element name="B_RECORD" nxsd:conditionValue=" "
nxsd:style="array" nxsd:arrayLength="354"
nxsd:cellSeparatedBy="${eol}">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DOCUMENT_REFERENCE_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="30"/>
<xsd:element name="VOUCHER_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="RECORD_TYPE_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="ROUTING_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="12"/>
<xsd:element name="ACCOUNT_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="18"/>
<xsd:element name="ACCOUNT_TYPE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="ADDENDUM_ROUTING_ID"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="FILLER1" type="xsd:string"
nxsd:style="terminated"
nxsd:terminatedBy="${eol}"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="C_RECORD" nxsd:conditionValue=" "
nxsd:style="array" nxsd:arrayLength="354"
nxsd:cellSeparatedBy="${eol}">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DOCUMENT_REFERENCE_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="30"/>
<xsd:element name="VOUCHER_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="RECORD_TYPE_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="ADDRESS_1" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="55"/>
<xsd:element name="ADDRESS_2" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="55"/>
<xsd:element name="ADDRESS_3" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="35"/>
<xsd:element name="CITY" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="35"/>
<xsd:element name="ZIP" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="COUNTRY_CODE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="3"/>
<xsd:element name="FILLER1" type="xsd:string"
nxsd:style="terminated"
nxsd:terminatedBy="${eol}"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="D_RECORD" nxsd:conditionValue=" "
nxsd:style="array" nxsd:arrayLength="354">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DOCUMENT_REFERENCE_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="30"/>
<xsd:element name="VOUCHER_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="RECORD_TYPE_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="DEPARTMENT_REG"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="DEPARTMENT_TRANSFER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="FISCAL_YEAR_PROGRAM_YEAR"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="8"/>
<xsd:element name="TREASURY_MAIN_ACCOUNT"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="4"/>
<xsd:element name="LIMIT" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="4"/>
<xsd:element name="PROGRAM_YEAR" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="FUND_CODE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="FISCAL_YEAR" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="MAJOR_COMMAND"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="OPERATING_BUDGET_ACCOUNT_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="4"/>
<xsd:element name="RESPONSIBILITY_CENTER_COST_CENTER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="6"/>
<xsd:element name="BUDGET_ACTIVITY"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="8"/>
<xsd:element name="OBJECT_CLASS" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="5"/>
<xsd:element name="SALES_CODE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="3"/>
<xsd:element name="ADSN" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="6"/>
<xsd:element name="TRANSACTION_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="APPROPRIATION_AMOUNT"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="18"/>
<xsd:element name="ACRN" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="FMS_CASE_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="3"/>
<xsd:element name="FMS_COUNTRY_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="2"/>
<xsd:element name="EXPENDITURE_AUTHORITY_VERIFICATION"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="IMPLEMENTING_AGENCY_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="FILLER1" type="xsd:string"
nxsd:style="terminated"
nxsd:terminatedBy="${eol}"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="E_RECORD" nxsd:conditionValue=" "
nxsd:style="array" nxsd:arrayLength="354">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DOCUMENT_REFERENCE_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="30"/>
<xsd:element name="VOUCHER_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="RECORD_TYPE_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="1"/>
<xsd:element name="ENTITLEMENT_LOCATION_CODE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="4"/>
<xsd:element name="AMT_PAID_TO_NATIONS_BANK"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="20"/>
<xsd:element name="SSN" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="PAYEE_NAME" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="50"/>
<xsd:element name="VOUCHER_NUMBER_MASTER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="15"/>
<xsd:element name="PAYMENT_DATE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="8"/>
<xsd:element name="PAYMENT_TO_TRAVELER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="9"/>
<xsd:element name="INTEREST_PAID_TO_NATIONS_BANK"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="18"/>
<xsd:element name="TOTAL_AMT_DISBURSED"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="18"/>
<xsd:element name="TRIP_RECORD_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="6"/>
<xsd:element name="INVOICE_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="24"/>
<xsd:element name="INVOICE_DATE" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="8"/>
<xsd:element name="NATIONS_BANK_CBA_HOLDER_DUNS_NUMBER"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="20"/>
<xsd:element name="REMITTANCE_ADVICE"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="10"/>
<xsd:element name="DUNS_4" type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="20"/>
<xsd:element name="TRANSACTION_ID"
type="xsd:string"
nxsd:style="fixedLength"
nxsd:length="9"/>
<xsd:element name="FILLER1" type="xsd:string"
nxsd:style="terminated"
nxsd:terminatedBy="${eol}"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:sequence>
</xsd:complexType>
</xsd:element>

<xsd:element name="Z_RECORD" nxsd:conditionValue="Z" nxsd:style="array" nxsd:arrayLength="354" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="RECORD_TYPE" type="xsd:string" nxsd:style="fixedLength" nxsd:length="14">
</xsd:element>
<xsd:element name="TOTAL_A_RECORD_COUNT" type="xsd:string" nxsd:style="fixedLength" nxsd:length="9">
</xsd:element>
<xsd:element name="SUM_OF_A_RECORDS" type="xsd:string" nxsd:style="fixedLength" nxsd:length="18">
</xsd:element>
<xsd:element name="TOTAL_D_RECORD_COUNT" type="xsd:string" nxsd:style="fixedLength" nxsd:length="9">
</xsd:element>
<xsd:element name="SUM_OF_D_RECORDS" type="xsd:string" nxsd:style="fixedLength" nxsd:length="10">
</xsd:element>
<xsd:element name="Algorithm" type="xsd:string" nxsd:style="fixedLength" nxsd:length="12">
</xsd:element>
<xsd:element name="FILLER1" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
Tagged:

Answers

This discussion has been closed.