I need to create a Sales Intake report and have a query on which views to use to get the information. I know the GL/Nominal Accounts to use but do not know the best view to use to collate the information. Can someone please advise? Thank you.
When viewing payslip using Order Report and selecting Paylip Uk the payslip displays data however when viewing the payslip in Employee Self Service it uses Payslip Uk and the report opens up without displaying any data.Can you please advise as soon as possible
When in Master Part, the user clicks Attachments and a document is displayed in the list. When the user clicks View and clicks OK the user receives the following message: You must have View access in order to read this file. How do I resolve this issue. Thank you. John
We have a quick report the runs via RMB on the Shop Order. This creates a label for the item. The user has asked whether it is possible for the report to print a number of copies equal to the Qty Complete and at the bottom of the report print 1/5 2/5 3/5 4/5 5/5 on the respective page/copy. Is this possible? And pointers much appreciated. Thanks John
In Database Sessions we have a long running session related to Business Reporter scheduled report that we wish to kill.The session id in Database Sessions is 642: However, on RMB > Kill Session we receive the following error: I cannot see the session in Monitor Sessions in SQL Developer but can see the session when doing select from v$session : select * from v$session where sid = '642' ;Using the SID and SERIAL# I tried to kill the session:ALTER SYSTEM KILL SESSION '642,12109'I receive the following error:Error report -ORA-00026: missing or invalid session ID00026. 00000 - "missing or invalid session ID"*Cause: Missing or invalid session ID string for the current operation.*Action: Retry with a valid session ID.Obviously, can see the session in FND_SESSION_RUNTIME How can I kill this session when it isn’t reported in Monitor Sessions and any attempt to kill the session report in the missing or invalid session id?
I need to create a scheduled task in advance that will execute every 14 days at a certain time of the daye.g. creating a scheduled task on today 16/02/2023 that will execute every 14 days starting on 01/03/2023 so that the first execution will be 01/03/2023 and then the next execution should be 14 days after on the 15/03/2023Selected custom and entering SYSDATE+14 in the ExpressionEntered the Start Date as 01/03/2023 but on clicking calculate or saving the record the Next Execution is calculated as 02/03/2023 and the time is the same time as when the record is saved/last amended. Is there a better way to achieve what I require?It would be also be good if I could set the time as well.Thank you.
I have SQL that using multiple views, I therefore created an IAL using the SQL and deployed it. The IAL appears in the IAL Configuration, however, I am unable to access the IAL within the Data Source Designer OR using Quick Reporter. Can anyone advise what I am missing?
We have 2 MWS on the same server, (IT2 and IT3) and 2 print agents installed 1 for IT2 and 1 for IT3. The print agent was installed for IT2 and this works without any issues. However, when we start the print agent for IT3 the IT2 print agent ceases to work and stops. On stopping the IT3 print agent and starting the IT2 print agent again it works without any problems. The print agents have been installed on the same application server where IT2 and IT3 MWS reside. Any tips/advice? Thank you.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.