General Ledger - EBS (MOSC)

MOSC Banner

API to perform GL line reconciliation

edited Mar 2, 2020 1:23AM in General Ledger - EBS (MOSC) 6 commentsAnswered

Hello everyone,

I am working for a corporation which has millions of unreconciled GL lines in gl_je_lines table, because they were never using automatic nor manual reconciliation features in R11(I studied Doc ID 406329.1) and they don't even started to use new R12 features(I studied Doc ID 1673357.1) to do it once they transitioned to R12. I have studied both references and I understand that the goal is to ultimately populate gl_je_lines_recon table to be able to exclude lines from gl_je_lines which have jgzz_recon_status set to 'R'.

My question if there is a supported API to set the jgzz_recon_status programatically for each (je_header_id, je_line_num, code_combination_id) tuple identified as part of common group with same jgzz_recon_ref so that these lines can be transferred to gl_je_lines_recon table and thus creation of report which would contain only open(unpaid) GL items could be created.

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

EBS GL Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center