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 |
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
where we will put the control file ,where we will run sql star loader what is the cmd?
In what situation u create the BPA.
what is meant by Drill Down in Discoverer report? why it will be use?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
in procedure how to return a value
any one can expalin report registration steps?
How to find which company will be conducted Oracle appa interview? Plz help me
what is fiscalcalendar?
What is the reason for distribution hold. Why invoices will go on distribution variance hold ??