Records stuck in GL Interface with status P

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
arun1203
Posts: 79
Joined: Mon Jun 11, 2007 10:36 am
Location: Kuwait
Contact:

Records stuck in GL Interface with status P

Post by arun1203 »

Dear Members,

We have transferred some JV's from subsystem to GL Interface for the period AUG-08.
Then we ran the import program.

After running the import program we cannot see the JV's in Oracle GL for AUG-08.

We queried the JV's og AUG-08 in GL_Interface table and found the status of the lines as 'P'.

How to overcome this issue?
What step we have take now?

Your inputs will be of great help thanks.
arvindmaurya
Posts: 18
Joined: Mon Jan 08, 2007 9:13 am
Location: India

Post by arvindmaurya »

Do all the line have the status as 'P'.?
dongta
Posts: 2
Joined: Sat May 26, 2007 1:06 am
Location: Vietnam

Post by dongta »

Oracle GL interface use group_id to indentify group of lines in interface table.
If group_id is null then if one line error then all others lines will have status='P' and all remain in interface table.
If group_id not null then the same logic happen but for all lines that have the same group_id.

Hope this help./.
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 3 guests