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 to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
Which is the best website to learn Oracle Apps?
q)what are the validations in sql*loader
in one report using two layout models.if yes how to do
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
what are the steps to develop a new report?
How will U link GL with OU in Multi-org environment.
What is function?
what is instead of trigger. what is the use of that?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
What are the Import Programs We need to run after creating Interface table for all modules
Hoe to skip middle of the record by using SQL*Loader?