What is the link between AP and GL in oracle apps R/12?
Answers were Sorted based on User's Feedback
Answer / jagadekar
Link between AP and GL in R/12
------------------------------
AP_INVOICES_ALL --> Invoice_id = APPLIED_TO_SOURCE_ID_NUM_1
<-- XLA_DISTRIBUTION_LINKS
Also
AP_INVOICE_DISTRIBUTIONS_ALL -->INVOICE_DISTRIBUTION_ID =
SOURCE_DISTRIBUTION_ID_NUM_1 <-- XLA_DISTRIBUTION_LINKS
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / prachi
The above link is good for xla and ap from xla further we need to use the gl_sl_link to get the final gl line
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / omprakash
gl_sl_link_id in xla_ae_lines = gl_sl_link_id in gl_je_lines
Is This Answer Correct ? | 1 Yes | 1 No |
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.
Are you familiar with internet architecture of oracle apps 11i?
what is repeting frame?
explain o2c cycle? what are the table reflected for this process?
how to make a parameter optional in the query?
in procedure how to return a value
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
what are the functions you are used in utl_file at the time of transferring the data?
What are ad-hoc reports?
what is global tempory table?
What is Summary columns?