IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN
WHY?
Answers were Sorted based on User's Feedback
Answer / sunil
only sub_ledger modules like ap,ar,po,om are at operating
unit level.Every table in this modules have the tables
org_id column and ends with _all.Based up on the
organization data will be filterd by using org_id column
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / ravi saini
GL does not have _all tables only sublegders AP,PO,AR have
the _all tables. subledgers secure data operating unit wise
with org_id column that exits in _all table. GL secure and
spreate data with set_of_book_id that exist in
gl_sets_of_books table.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / anji
gl does not have _all tables because this module contain
accounting information
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / santosh kumar
I hope GL and HRMS modules wont have _all tables
Because GL and HRMS modules are single for particular company. Company may have multiple Org Units or Operating units according to which they have multiple local transactional account modules like AP,AR,PO,INV at their locations. But employee related tables and GL is single.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many schemas we have? how many you have used?
How can a process be deployed in soa?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
what are the error tables in OM
what is meant by Table space?
What is ment by Global Templates in Oracle.
what are the receipt types in Po?
Cycle of requestion to receving transaction.
Tell me how to debug the report?
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
oracle apps architecture
In hierarchical structure of a database? we have write query from where we should start?