General Ledger - EBS (MOSC)

MOSC Banner

Run MassAllocations Schedule

edited Feb 17, 2011 2:28AM in General Ledger - EBS (MOSC) 2 commentsAnswered
Hi I'm trying to run a mass allocations program every saturday which use an SQL query to fetch the currently open GL period. I've set the mass allocations job up to run from a request set and below are the parameters I am using:

command_mode: Type Constant: C

set_of_books_id: Type Constant: 2

incremental_flag: Type Constant: N

average_je_flag: Type Constant: N

allocation_batch_id: Type Constant: 1622

PERIOD_NAME: Type SQL Statement: SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES WHERE application_id = 101 and set_of_books_id = 2 and sysdate between start_date and end_date and closing_status = 'O'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center