Process Manufacturing - EBS (MOSC)

MOSC Banner

OPM GL Reconciliation in R12 for Specific Segment

edited Sep 9, 2017 3:54AM in Process Manufacturing - EBS (MOSC) 3 commentsAnswered

Hi,

I need your help. We are doing OPM GL Reconciliation. I need a query for reconciliation of specific segment (Receiving Inventory Control A/C) in detailed. I also want to validate it with GL.We presently use following query

------------------------------

SELECT gcc.segment5 account,

       gjh.name journal_name,

       gjh.je_category,

       gjh.je_source,

       gjl.effective_date,

       gjh.period_name,

       -- gjl.accounted_dr,

       -- gjl.accounted_cr,

       xal.accounted_dr,

       xal.accounted_cr,

       gjl.je_header_id,

       gjl.je_line_num,

       gcc.concatenated_segments,

       gjl.code_combination_id,

       'RECEIPT_NUM' doc_type,

       gir.reference_5,

       (SELECT cad.source_document_no

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