Best Of
Re: Can multiple different Invoice number be given in Invoice search option
Please consider creating an Idea here in the community. If others vote for it, it could be delivered in a future release. It is possible to configure a query to accept a comma-delimited list of invoice numbers as an input variable instead of a single invoice number, so it should be possible to update the form to do the same thing. The user would have the list of invoices they want to find, so formatting them as a list wouldn't add much effort.
Re: Having decimal values in sequence generated column
You could use logminer to reconstruct SQL statements if you want to dig into it. You can also create a trigger to ensure column value is whole number or create check constraint:
SQL> CREATE TABLE TBL(N NUMBER);
Table created.
SQL> ALTER TABLE TBL ADD CONSTRAINT CHECK_IF_WHOLE_NUMBER CHECK(N = TRUNC(N));
Table altered.
SQL> INSERT INTO TBL VALUES(1);
1 row created.
SQL> INSERT INTO TBL VALUES(1.5);
INSERT INTO TBL VALUES(1.5)
*
ERROR at line 1:
ORA-02290: check constraint (SCOTT.CHECK_IF_WHOLE_NUMBER) violated
SQL>
SY.
Re: RPASCE V25: configuring ODA in Planning Application
Hi Andreas,
I have already logged an SR for ODA in MFP.
"Customer needs to request for this feature to be set up."
The Client expectation about ODA is to assist business users on the real time. currently they are checking with the dev team regarding this. once i get more info i'll update here.
In Retail Home we are having an ODA (but haven't raised any SR to enable this ), ODA answers are more generic to retail questions.
Retail home version :25.1.301.0
use cases were mentioned for ODA in AIF:
Re: Why is the job_queue_processes parameter not working in multitenant?
Hello Bruno,
I ran the test on CDB$ROOT to isolate PDB limitation issues.
The same behavior occurs with PDBs, no more than two schedulers are executed simultaneously in each PDB, but when running on different PDBs, than can be more than two schedulers simultaneously in the CDB.
The problem is that we have routines in the application that control parallelism by scheduler, and with only 2 running this compromises performance.
Thanks,
Everson
Re: How to create a message with ZD_SYNC as SYNCED
Hi @Nigar Khan
This is expected behavior, Individual seed data tables are upgrade to dual row set on demand, for example SET1 is created by the 1st patching cycle the table is prepared in, later SET2 is created by the 2nd patching cycle the table is prepared in , after 3rd/4th cycle tables should be fully migrated to dual row set.
The 2 sets will have different counts if the last patch applied inserted/deleted rows from the seed data table. The next time table is prepared for patching by the seed manager the row sets will be synchronized.
The possible values for column ZD_SYNC would be:
SYNCED - Row is synchronized between sets
INSERTED – Row was inserted since last prepare
UPDATED - Row was updated since last prepare
Please refer to the following document for more detailed information on this:
Architectural changes in Seed Data Tables with AD/TXK Delta 8 (Doc ID 2283796.1)
Which means ---> having "INSERTED" value in ZD_SYNC column in the table does not indicate any issue. The functionality (On front end application) should work without any problem.
It should change to SYNCED after your next patching cycle.
Please also refer below note.
How to Synced User-Defined Elements in PAY_ELEMENT_TYPES_F (Doc ID 3018417.1)
Re: Form extension - Add a button
Is there a specific reason why you are trying top replicate the OK button?
Deepeak is correct but I am guessing you are then going to associate an ORCH or LEX to the new button?
You can add this to the OK button ans chose button cliked or post button clicked. Or….
Why not add it to the form level event, End Dialog or record is updated/added. We can associate ORCHs to events as well as controls
Click Associate Orchestrations then click just below the blue line that is around the form, then pick the event (dpending on the form there are different events) Note End Dialog gets executed on closing and 'OKing' a form though
Re: Patch 37960098 (19.28) broke our existing RADIUS implementation. Any SQL*Net parameter workaround?
I have heard from another place in the same situation is that it will be fixed in 19.29. So we will not apply 19.28 and wait until 19.29 is released. Hopefully this is the case.
Re: It is possible to use simultaneous Reservation Orders in an inserted order entered
Hi @User_DRMY4 ,
Please refer to below notes and see if these are helpful:
Unable To Perform Automatic Reservations At Sales Order Entry(Doc ID 1190766.1)
How To Prevent Orders From Being Reserved If The Customer Has An Automatic Hold Applied?(Doc ID 3083954.1)
Thanks,
Vyshali
Re: Travel and Expenses AWE Question regarding Delegate/Proxy
Thank you Pere, I appreciate your guidance.
Jen S