| need help about gl_interface [message #271100] |
Sat, 29 September 2007 07:22  |
detectiveds
Messages: 6
Registered: August 2007
Location: china
|
Junior Member |
|
|
hi:
i write a concurrent program to copy data from gl_je_batches,gl_je_headers and gl_je_lines, after it ,i insert data into the gl_interface table and invoke system standard journal import program to import data.But i have a problem , i copy the data from attribute1 to attribute10 columns in gl_je_headers,and i want data also in gl_je_headers's attribute1 to attribute10 columns after journal import program, so which gl_interface columns should i insert them into ,or is it any other method to realize it.
THX!
Best Regards!
Spark
|
|
|
|
|
|
| Re: need help about gl_interface [message #351332 is a reply to message #271100] |
Tue, 30 September 2008 06:04  |
detectiveds
Messages: 6
Registered: August 2007
Location: china
|
Junior Member |
|
|
Hi:
I am sorry i had not find any solution of this issue, and i only could write data in gl_je_lines attribute1 to attribute10 through used gl_interface, and have you find any other method to resolve it? thanks.
Regards
Spark
|
|
|
|
| Re: need help about gl_interface [message #351338 is a reply to message #351332] |
Tue, 30 September 2008 06:50 |
Puskado
Messages: 38
Registered: May 2007
|
Member |
|
|
Hi
Try to run this script
select count(status_description), status_description
from gl_interface
where budget_version_id is null
and status <> 'P'
group by status_description
--incorrect accounts
select count(status_description), status_description
from gl_interface
where budget_version_id is null
and status <> 'P'
and status_description like '%Operating Unit Name%'
group by status_description
|
|
|
|
| Re: need help about gl_interface [message #351488 is a reply to message #351338] |
Wed, 01 October 2008 02:03 |
kjoy
Messages: 11
Registered: September 2008
|
Junior Member |
|
|
Check what are the values are showing in the GL JE header TABLE , These values should be descriptive flexfield information .
GL_JE_HEADER Table Attribute1 to 10 columns stores Descriptive Flexfield segment information and you need to load the Journal Entry Line descriptive flex field information on the GL INTERFACE attribute 1 to 10 columns and the load the context value of the Journal Entry Line flexfield in GL INTERFACE'Context column.
Let me know , This works
Thanks
Joy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
