I noticed when F4201.SHTRDC "Trade Discount" field is used this is bypassing / overriding Advanced Pricing logic (no matter of "Pricing Constants" setup).
Essentially we have F4211.SDAEXP "Extended Price" recalculated by using "List Price" (LPRC) minus "Trade Discount", as a...
maybe you need to have your update "in transaction".
I hope it would be sufficient to have an "open" TableIO statement (with "transaction" flag checked) before and a "close" TableIO statement after your update TableIO statament.
this can happen when you are running row security (for example for F0911 table) and posting UBE (R09801) is able to access batch header (F0011) but cannot read / write details.
the reason why I did test F4008 - P4008 - R40081 standard objects is indeed because I saw lots of posting talking about table definition / virtual tables.
Thus this is not my case (in my previous email I wrote "for debug purpose only").
Again: it's a test. I don't need indeed to...
Thank you Neal for your help but my issue is not linked to BSVW objects with table join in different datasources.
I'm talking about a single table / single BSVW in a different datasource.
This is because the "main" datasource is on Oracle DB and the additional datasource is a Microsoft SQL...
Thank you for your answer Zuke,
I know "Multi-row SQLExtendedFetch failed" is pretty generic but:
* The error number (ODBC0000180) is exactly the same reported by Tet (ok, it's a 2002 thread).
* The system behaviour is exactly the same reported by Tet: everything ok using interactive...
I'm experiencing the same issue:
ODB0000180 - Multi-row SQLExtendedFetch failed in Table(1st) Fxxxx
OW Xe + SP24.
It sounds like an issue with ODBC at server level because the UBE works correctly on a fat-client.
Can you recall how did...
I have a problem running a BI-Publisher report I cannot reproduce via BI-Publisher Desktop:
when I'm going to print "big numbers" (milion) I get exponential notation regardless of formatting layout.
In other words:
I can print a number like 345.234,45 but 2.285.268,00 is printed as...
If you are trying to add new FA master records (F1201) via R12800 and FA AAI I think you cannot specify 2 different MCUs in your incoming F0911 record.
In other words:
you are posting an F0911 record representing "Cost Account", thus balance sheet Business Unit. How the system can...
Thank you Peter,
yes I know Unix behave differently but here I'm not running JDE within a Unix server.
It seems to me the difference is between XRCS APIs and embedded BI-Publisher:
with the first one no CR&LF at all.
In order to add CR&LF I found the following tricks:
1. Use XML Notepad...
In order to update and close F0011 this is an example of code I'm using:
RV BatchNo_ICU [ICU] -> mnBatchNumber [ICU]
RV BatchType_ICUT [ICUT] -> szBatchType [ICUT]
"A" -> cPreviousBatchStatus [EV01]
"1" -> cFLAGBatchStatus [EV02]...
I'm currently using B74XML01 which is indeed using XRCS_serializeDocumentToFileWithEncoding API, but I noticed the output XML file does not have any CR-LF.
In other words: opening the XML file with Notepad++ I can see just 1 line, even though all validations seems correct (I'm...
I would also suggest to have a look at Oracle Support site, for example:
E1: 40: Manual Rollback Process of Item Location (F41021) File (P42210/R42210) (Doc ID 625445.1)
There is a standard procedure in order to have F4211 (and other transactional tables) consistent with F41021...