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