periods

ERP performance tuning on the third day

AM: Today, an early to the property management office, the two statements yesterday, a good test changes, basically in less than a minute to run out, compared to the previous run half an hour or even an hour can not get out, is really fast to "f ...

How does one close the period for a period status

How does one close the period for a period status of "Closed not summarized"? Solution The Period Close Reconciliation Report does not currently have any identified performance issues. In release 11.5.10 we have actually moved the entire pe ...

Find the remaining useful life of assets in fixed assets

select decode ( fab.conversion_date, NULL, fab.life_in_months - floor (months_between ( fdp.CALENDAR_PERIOD_CLOSE_DATE, fab.prorate_date)), fab.life_in_months - floor (months_between ( fdp.CALENDAR_PERIOD_CLOSE_DATE, fab.deprn_start_date))) - Into du ...

Check whether Periods of AP / AR / GL / FA / PO is closed?

SELECT (SELECT sob.NAME FROM gl.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Name", a.period_name "Period_Name", a.period_num "Period_Num", a.gl_status "GL_Status", b.po_status " ...

How to re-open the prior period for FA?

Assumptions: 1> now open for the FA during the AUG-09, and AUG-09 is not allowed affairs; 2> assumption book_type_code = 'xxxx book', AUG-09 during the corresponding number period_counter = 20000; Requirements: JUL-09 re-open period (du ...

How to Correct the Error Codes in Journal Import?

Period Error Codes ------------------ EP01 This date is not in any open or future enterable period. EP02 This set of books does not have any open or future enterable periods. EP03 This date is not within any period in an open encumbrance year. EP04 This d

Application of reaction out of account at slower analysis.

One morning, the application response time at night out of account for nearly twice as slow. Time, probably in about 1,2 points and 5,6 points. Because at that time did not do track, has been unable to determine what the specific issues, can only log ...

SQL * Report 1.1 Error Messages And Codes

SQL * Report Messages: RPT-0000 to RPT-0078: RPT Error Messages And Codes SQL * Report Messages: RPT-0000 to RPT-0078: RPT Error Messages And Codes RPT-0000 too few arguments One of the RPT commands does not have enough arguments, or contains a carri ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments