Database Expert

Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss

Greetings I am experienced DBA with 13 years of experience with single and cluster environments. I would be keen to work on this project looking forward for your reply

Hi, I went they the log and I know where the issue is. I can fix it. Over 9 years of experience as a database developer. Done similar jobs in the past. Can be done on Remote Desktop.

Hi, I've read the description of your posted job with the title "Database Expert”. I’m doing this job for the last 7 years. Which carries out different complexity level SQL/MySQL/PostgreSQL/MS Access task few of them are mentioned below, 1. Database Creation from Scenario 2. Create ERD from the documentation. 3. Extraction of Data from database through quires. 4. Writing Store procedure and views. 5. Indexing, look after query performance. 6. DB backup and restoration. 7. Data analysis and attractive visualization dashboards with (Tableau and Power BI) 8. Custom Visualization (I can show my works screenshot in chat). 9. Customize dashboards using different apps as a data source(Acumatica/Healthcare apps) I can give you my best rates for this role because I know I can do it in a better way. Thanks, Sufyan Jamil

In regards of the firsdt error message APP-FND-01388: Cannot read value for profile option FA_LARGE_ROLLBACK_SEGMENT in routine &ROUTINE. This is not an error, merely a warning that the profile option, FA_LARGE_ROLLBACK_SEGMENT has not been set.  Make sure that there is a message at the bottom of the logfile that says that the program completed successfully. In regards of errors reading table FA_CALENDAR_PERIODS, well it depends on the routine being executed and the EBS version, for example, I can see you have errors reported on routine "faxcfyf", on release 12, you can fix this issue by doing: 1. Extend the fiscal year beyond next fiscal year for the book. For example, if current fiscal year is 2017 then extend beyond 2019.

Navigate to: Setup > Asset System > Fiscal Year


 2. Extend both Prorate and Depreciation calendar for book .

 Navigate to: Setup > Asset System > Calendars


3. Rerun the depreciation for the period. In regards, for example, your error "fazgtff failed due to ORA-01403: no data found", Explanation is: Incomplete calendar setup, not all the periods for the current year are defined. Solution would be: A) For Depreciation (FADEPR): Create the periods for the rest of the current year in the Calendars form: (N) Fixed Asset Responsibility: Setup > Asset System > Calendars I'm not en expert on Oracle APPS nor EBS...I'm an oracle DBA. I could find several errors like you reported in your PDF files, and found several possible solutions. There are many!!!!

Please contact me

Having 8 years of experience in Oracle PLSQL development. Have lot of experience in writing queries, procedures...

Hello , I have read your issue and verified log file. Based on oracle note cause of the issue Calendar/Convention has not been extended beyond next fiscal year. we can fix the issue if you i get more details on this work.

Hi , I can help you with this issue. I am OCA certified and working as Database Admin. Also worked on several issue like this.

Hello! I’m a post-graduated database administrator with 11+ years of experience. I would need the credentials to connect on your db to find the problem. I’d be glad to help. I did read the log files and I have a suspect of what is causing the error.

Dear Sender, I have profound experience in SQL & PLSQL, Oracle Forms and Reports 10g. I have also experience on Oracle EBS 11i and R12 on various modules. I have 2 years of training/tutoring experience for Oracle SQL and PLSQL along with ER diagrams. I have also Python scripts experience to create game and resolving it's scripts issues. I would be really happy to complete your tasks on given timeline. Thanks.