Replies posted by OrangeCloud

102 Replies

O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Ignore Package Components via Sql query

thanks , this wouldn’t work for my purpose. no issues. I am good for now.

3
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Shop Order -

@ShawnBerk @dameenda  yes, its right after upgrade to IFS10 UPD9

6
D
Hero (Employee)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Shop Order -

@ShawnBerk  thanks for replyingI cannot see any picklist created. checked in History tab and Shop Order PickList screen.yes, we have only one material in this shop order If i go and check in ‘Inventory Part Availability Planning’ this part is not reserved on this Shop Order.

6
D
Hero (Employee)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Question on Scheduling Quick Reports

@Charith Epitawatta thanks for replyingI am getting a different error now in the attached Excel report in my email. I made sure both my report parameters are numbers (year and month) and Context_Substitution_Var_API.Get_Server_Value__('NUMBER_OF_THIS_YEAR') also returns ‘number’ for #NUMBER_OF_THIS_YEAR# and #NUMBER_OF_LAST_MONTH#when i run quick report from IFS with same parameters it run successfully, but when i pass same parameters from Application server task , i get above error in attached excel. any hints how to resolve this.2- I tried extract, to_char and to_number(to_char) method in parameter, no success. in these methods no email generates and my AST failed.I can modify the report and use dates within QR but i would like to understand this feature to apply in future without modifying reports.thanks

6
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Question on Scheduling Quick Reports

@Charith Epitawatta now the question is how to use Context variables in Scheduling Quick Reports.I scheduled my report with #NUMBER_OF_LAST_MONTH# and i get following error message in Application messages, Background Job runs successfully but email does not go out and Application Server Task goes into Status ‘Failed’Insufficient privileges to export the quick report to Excel. Caused by: ifs.fnd.base.SystemException: Insufficient privileges to export the quick report to Excel.I made sure context_Substitution_Var_API is granted to ifssys, but i still can’t use this api as ifssys. looks like i am missing some further permissions , will you be able to help in this regardFYI: I used EXTRACT(MONTH FROM sysdate) and EXTRACT(YEAR FROM sysdate) in Application Server Task Parameters and that’s working without errors.Thanks

6
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Payment Method per Institute- issue

this issue is resolved when granted full permissions on folder (delete, move) to the user

3
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Payment Method per Institute- issue

@Link this process is actually copying files in ‘hist’ folder and not moving as it was moving in IFS8 with same settings. I have not about any other errors in the process so far. so all good .

3
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Finance (Financials)

Create Mixed Payment - Error

@Thomas Peterson Amazing, this workaround worked wonders.will you please share your thoughts on following please.1- If we don't go for patch for now and wait until we get UPD12, looks like this workaround will do . your thoughts on it please 2- I have set definition identifiers for one Series ID only but looks like its working for others as well. (set for CD and can successfully upload CR in the load as well)

8
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Finance (Financials)

Create Mixed Payment - Error

@AkilaR that's something good to know, i have doubts if i am experiencing this as the same file is loaded successfully in very similar (old data) environment. I am pretty sure something is different while loading data into ‘Externa Payment’ screen, that screen look different , screenshot in above post.

8
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Finance (Financials)

Create Mixed Payment - Error

@Shanuka Lashan  yes, i verified, both environments (successful vs non successful) don't have any values in ‘Installment ID’ field. I see the bad env has some extra info in the load.( Green is good and purple is bad) transactions looks same in both  

8
O
Sidekick (Customer)
2 years ago
I
Sidekick (Customer)
ikerarriSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Phase In - inventory parts

@ikerarri thanks for the info on where to change, thanks

7
AanHGTS
Hero (Partner)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Service (Touch Apps, MWO, MRO)

Disable field in RMB function subform- frmCustomer

@Kelum Niranjana thank you,I can make fields ‘Mandatory’ and ‘Read Only’ from the main ‘Customer’ Page but the options on the RMB subform are not available in Properties to modify.

3
Kelum Pradeep Kumara
Superhero (Employee)
2 years ago
I
Sidekick (Customer)
ikerarriSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Phase In - inventory parts

@ikerarri @william.klotz  @ShawnBerk We don't use Product Structure here often, encounter this error for the first time, when trying to duplicate structure from one site to another.Product Structure Header was created a month agao and now when the user is trying to add components, we are getting following error.I see @ikerarri  mention that we need to change phase in date in inventory, will it be product structure (header) that need to be updated or its components? any sql/script or screenshot will be helpful. Bundle of thanks.we are using IFS8. 

7
AanHGTS
Hero (Partner)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Question on Scheduling Quick Reports

Thanks @Charith Epitawatta  for confirming about Subject Line. I will use “Context Substitution Variables” .as per F1 documentation END_OF_LAST_MONTH will bring date and time of last month. can we truncate this to use only date in report parameter? 

6
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lobby Date Parameter

@sutekh137 thanks for pointing that sysdate will never be null, i soon realized after posting that. I tried date mask in my condition and i can get results  when user input a date but not with #Today# , the default value. so far i am getting either or. sysdate (default)or user entered date.

3
S
Hero
2 years ago
T
Do Gooder (Customer)
toyinjuliusDo Gooder (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)

Demand Planner and IPR Lobbies

looking forward for ideas in this post. we can utilize some of them in near future 

1
O
Sidekick (Customer)
2 years ago
proharikg
Sidekick (Partner)
proharikgSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Lobby time out error

Hi @proharikg, To increase the refresh interval of a lobby page, you can do following: Go to Lobby Overview page in IEE.  Click on the padlock icon on top right. This will enable a cogwheel icon.  Click on the cogwheel icon. This will open a dialog box.  In the dialog box you can set the refresh interval as below from the Data section.    Although this probably might not help your case as your data source might need some optimization if it is taking over a minute to fetch data. 1 minute is too long for a lobby element as far as I know.  The OP is asking about a query taking longer than 1 minute, not about auto refresh interval.   If you think about the question “is there any possibility to increase the refresh timing of IFS lobby page?” the more suitable answer would be what’s noted above.  However, the setting in the  Ifs.Fnd.Explorer.appsettings can be used to resolve the problem with the query timing out after 1 minute (Default setting fo

12
P
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS10 Lobby Basic Permissions

@william.klotz  so, i figured there will be no ‘Go To Page’ button for user , they will need to double click to access the lobby in full screen and drill down  .

4
Kasun Balasooriya
Superhero (Employee)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS10 Lobby Basic Permissions

@william.klotz thanks for your quick reply. I verified and the lobby in question is already granted to that permission set assigned to user, still user cannot open the lobby page, but able to see it granted. 

4
Kasun Balasooriya
Superhero (Employee)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Fixed Asset-Import Object with 2 depreciation values

No Problem.I fixed this error. My loops need to be updated to bypass this error.

1
O
Sidekick (Customer)
2 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Page Layout Question

I find following settings are better than changing tab associations, as i was trying to do previously.with ‘Physical Location Mandatory’ checked under Company» Fixed Assets tab. on Saving in ‘General’ tab, control is directed to ‘Inventory’ tab with message to enter mandatory information.  

2
O
Sidekick (Customer)
2 years ago
B
Sidekick (Customer)
BLLBrucemoSidekick (Customer)
asked in Finance (Financials)

Help with script needed to automate reprinting of customer invoices

@BLLBrucemo not sure if this will help in your case, but i had a small batch couldn’t sent to customers due to server down issue. and we used following api and was able to resend invoices to customers. print_job_api.print(rec.print_job_id); we actually had print_job_id’s to resend so just sent a range of about 200 invoices and they are all good for us.

3
O
Sidekick (Customer)
2 years ago
B
Sidekick (Customer)
BLLBrucemoSidekick (Customer)
asked in Finance (Financials)

Help with script needed to automate reprinting of customer invoices

@BLLBrucemo were you able to resolve this. I am in the same boat now.you have anything to share how to resend invoice pdf’s in bulk once created. thanks

3
O
Sidekick (Customer)
2 years ago
V
Sidekick
VchandnaSidekick
asked in Distribution (CRM, Commerce)

External File assistant

That will be helpful for us as well, if someone has any ideas on this 

2
P
Hero (Employee)
2 years ago
dsj
Superhero (Partner)
dsjSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Excel Migration- How to commit after each row insert?

Hi @eqbstal I am trying to achieve the same workflow as you successfully completed via migration job. i.e;‘Close’ existing line in ‘Price List’ tab of ‘Supplier for Purchase Part’ screen and insert new ‘Active’ Line.In our company, we don't own Excel migration tool, Is there still a possibility i can use Migration Job, i can create temporary table from Excel to provide source data, if that could work.following are my options that i can see will you be able to show me the other tabs and header of the above migration jobs you setup above. I would like to give it a try. will appreciate your help.Thanks

2
O
Sidekick (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings