My Oracle Support Banner

WebAdi: How To Default Accounting Period Based On the Accounting Date Entered In The Spreadsheet? (Doc ID 974303.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Oracle General Ledger - Version 12.0 to 12.0.6 [Release 12.0]
Oracle Web Applications Desktop Integrator - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.


  How to default accounting period based on accounting date in WEB ADI template?
GL> Journals> Launch Journal wizard > webadi spreadsheet is created and accounting date is entered. The intention is to modify the layout to use an sql so that the accounting period would be populated automatically based on the accounting date entered.
The sql would get period name from gl_periods table based on the selected accounting date as explained above.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.