JDE - SETUP P74P501 TO GENERATE R74P501 (Poland Localization) - SPOUG - Spain Oracle Users Group

Hi, I have a doubt about the setup of P74P501 (Poland Localization) when I add a type document in JPK element: The documentation about the creation of file when you execute the report R74P501 says that the elements K_25 to K_38 are into "Sales  VAT Registrer Transactions" section:If you see the explanation of the points K_25 to K_38, the document says "import goods": Then, in P74P501, what type of documents adds? sales or purchase(=import)? Thanks

Related

ELQ-00107 errors when exporting activity data with Bulk REST API (2.0)

I am following the flow described in Bulk API v2.0 Documentation I POST to https://secure.eloqua.com/api/bulk/2.0/activities/exports and get back (note: I'm working in python so this is all deserialized json) {u'createdAt': u'2014-08-14T07:05:17.6413979Z', u'createdBy': u'P D', u'fields': {u'ActivityDate': u'{{Activity.CreatedAt}}',  u'ActivityId': u'{{Activity.Id}}'}, u'filter': u"('{{Activity.CreatedAt}}' > '2014-07-31T23:43:02.080971Z' AND '{{Activity.Type}}' = 'EmailOpen')", u'name': u'blarg3', u'updatedAt': u'2014-08-14T07:05:17.6413979Z', u'updatedBy': u'P D', u'uri': u'/activities/exports/275'} Next I POST to /syncs and get back {u'createdAt': u'2014-08-14T07:05:31.6571126Z', u'createdBy': u'P D', u'status': u'pending', u'syncedInstanceUri': u'/activities/exports/275', u'uri': u'/syncs/17790'} Now (unfortunately) I GET /syncs/17790 and /syncs/17790/logs  {u'createdAt': u'2014-08-14T07:05:31.9330000Z', u'createdBy': u'P D', u'status': u'error', u'syncStartedAt': u'2014-08-14T07:05:32.6570000Z', u'syncedInstanceUri': u'/activities/exports/275', u'uri': u'/syncs/17790'} {u'count': 2, u'hasMore': False, u'items': [{u'count': 0,  u'createdAt': u'2014-08-14T07:05:33.3770000Z',  u'message': u'There was an error processing the export.',  u'severity': u'error',  u'statusCode': u'ELQ-00107',  u'syncUri': u'/syncs/17790'},  {u'count': 0,  u'createdAt': u'2014-08-14T07:05:33.3930000Z',  u'message': u'Sync processed for sync 17790, resulting in Error status.',  u'severity': u'information',  u'statusCode': u'ELQ-00101',  u'syncUri': u'/syncs/17790'}], u'limit': 1000, u'offset': 0, u'totalResults': 2}  All I can find for ELQ-00107 is "ELQ-00107: There was an error processing the {type}." Any thoughts on what I may have done wrong? Pointers on how I can debug further? Thanks! Joel Rothman-Oracle allison.moore Christopher Campbell-Oracle Ryan Wheler-Oracle
Hi pod, Try removing all sub second precision from the date filter elements.  '{{Activity.CreatedAt}}' > '2014-07-31T23:43:02.080971Z' becomes '{{Activity.CreatedAt}}' > '2014-07-31T23:43:02Z'.  Sub-second precision is not supported for activity exports.
Christopher, Adopted your suggestion and everything worked, thanks! Only suggestion I have is to provide more actionable error messages is possible. In this case I don't think the Bulk API Docs fully describe what date formats are to be expected in various inputs and outputs, and it seems to not be uniform. For example, createdAt and updateAt both seem to be returning ISO 8601, including fractional seconds?The ELQ-00107 reported in the logs doesn't give me any information about what might be the problem. Even 'filter failed to parse' would be helpful. Thanks again for your help!
For others who might be looking for these error codes, and are doing an activity export:Another possible cause could be a filter condition that relies on Contact fields/attributes other than the Contact ID. In Bulk API 2.0, an Activity export cannot rely on fields from the Contact as filter conditions.As an example: if you want to export activities only for contacts who have been created within a particular range, you cannot use Contact.CreatedAt in your filter. As a workaround, you'd want to grab the Contact ID for a contact created at the start of your date range, and a Contact ID for a contact created at the end of your date range, and set a filter condition where Activity.Contact.Id is between those two Contact IDs...
Hi Christopher Campbell-Oracle I am facing the same issue. I am trying my request from SOAPUIAs suggested by you i am not using any sub zero second precision Response from export definition: <Response xmlns="https://secure.eloqua.com/api/bulk/2.0/activities/exports">   <createdAt>2014-08-28T22:00:40.5537126Z</createdAt>   <createdBy>Eloqua</createdBy>   <fields>      <ActivityDate>{{Activity.CreatedAt}}</ActivityDate>      <ActivityId>{{Activity.Id}}</ActivityId>      <ActivityType>{{Activity.Type}}</ActivityType>      <AssetId>{{Activity.Asset.Id}}</AssetId>      <AssetName>{{Activity.Asset.Name}}</AssetName>      <AssetType>{{Activity.Asset.Type}}</AssetType>      <ContactId>{{Activity.Contact.Id}}</ContactId>      <Id>{{Activity.Id}}</Id>      <RawData>{{Activity.Field(RawData)}}</RawData>      <VisitorId>{{Activity.Visitor.Id}}</VisitorId>   </fields>   <filter>'{{Activity.Type}}'='FormSubmit' And '{{Activity.CreatedAt}}'>'2014-08-26T00:00:00'</filter>   <name>Example Activity Export</name>   <updatedAt>2014-08-28T22:00:40.5537126Z</updatedAt>   <updatedBy>Eloqua.APIUser1</updatedBy>   <uri>/activities/exports/36</uri></Response>------------------------------------- Response Sync the data for export <Response xmlns="https://secure.eloqua.com/api/bulk/2.0/activities/exports">   <createdAt>2014-08-28T22:03:05.0953641Z</createdAt>   <createdBy>Eloqua</createdBy>   <status>pending</status>   <syncedInstanceUri>/activities/exports/36</syncedInstanceUri>   <uri>/syncs/16</uri></Response>-------------------------------------------- GET https://secure.eloqua.com/api/bulk/2.0/syncs/16 to check the status of sync <Response xmlns="https://secure.eloqua.com/api/bulk/2.0/activities/exports">   <createdAt>2014-08-28T22:03:04.8630000Z</createdAt>   <createdBy>Eloqua</createdBy>   <status>error</status>   <syncStartedAt>2014-08-28T22:03:14.4970000Z</syncStartedAt>   <syncedInstanceUri>/activities/exports/36</syncedInstanceUri>   <uri>/syncs/16</uri></Response>--------------------------------------------Logs. <Response xmlns="https://secure.eloqua.com/api/bulk/2.0/activities/exports">   <count>2</count>   <hasMore>false</hasMore>   <items>      <e>         <count>0</count>         <createdAt>2014-08-28T22:03:16.4330000Z</createdAt>         <message>There was an error processing the export.</message>         <severity>error</severity>         <statusCode>ELQ-00107</statusCode>         <syncUri>/syncs/16</syncUri>      </e>      <e>         <count>0</count>         <createdAt>2014-08-28T22:03:16.4670000Z</createdAt>         <message>Sync processed for sync 16, resulting in Error status.</message>         <severity>information</severity>         <statusCode>ELQ-00101</statusCode>         <syncUri>/syncs/16</syncUri>      </e>   </items>   <limit>1000</limit>   <offset>0</offset>   <totalResults>2</totalResults></Response> Kindly help ThanksVinay
Hi Vinay, The fields in your export definition include Activity.Id twice.  Please remove duplicate field entries and try again.  If you are still getting an error, please post with feedback.
Hi Christopher Campbell-Oracle now it is working for me.thanks for you help.I also feel that logs should give a little more information about the cause of the error. ThanksVinay

Issue trying to create an Opportunity Merge with SOAPUI

Hello, By the following, we are asking for your support, we are having problem trying to do a merge with the opportunity web service with the purpose of adding Items to these opportunities, we are using the merge opportunity payload, we have done everything, but we are stuck because of the next issue:  <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">   <env:Header/>   <env:Body>      <env:Fault>         <faultcode>env:Server</faultcode>         <faultstring>JBO-27024: Failed to validate a row with key oracle.jbo.Key[200000000180 ] in OpportunityEOJBO-25183: Exception in expression "OpportunityEO" trigger "SetPriceList" : oracle.jbo.ListBindingMismatchException JBO-25072: Applying List binding LOV_For_ListaDePrecio_c with given set of values leads to no matching row for a row of type :Opportunity, key oracle.jbo.Key[200000000180 ]</faultstring>         <detail>            <tns:ServiceErrorMessage xsi:type="tns:ServiceRowValErrorMessage" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">               <tns:code>27024</tns:code>               <tns:message>JBO-27024: Failed to validate a row with key oracle.jbo.Key[200000000180 ] in OpportunityEO</tns:message>               <tns:severity>SEVERITY_ERROR</tns:severity>               <tns:detail xsi:type="tns:ServiceErrorMessage">                  <tns:code>25183</tns:code>                  <tns:message>JBO-25183: Exception in expression "OpportunityEO" trigger "SetPriceList" : oracle.jbo.ListBindingMismatchException</tns:message>                  <tns:severity>SEVERITY_ERROR</tns:severity>                  <tns:detail xsi:type="tns:ServiceErrorMessage">                     <tns:code>25072</tns:code>                     <tns:message>JBO-25072: Applying List binding LOV_For_ListaDePrecio_c with given set of values leads to no matching row for a row of type :Opportunity, key oracle.jbo.Key[200000000180 ]</tns:message>                     <tns:severity>SEVERITY_ERROR</tns:severity>                     <tns:exceptionClassName>oracle.jbo.ListBindingMismatchException</tns:exceptionClassName>                  </tns:detail>                  <tns:exceptionClassName>oracle.jbo.script.ExprScriptException</tns:exceptionClassName>               </tns:detail>               <tns:exceptionClassName>oracle.jbo.RowValException</tns:exceptionClassName>               <tns:objectName>OpportunityEO</tns:objectName>            </tns:ServiceErrorMessage>         </detail>      </env:Fault>   </env:Body></env:Envelope> We don't understand so much the cause of this issue because we are writing the correct price book with the item belonging to this price book, and the other information is the correct one.  We have tried to look for this LOV ListaDePrecio_c in the lookups (common and standards) with no success, Could you tell us where we can this?  Please let us some advice about this issue, This is the utilized payload to be checked out.  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/" xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:not="http://xmlns.oracle.com/apps/crmCommon/notes/noteService" xmlns:not1="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:rev1="http://xmlns.oracle.com/oracle/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:act="http://xmlns.oracle.com/apps/crmCommon/activities/activitiesService/">   <soapenv:Header/>   <soapenv:Body>      <typ:mergeOpportunity><typ:opportunity>            <opp:OptyId>200000000180</opp:OptyId>            <opp:OptyNumber>8307</opp:OptyNumber>            <opp:PrimaryOrganizationId>300000000711041</opp:PrimaryOrganizationId>            <opp:CurrencyCode>CRC</opp:CurrencyCode>            <opp:SalesMethodId>300000003287067</opp:SalesMethodId>            <opp:SalesStageId>300000003287072</opp:SalesStageId>            <opp:OwnerResourcePartyId>300000003371316</opp:OwnerResourcePartyId>            <opp:KeyContactId>100000000475912</opp:KeyContactId>            <opp:SalesChannelCd>ZPM_DIRECT_CHANNEL_TYPES</opp:SalesChannelCd>            <opp:ListaDePrecio_Id_c>100000000573395</opp:ListaDePrecio_Id_c>            <opp:ChildRevenue>    <rev:TargetPartyId>100000000452179</rev:TargetPartyId>    <rev:BUOrgId>300000000711041</rev:BUOrgId>    <rev:ResourcePartyId>300000003371316</rev:ResourcePartyId>    <rev:OptyId>200000000180</rev:OptyId>    <rev:InventoryItemId>100000000527529</rev:InventoryItemId>    <rev:InventoryOrgId>300000003286299</rev:InventoryOrgId>    <rev:PriceUOMCode>zzy</rev:PriceUOMCode>    <rev:Quantity unitCode="zzy">1</rev:Quantity>    <rev:WinProb>100</rev:WinProb>    <rev:UOMCode>zzy</rev:UOMCode>    <rev:RevnAmount currencyCode="CRC">692514.00</rev:RevnAmount>    <rev:UnitPrice currencyCode="CRC">692514.00</rev:UnitPrice>      <rev:StatusCode>OPEN</rev:StatusCode>    <rev:ProductType>Item</rev:ProductType>    <rev:CrmCurcyCode>CRC</rev:CrmCurcyCode>            </opp:ChildRevenue>         </typ:opportunity>      </typ:mergeOpportunity>   </soapenv:Body></soapenv:Envelope> Thank you very much. Have a good day.

Cannot get Web service for addBPLineItem() to work

We are using SOAPUI to test the Web Services.  We are using the UnifierWebServicesoap12Binding.  I am having an issue trying to format the request for the addBPLineItem request. I cannot figure out the format of the XML.  Here is what we currently have: <gen:addBPLineItem>    <shortname>xxxx</shortname>    <authcode>xxxx</authcode>    <projectNumber>PRJ-00000091</projectNumber>    <BPName>Precon Payment Applications</BPName>    <BPXML><![CDATA[<List_Wrapper>    <LineXML>        <record_no>PCPAY-0027</record_no>        <_bp_lineitems>            <uuu_commit_short_desc>Precon Test Line 1</uuu_commit_short_descscription>            <_Group_ID>5838</_Group_ID>            <uuu_spa_amt_tp>1500</uuu_spa_amt_tp>            <bItemID>ZZZZZZ.000.000000.0~~ZZZZZZ.ZZZ.000000.0~~ZZZZZZ.ZZZ.ZZZZZZ.0~~ZZZZZZ.ZZZ.ZZZZZZ.Z</bItemID>            <_ContractRecordNo>Precon-0013</_ContractRecordNo>            <uuu_cost_li_type>Lump Sum</uuu_cost_li_type>            <uuu_tab_id>Payment Items</uuu_tab_id>            <_refnum>1</_refnum>            <uuu_sovlinum>1</uuu_sovlinum>            <_cost_allocation>                <short_desc>Temporary Electricity / Generato-Equipment</short_desc>                <bItemID>000000.000.000000.0~~000000.001.000000.0~~000000.001.011530.0~~000000.001.011530.E</bItemID>                <amount>300</amount>                <_refnum>1.1</_refnum>            </_cost_allocation>            <_cost_allocation>                <short_desc>Temporary Electricity / Generato-Labor</short_desc>                <bItemID>000000.000.000000.0~~000000.001.000000.0~~000000.001.011530.0~~000000.001.011530.L</bItemID>                <amount>700</amount>                <_refnum>1.2</_refnum>            </_cost_allocation>            <_cost_allocation>                <short_desc>Temporary Electricity / Generato-Material</short_desc>                <bItemID>000000.000.000000.0~~000000.001.000000.0~~000000.001.011530.0~~000000.001.011530.M</bItemID>                <amount>500</amount>                <_refnum>1.3</_refnum>            </_cost_allocation>        </_bp_lineitems>    </LineXML>    </List_Wrapper>]]></BPXML></gen:addBPLineItem> I have changed BPXML to ItemXML and that returns "XML in null or empty".  I have removed the inner "LineXML" and also changed it to "ItemXML" but to no avail.  Can someone give me a sample of what this should look like.  The documentation for this method does not have a sample. Thank youRudy

Can not implement polar weather plot in local environment

Hello, I am quiet new to Oracle JET and exploring the visualizations. In the course, I have been trying to implement the Polar weather plot(http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataVisualizations&demo=polarWeatherPlot ) in my local environment. There are a few problems I have faced while integrating the provided code in framework. Some of the problems I have solved some others I couldn't and I am stuck right there. The problems are - 1. The JSON data is not provided along with the code. (Fortunately, I found the referred D3 diagram and collected the data from there)2. The CDNs provided for 'require.js' and 'oj-alta-min.css' doesn't work. (Changed to local environment path)3. Presently, getting error saying - "TypeOptions" is undefined. I have tried commenting the TypeOptions, it throws error for Label, tempConverter and so on. These things(TypeOptions, Label, tempConverter etc.) are defined in Demo.js which is provided with the visualization, and I have made sure the JS file is getting loaded. Not sure why I am getting this error. Any help is highly appreciated. Thanks in advance.
1. The JSON data is not provided along with the code. (Fortunately, I found the referred D3 diagram and collected the data from there)here you gohttp://www.oracle.com/webfolder/technetwork/jet/cookbook/dataVisualizations/chart/resources/nyTempData2015.json  2-The CDNs provided for 'require.js' and 'oj-alta-min.css' doesn't work. (Changed to local environment path) which cdn? have a look herehttps://docs.oracle.com/middleware/jet400/jet/developer/GUID-219A636B-0D0B-4A78-975B-0528497A82DD.htm#JETDG-GUID-219A636B-0D0B-4A78-975B-0528497A82DD
Can you tell us what version of JET you are using? Please provide the output from these two commands, when run from the root of your project that is having issues. npm -g list --depth=0npm list --depth=0 Thanks, --jb
Thanks. That helped.

Missing State attribute in HDL Location load

Getting this error message loading a Location object via the HDL Loader process into HCM Cloud. The State attribute value is required. You must enter a value. METADATA|Location|SourceSystemOwner|SourceSystemId|SetCode|EffectiveStartDate|AddressLine1|AddressLine2|Country|LongPostalCode|PostalCode|TownOrCity|LocationCode|LocationNameMERGE|Location|PAYROLLSYSTEM|Location_5531_1|5531|2018/01/01|6041 xxxxx AVE||US|92120|92120|SAN DIEGO|5531.1|TOP xxx xxx COMPANY, INC. Location does not appear to have a 'State' attribute in any of the documentation or sample DAT files, so what am I missing here? What does this error message really mean? Can't find it anywhere in online support. Revision 13.18.02 (11.13.18.02.0)
Have you checked for Region1, Region2 fields. I used the following file and it worked COMMENT ##############################################################################                                                       COMMENT Work Structure Sample files. COMMENT ##############################################################################                                                      COMMENT Business Entity : LocationCOMMENT ##############################################################################METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|LocationCode|LocationName|Description|ActiveStatus|AddressLine1|AddressLine2|TownOrCity|Region1|Region2|PostalCode|CountryMERGE|Location|HA|HA_LOC1|2018/01/01|4712/12/31|COMMON|HA_LOC1|HA Location1|HA Location1|A|200 Some St||Pasadena|Los Angeles|CA|91101|USMERGE|Location|HA|HA_LOC2|2018/01/01|4712/12/31|COMMON|HA_LOC2|HA Location2|HA Location2|A|300 Some St||Pasadena|Los Angeles|CA|91104|USMERGE|Location|HA|HA_LOC3|2018/01/01|4712/12/31|COMMON|HA_LOC3|HA Location3|HA Location3|A|64 N Mar Vista|Suite A|Pasadena|Los Angeles|CA|91106|USMERGE|Location|HA|HA_LOC4|2018/01/01|4712/12/31|COMMON|HA_LOC4|HA Location4|HA Location4|A|111 West St||Pasadena|Los Angeles|CA|91103|US Do refer this link https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2392-sample-hdl-files-for-loadi…  Kind RegardsAshish
Thanks for the suggestions. Still no luck unfortunately. Tried adding the state (CA) to Region1, then also Region2 in a different test. Same error message. The State attribute value is required. You must enter a value.  Neither of those is supposed to be required fields anyway. I can't help but think there should be a definitive reason for it saying State is a missing attribute when there is no State attribute in a Location object, and no mention of State in any of the Location documentation or spreadsheets. I am assuming it means State as in CA/OR/MN, not some other generic error about the 'state' of an object. 
Hi, Can you try creating from front end with the same values and see , other than the value you provide anything else is getting defaulted or something? this is just to ensure with the same set of values you are able to create through front end or not. Regards,Narendra.
Hello Tony, yes, "state" here refers to geographic items like CA (California), AZ (Arizona) and so on. I agree with Asish. From my experience, American addresses use the region1 field to hold the state, while for example Swiss addresses expected the region3 field as "Kanton" (which is the equivalent of a state in Switzerland). However your system may have a different configuration. Please check the address format by country. There you will see, what field will be used for the state. Regards Holger

Categories

Resources