Skip to main content

Replies posted by Hypervox

77 Replies
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Customer order line - delivery type correction

Does anyone know if it’s possible to change the values via SQL developer?  Does it break the IFS business logic if you do?

2
H
Hero (Customer)
2 months ago
R
Hero (Customer)
romsarHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
CF purchase order lines

If you want the values to be read only, the easiest way is to create read only custom fields on the additional pages, and set the source to be a sql query that refers to your custom field.

3
J
Hero (Customer)
10 months ago
R
Hero (Customer)
romsarHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Trouble to fill the data on a custom page

Regarding the timeout, theres no way I’m aware of.  If i’ve needed to get data from one area to another (for example copying fields being between inter-site orders), I’ve written an API to fill in the data and scheduled this to run at regular intervals. If the SQL procedure is taking several minutes though, it might be a better idea to see if you can improve it’s performance. 

8
R
Hero (Customer)
1 year ago
J
Sidekick (Customer)
jdohertySidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Combo box not populating in Supplier screen

I don’t beleive that field should be visible.  Party Type would be filled in by the IFS business logic at the point of saving the supplier.IFS help indicates creating a supplier like so…ProcedureOpen the Supplier window. Create a new record. Enter the supplier ID (maximum of 20 alphanumeric characters) and the name or description of the supplier. You have the option to enter the association number for the supplier. In the Default Language list in the General tab, click and select a default language for the supplier. In the Country list in the General tab, click and select the supplier's country of origin. Specify the category of the customer in the Supplier Category field. The Creation Date field automatically shows the date when the record was saved. If applicable enter a value in the Form of Business field or choose from the List of Values. Save your record.

8
J
Sidekick (Customer)
1 year ago
A
Do Gooder (Customer)
arumDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
custom field - Persistant and Reference type getting error

Can you supply a bit more information about the field definition, also which version of IFS are you running?

2
A
Do Gooder (Customer)
1 year ago
R
Hero (Customer)
romsarHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Trouble to fill the data on a custom page

If execution time is an issue, I would run this as a scheduled task in IFS.

8
R
Hero (Customer)
1 year ago
J
Sidekick (Customer)
jdohertySidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Combo box not populating in Supplier screen

Have you tried refrshing all the caches?

8
J
Sidekick (Customer)
1 year ago
T
Do Gooder (Customer)
tcollins57Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Users getting "500" errors trying to access IFS Application

Are there any errors/red or amber items showing up on the middleware server admin console?

2
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
APPS 10 - password functions

Ok - I’ve figured it out.  You have to grant execute privilage to public for the function - in my case for example…GRANT EXECUTE on CML_OFFICE_SENSITIVE_DATA TO PUBLIC;

4
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
APPS 10 - password functions

So, I’ve now recreated my function by copying the ora12c_strong_verify_function.  I can see it in the SQL developer window…But when I try and select any of the new functions, I can’t save the oracle profile as IFS reports that the function does not exist, but it WILL work for the ORA12C functions.  I’ve tried refreshing the cache, but it’s still not found after a successful refresh.  I’ve tried copying the function name and pasting that into the oracle profile window to eliminate spelling issues too. Any thoughts anyone?

4
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
List invalid object

Thank you both - both answers are equally valid :)

3
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Exactly!

10
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Hi @JohannesKnust .  Essentially we had 4 releases issued to us by IFS, but they supplied us with releases 1,2 & 4 (missing release 3).  Installing the 4th release before the third caused the problem.

10
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Middleware SSL works on hostname, not on FQDN

Thanks Ben,That worked - sort of.  It only responds now on the FQDN (server1.example.com), I now get “forbidden” on the hostname (server1).  Is that the expected behaviour?

3
B
Hero (Employee)
1 year ago
Kalhari Dissanayake
Hero (Customer)
Kalhari DissanayakeHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
How to get the list of users connected to Base Profile

Looks like the profiles are defined in the table fndrr_client_profile_tab, and the profile/user assignments in fndrr_user_client_profile_tab, so you should be able to use these tables to write a query to give you the information you need.

4
S
Sidekick
1 year ago
U
Sidekick (Partner)
USER_IFSSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
connecting a quick report using the _REP object for the end user

Does the user have access to SHPORD_INFO_SERVICES_RPV?

10
U
Sidekick (Partner)
1 year ago
J
Do Gooder (Customer)
junpeiDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
domain_sys.get_tranlsated_values return different result from primary and standby database

Could it be a caching problem on your secondary?

2
Amila Samarasinghe
Superhero (Partner)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Turns out the problem was a missing release which IFS didn’t tell us about.  Installed both releases and the problem is now fixed.

10
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Just an update - found out that the release that IFS gave us was not current and was missing items we were licensed for - hence the problem.I’ll post what the eventual fix is when i have it.

10
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Hi Charith,According to admin console, MainServer1 - Plsql-Access is running.I used SQL Developer to log in as the users mentioned, and I could (at least from my desktop machine).Tried a restart of middleware, and made sure all above was still correct - it was, and error still persists.

10
H
Hero (Customer)
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Apps 10 - unable to login after applying delivery

Hi Charith,yes, the application does download error 500 in the application client window.  if I examine the details I see this…Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, “FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway) at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway) at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke() at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery() at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader(String recordType, Int32 fetchsize) at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader(

10
H
Hero (Customer)
1 year ago
J
Do Gooder (Customer)
JacJLDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
IAL returning error when calling API function

In my experience IAL’s run under userspace IFSINFO, so if you we’re calling an API you’ve written under IFSAPP, you might be better calling the API function explicity i.e. ifsapp.your_api.function. 

3
J
Do Gooder (Customer)
1 year ago
B
Do Gooder
bsheridan.extDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Case Statement in Lobby Data Source Designer is not working

I’ll hazard a quick guess - the case statements would work as straight SQL because the column name is worked out on the fly, but the lobby designer may actually need a output field name to work.  Try changing the case statement so that you specify a column name for the output data e.g. ( SELECT CASE WHEN inventory_transaction_hist.transaction_code = 'OESHIP' AND part_catalog_cfv.part_main_group = 'DOMESTIC FG' THEN inventory_transaction_hist.quantity * part_catalog_cfv.cf$_proof_gallons WHEN inventory_transaction_hist.transaction_code = 'OESHIP' AND part_catalog_cfv.part_main_group = 'EXPORT FG' THEN inventory_transaction_hist.quantity * part_catalog_cfv.cf$_proof_gallons WHEN inventory_transaction_hist.transaction_code = 'SHIPTRAN' AND part_catalog_cfv.part_main_group = 'DOMESTIC FG' THEN inventory_transaction_hist.quantity * part_catalog_cfv.cf$_proof_gallons WHEN inventory_transaction_hist.transaction_code = 'SHIPT

4
B
Do Gooder
1 year ago
B
Do Gooder
bsheridan.extDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Case Statement in Lobby Data Source Designer is not working

Hi,Does it run as the same user in quick report mode as it does in the lobby?What error does it actually fail with?

4
B
Do Gooder
1 year ago
H
Hero (Customer)
HypervoxHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Middleware deployments will not start

Thanks guys,I tried both options (learned a lot in the process too ;) ) and the reconfigure failed on the first step - because it couldn’t contact the database.  Turns out someone has shut the container database down and not told me - as soon as I started the container database (and pluggable) again, the deployments started working again.So, I should have checked the database first (my bad) - in my defence it had no reason to be down and I had checked it earlier in the week, so I assumed it was fine.  That’ll teach me :)Once again, thanks for your help. 

4
SaaAvinak
Sidekick (Customer)
4 months ago

Badges

Show all badges
Terms & ConditionsCookie settings