table

Hello, I enable a thirdy part software to call jde-orchestrator in order to perform a business process. I do it via the following steps: 1. thirdy part calls orchestrator service "/tokenrequest" in order to obtain the token; 2. thirdy part calls another orchestration. In which table JDE stores...

Hi, I'm positive there is no similar question thats why posting this as a new thread. I added a new field into a standard table(added the column as a last column in the table, also the field is a custom DD item i just now created). I have updated the primary key(Index) of the table to contain...

Anyone can help me, where can I find in wich table is this data?

Hi all, Sorry if this is a very basic/silly question. The Goal I'm looking (in the JDE 910 Schema) for either: A table and column corresponding to Net Sales for items sold; OR (if a single Net Sales column does not exist) Tables or columns that would contribute to the calculation of Net...

Hi everyone , I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to...

HI everyone , I just had my training on jde, and as i am still fresh i need some help. I have a custom table , based on F4141 . The whole point is , i am supposed to receive a csv file , check the quantity , and if it's different than the original that was stored on the F4141 , to update the...

Hi all. I need to write a price audit report. The BA says the business view need to be a left outer join on F42199 and F42199 (ledger). (not a typo) Has anyone done a business view with the same tables? BSVW designs let me do it. I'm wondering if there is anything I need to watch out for and...

is it possible to populate PY tables but not DV or PD ?? -- Company is not using JDE budgeting tables... can the PY tables loaded with external data to do "mock-up" budgeting and forecasting?

So when I do some work on the front end of JDE in the GL what occurs as a result in the back end? Regarding the tables for example.

Hi We are (unfortunately) still using JDE B7334 with an Oracle 11G1 database. We are currently implementing a mobile application and we have a new table that acts as an interface between JDE and the mobile app. The application requires a Notes field which we would like to be at least 4000...

Dear All, I got the requirement to add new field to existing table. Table in already in PD and it has data in it. as per my knowledge we have to create index and generate the table in PD once the modified table in promoted to PD from PY. now I am in confusion, after adding the field I will...

I have a requirement to store IP addresses in a JDE table. I am having trouble defining the data element to do so. I am sure that this is an easy question, but can anyone share a DD item that can store the IP address (of the form 10.1.1.1)? I should be able to use a text field, but when I enter...

We've just released a new free tool, which as the name suggests, allows you to export whole JDE tables into XML. It uses JDE functionality, so the resulting files are compatible with and importable with R98403XA. 1) The export process is remarkably fast, so this process can be used for DB...

We've just released a new free tool, which as the name suggests, allows you to export whole JDE tables into XML. It uses JDE functionality, so the resulting files are compatible with and importable with R98403XA. 1) The export process is remarkably fast, so this process can be used for DB...

We are on XE and have a developer set up who can check most objects in and out but with regard to tables, he can check them out but not back in. Anyone know how to rectify this?

Hi, I have a Table with a Trigger on the BeforeRecordIsInserted event. I'm using this table on a Table Conversion as the output table, so that event should be executed in every insert. However, it is not doing this, the table conversion inserts the table but never calls the trigger. From other...

Hi, If you create a Table Conversion for copying data from one table (F0911) to another (F55911) and with a data selection, for example GLPOST='P', my question is, will the database use the appropriate index by GLPOST although you are not pointing to it becase you only selected F0911 as Input...