OraPedia

Home » Posts tagged 'Reference'

Tag Archives: Reference

Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM

Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM

This article from  Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM

The article direct link  Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM

Summary

eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in html format. It shows database design and dependency information for the Oracle eBusiness Suite. Enter the name of a database object (example: per_people_f) or a search condition (example: contract compliance) then press ‘Search’ to search for information. Alternatively you can browse the FND Model or Oracle Data Dictionary from the FND or DBA tabs.

Oracle PL/SQL Language Pocket Reference, Fourth Edition

Oracle PL/SQL Language Pocket Reference, Fourth Edition

This article from  IT eBooks

The article direct link  Oracle PL/SQL Language Pocket Reference, Fourth Edition

Summary

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle’s PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information into an accessible summary.
You can download the Oracle PL/SQL Language Pocket Reference, Fourth Edition book directly from the following link:

Oracle PL/SQL Language Pocket Reference, Fourth Edition.pdf

GL_INTERFACE Reference Columns in 11i EBS

GL_INTERFACE Reference Columns in 11i EBS

This article from  Welcome to Oracle ERP

The article direct link  GL_INTERFACE Reference Columns in 11i EBS

Summary

Reference columns are populated/updated in GL_INTERFACE, GL_JE_LINES and GL_IMPORT_REFERENCES tables only in 11i EBS and not in R12. In R12, there are different set of SLA tables which we need to refer to retrieve subledger data after transfer to GL.
This article explain the detailed analysis of Reference columns in GL_INTERFACE