What are User Exits and what are different types of User Exits in
Oracle Apps
User Exit is nothing but a colection of changable optin that
it can be change in the way of our applicalion
In Apps 4 types of User Exits.
Saite Level
Application Level
Resposibility Level
User Level
User Level: It is
Higer level , it is applicable to the all users.
Application Level: It is applicable to that particular
application only
Resposibility Level:
For that Particular resposibility
Site Level:Is lower
level , if we difiened if it is Site level , it will appilicable to the all
users..
Types of User Exists are
1. FND SRWINIT
2. FND SRWEXIT
3. FND FORMAT_CURRENCY
4. FND FLEXIDVAL
What columns indicate the Transfer Status of accounting data in
subledger?
The XLA_AE_HEADERS table shows the transfer status of the
accounting data, after successful transfer to the GL and Journal Import:
XLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is not null
XLA_AE_HEADERS.group_id is not nullFor 11i data upgraded to R12, the transfer status can be determined using the followingXLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is null
XLA_AE_HEADERS.group_id is null
XLA_AE_HEADERS.upg_batch_id is not null –> indicates 11i data
XLA_AE_HEADERS.gl_transfer_date is not null
XLA_AE_HEADERS.group_id is not nullFor 11i data upgraded to R12, the transfer status can be determined using the followingXLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is null
XLA_AE_HEADERS.group_id is null
XLA_AE_HEADERS.upg_batch_id is not null –> indicates 11i data
Which is the most commonly used package in apps that uses
Autonomous Transaction?
FND_LOG, this is used for
debugging. This has a procedure named string, which does a commit.Hence your
debug messages are not lost in the event of rollback during unhandled
exception.
What is one of the limitations of Forms Personalization?
You can not display interactive
messages as you can using fnd_message
How to use Flexfields in
reports ?
Most common way is to use FND
user exits provided by oracle applications.
Other way is to directly use the
DB views (TableName || ‘_KFV’ or ’_DFV’)
created by apps, and use the concatenated_segments column which holds the
concatenated segments of the key or descriptive flexfields.
What are Autonomous transactions ? Give a scenario where you have
used Autonomous transaction in your reports ?
An autonomous transaction is an
independent transaction started by another transaction, the main transaction.
Autonomous transactions let you suspend the main transaction, do SQL operations,
commit or roll back those operations, then resume the main transaction.
Once started, an autonomous
transaction is fully independent. It shares no locks, resources, or
commit-dependencies with the main transaction. So, you can log events, increment
retry counters, and so on, even if the main transaction rolls back.
More important, autonomous
transactions help you build modular, reusable software components. For example,
stored procedures can start and finish autonomous transactions on their own. A
calling application need not know about a procedure's autonomous operations,
and the procedure need not know about the application's transaction context.
That makes autonomous transactions less error-prone than regular transactions
and easier to use.
Furthermore, autonomous
transactions have all the functionality of regular transactions. They allow
parallel queries, distributed processing, and all the transaction control
statements including SET TRANSACTION.
What is record group ?
Record group are used with LOVs
to hold sql query for your list of values. The record group can contain static
data as well it can access data from database tables thru sql queries.
What is a FlexField ? What are Descriptive and Key Flexfields ?
An Oracle Applications field made
up of segments. Each segment has an assigned name and a set of valid values.
Oracle Applications uses flexfields to capture information about your
organization.
What are different report triggers and what is their firing
sequence ?
There are five report trigger :
· Before Report
· After Report
· Before Parameter Form
· After Parameter Form
· Between Pages
The Firing sequence for report
triggers is
Before Parameter Form – After Parameter
Form – Before Report – Between Pages – After Report.
What is the use of cursors
in PL/SQL ? What is REF Cursor ?
The cursor are used to handle
multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s
queries. Oracle uses unnamed memory spaces to store data used in implicit
cursors, with REF cursors you can define a cursor variable which will point to
that memory space and can be used like pointers in our 3GLs.
How to attach reports in Oracle Applications ?
The steps are as follows :
· Design your report in D2K
· Generate the executable file of the
report as .rdf.
· Move the executable as well as source
file to the appropriate product’s folder.
· Register the report as concurrent
executable.
· Define the concurrent program for the
executable registered.
· Add the concurrent program to the
request group of the responsibility.
What is the use of triggers in Forms ?
Triggers are used in forms for
event handling. You can write PL/SQL code in triggers to respond to a
particular event occurred in your forms like when user presses a button or when
he commits the form.
The different type of triggers
available in forms are :
· Key-triggers
· Navigational-triggers
· Transaction-triggers
· Message-triggers
· Error-triggers
· Query based-triggers
What is the use of Temp tables in Interface programs ?
Temporary tables are used in
Interface programs to hold the intermediate data. The data is loaded into
temporary tables first and then, after validating through the PL/SQL programs,
the data is loaded into the interface tables.
What are the steps to register concurrent programs in Apps ?
The steps to register concurrent
programs in apps are as follows :
· Register the program as concurrent
executable.
· Define the concurrent program for the
executable registered.
· Add the concurrent program to the
request group of the responsibility
How to pass parameters to a report ? do you have to register them
with AOL ?
You can define parameters in the
define concurrent program form. There is no need to register the parameters
with AOL. But you may have to register the value sets for those parameters.
Do you have to register feeder programs of interface to AOL ?
Ans : Yes ! you have to register
the feeder programs as concurrent programs to Apps.
What are forms customization steps ?
The steps are as follows :
· Copy the template.fmb and Appstand.fmb
from AU_TOP/forms/us.Put it in custom directory. The libraries (FNDSQF,
APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached
.
· CREATE OR OPEN NEW FORMS. THEN
CUSTOMIZE.· Save this Form in
Corresponding Modules.
What is Key and Descriptive Flexfield.
Key Flexfield: #unique
identifier, storing key information
# Used for entering and displaying key
information.
For example Oracle General
uses a key Flexfield called Accounting
Flexfield to uniquely
identifies a general account.
Descriptive Flexfield: # To
Capture additional information.
# to provide expansion space on your form with the help of Represents
descriptive
What is FlexField?
Oracle Application uses Flexfield
to capture information about
Your organization. Flexfield have
flexible structure for storing key information.
Like Company, Cost Center, and
Account. They also give u highly adaptable
Structure for storing customized
information in oracle Applications.
Difference between Key and Descriptive Flexfield?
KEY FLEXFIELD
1.Unique Identifier
2. Key Flexfield are stored in
segment
3.For key flexfield there are
flexfield Qualifier and segment Qualifier
DESCRIPTIVE FLEFIELD
1.To capture extra information
2.Stored in attributes
3. Context-sensitive flexfield is
a feature
of DFF. (descriptive flexfield)
Can you call APPCORE library in CUSTOM library ?
you cannot attach the APPCORE
library to CUSTOM because it would cause a recursion problem
(because CUSTOM is attached to
APPCORE). As of Oracle Applications Release 11i, you may
attach the APPCORE2 library to
CUSTOM. The APPCORE2 library duplicates most APPCORE
routines with the following
packages:
· APP_ITEM_PROPERTY2
· APP_DATE2
· APP_SPECIAL2
These packages contain the same
routines as the corresponding
APPCORE packages. Follow the
documentation for the corresponding
APPCORE routines, but add a 2 to the
package names.
What is MRC and what are
it’s use?
The Multi Reporting Currency
Feature allows you to report and maintain records at the transaction level in
more than one functional currency. You can do by defining one or more set of
books in addition to primary set of books.
What are ad-hoc reports ?
Ad-hoc Report is made to meet
one-time reporting needs. Concerned with or formed for a particular purpose.
For example, ad hoc tax codes or an ad hoc database query
What is FSG and what is it’s use ?
FSG is a powerful and flexible
tool you can use to build your own custom
reports without programming. FSG is only available with GL.
What are Interface table in AP, AR,GL ?
AP INTERFACE TABLE: 1).
AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4).
AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3).
HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
8). RA_INTERFACE_LINES_ALL
9).
RA_INTERFACE_SALESCREDITS_ALL
GLINTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_interface
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
|
||||||||
How can you restrict the accessto a group of users using
personalization in oracle apps?
Node or Responsibility Trust Level : is
profile option, to restrict access to set of responsibilities based on Web
Server from which user logs in.
This profile option can take one of
three values –Administrative
Normal (Default Value)
External
What is the difference between Conversions
and Interfaces ?
Conversion is to bring the data from other
(non-OraApps) system to Oracle-Application system. This is one time activity
(bring account details, transactions, orders, receipts and so on). So
conversion itself is a project.
Interfaces are Concurrent PRograms/Program sets
(pl/sql, pro*C, unix scripts, executables) . Interfaces are basically of two
types (Oracle supplied (vanila programs eg:Autoinvoice in AR) and created by
developer).
CONVERSION :-
·
IT IS A PROGRAM
·
IT IS ONE TIME DATA TRANSFER
·
WE WILL BE KNOWING THE VOLUME OF THE FLAT FILE
·
NO NEED KNOW ALL EXCEPTIONS
·
THIS IS USED IN UPGRADING,MIGRATION PROJECTS
INTERFACE:-
·
IT IS A PROGRAM TO TRANSFER THE DATA FROM ONE
LOCATION TO ANOTHER
·
LOCATION
·
IT IS SCHEDULED CONCURRENT PROCESS TO EXECUTED
MULTIPLE TIMES
·
WE WILL NOT BE KNOWING FLAT FILE VOLUME
·
WE NEED TO HANDLE ALL EXPECTED EXCEPTIONS
·
USED IN ENCHANCEMENT,CUSTOMIZATION PROJECTS
|
There are 5 files are user in SQL
Loader.
1. Data File.
2.Control File.
3.Log file.
4.Bad File.
5.Discard file.
data file and control file are
required file.
example
SQL> sqlldr userid=apps/apps
control=XYZ.ctl
This control file contain the
referance of data file.
log file and bad file autometically
created by sql Loader.
and Discard file is optional.
|
|||
|
What are the difference between
11i and R12 ?
So many changes are there in tables.
Mainly In multi org architecture
In 11i set of books, 3cs (Currency,Calender,Chart of
accounts)
now in R12 Set of books call it as a ledger
4cs(Currency,Calender,Chart of accounts,subledger accounting).
What are the collection types in oracle?
Collection types are objects that contain multiple sets of
values. There are two kinds of collection types:
varrays
object-type tables
What is a tablespace?
A database is divided
into Logical Storage Unit called tablespaces.
A tablespace is a
logical grouping of related data.
In Oracle, user data
is logically stored in tablespaces which is physically stored in data files.
Explain Multi-Organization Structure?
Set of book
A financial reporting
entity that uses a particular chart of accounts, functional currency and
accounting calendar.
Business Group This
is highest level in the Organization Structure. The Business group secures HR
Information. Multiple set of books can share same business
group. Legal Entity A
legal company for which you prepare fiscal or tax reports. Balancing Entity
Represents an
accounting entity for which you prepare financial statements.
This is the segment
in Accounting Flexfield.
Operating Unit
An Organization that
Uses Oracle Cash Management, Order Management and shipping Execution, Oracle
Payables, Oracle Purchasing, Oracle receivables.
It may be a Sales
office division or a department. An Operating Unit is associated with legal
entity.
Inventory
Organization An Organization for which you track Inventory transactions and
balances and/or an Organization that manufactures or distributes products. HR
Organization
HR Organization
represents the basic work structure of any enterprise. They usually represent
Functional Management or reporting groups that exists within a business group.
What is parameter in apps and from
where u can create it.
Parameters only using
in report, you can create in defining the report in
What all are the tables used in the modules u have worked on.
In GL – I have worked
on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES),
GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),
*In PO- I have worked
on PO_HEADER_ALL
What is Profile? Explain different
levels of Profile.
A user profile is a
set of changeable options that affects the way your
applications run.
Oracle Application Object Library establishes a value
for each option in a
user‟s profile when the user logs on
or changes
responsibility. Your
user can change the value of profile options at any
time
a)
To
create Profile Option. ( Profile Option can created by developer in application
developer area) b)set the value (Values of the profile option , who will have
what value at various levels is set by SYSADMIN). Oracle Application Object
Library provides many options that. (Edit profile feature for every user is
available to set any value to allow the user).your users can set to alter the
user interface of your applications to satisfy their individual preferences.
Profile Option – set at run time like – User Related, responsibility, Sequence,
Printer, Security.
What are the tables involved in the Transfer
to GL and GL posting?
Subledger Tables
XLA_AE_HEADERS
XLA_AE_LINES
XLA_DISTRIBUTION_LINKS
XLA_AE_HEADERS
XLA_AE_LINES
XLA_DISTRIBUTION_LINKS
Transfer Journal Entries to GL (XLAGLTRN) process takes the
subledger journals and inserts records into the Interface Tables
Interface Tables
GL_INTERFACE / XLA_GLT_<groupid>
GL_INTERFACE / XLA_GLT_<groupid>
Journal Import (GLLEZL) then reads from the interface table and
creates records in the GL Tables
GL Tables
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_IMPORT_REFERENCES
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_IMPORT_REFERENCES
GL Posting process then posts to the GL_BALANCES table.
What are the different methods to transfer Subledger journals to
GL?
a) ONLINE MODE
GL Transfer can be spawned during Online Accounting using the ”Final Post” option for a specific document (Example: AP Invoice and AR Transaction).
GL Transfer can be spawned during Online Accounting using the ”Final Post” option for a specific document (Example: AP Invoice and AR Transaction).
Example: Navigation in Payables: Invoices/Entry/Invoices:
Action: Create Accounting/Final Post. This spawns the GL Transfer, the
Journal Import, Data Manager and the GL Posting processes. This request
transfers ALL the final accounted data for that document. This method of
transfer uses the interface table GL_INTERFACE to move the journals to the
general ledger.
b) BATCH MODE
GL Transfer can also be spawned by the Create Accounting concurrent request when submitted with the “Transfer to GL” parameter set to Y.
GL Transfer can also be spawned by the Create Accounting concurrent request when submitted with the “Transfer to GL” parameter set to Y.
Example: Navigation in Payables: Other/Request/Run: Create
Accounting
This spawns the journal import and the data manager processes. The GL Posting process is spawned if the Post to GL parameter is set to Yes when submitting the Create Accounting. This request transfers all the final accounting created by the Create Accounting request that spawned it. This method uses the interface table XLA_GLT_<groupid>.
This spawns the journal import and the data manager processes. The GL Posting process is spawned if the Post to GL parameter is set to Yes when submitting the Create Accounting. This request transfers all the final accounting created by the Create Accounting request that spawned it. This method uses the interface table XLA_GLT_<groupid>.
c) CONCURRENT REQUEST
GL Transfer can be submitted in standalone mode using the concurrent request “Transfer Journal Entries to GL”.
GL Transfer can be submitted in standalone mode using the concurrent request “Transfer Journal Entries to GL”.
Example: Navigation in Payables: Other/Request/Run: Transfer
Journal Entries to GL
This spawns the Journal Import and the Data Manager programs. This request transfers all the final accounting that exists for the given ledger and end date. This method uses the interface table XLA_GLT_<groupid>.
This spawns the Journal Import and the Data Manager programs. This request transfers all the final accounting that exists for the given ledger and end date. This method uses the interface table XLA_GLT_<groupid>.
What is the setup option that determines the level of detail in
the accounting lines created for a specific transaction in XLA_AE_LINES?
Each Journal Line Type (JLT) can be setup as required to result
in either detailed or merged lines in XLA_AE_LINES.
Navigation: Accounting Setups : Subledger Accounting Setup :
Accounting Methods Builder :
Journal Entry Setups
Form :”Define Journal Line Types”
Field : “Merge Matching Lines”
Form :”Define Journal Line Types”
Field : “Merge Matching Lines”
The different options are as follows:
1) ALL – The matching lines in XLA_DISTRIBUTION_LINKS for
the specific accounting header and specific journal line type (example:
LIABILITY) are merged to create records in XLA_AE_LINES.
2) DR/CR – The matching lines in XLA_DISTRIBUTION_LINKS, for the
specific accounting header and specific journal line type (example: LIABILITY)
with debit side entries, are merged to create one debit entry in XLA_AE_LINES.
The matching lines with creditside entries are merged to create one credit side
entry in XLA_AE_LINES.
3) NO – Lines in XLA_DISTRIBUTION_LINKS for the specific
accounting header and specific journal
line type (example: LIABILITY) are not merged and copied into XLA_AE_LINES.
line type (example: LIABILITY) are not merged and copied into XLA_AE_LINES.
NOTE: This setup applies to merging lines within a specific
transaction.
What is the setup option that determines if transfer to GL is in
detail or summarised mode?
There are two variables that determine how the data is
transferred to GL from the subledger tables XLA_AE_HEADERS and XLA_AE_LINES.
These setups determine whether accounting data from across multiple
transactions in the subledger will be merged or not merged while inserting into
rows in the GL_JE_HEADERS and GL_JE_LINES tables.
a) Subledger Accounting Options
Navigation: Accounting Setups : Ledger Setup : Define :
Accounting Setups
Choose the ledger
Click on “Update Accounting Options”
Scroll to Subledger Accounting Options in the Primary Ledger section
Click on Update Icon
Click on Update Icon against the Application to be setup(Example: Payables)
Choose the ledger
Click on “Update Accounting Options”
Scroll to Subledger Accounting Options in the Primary Ledger section
Click on Update Icon
Click on Update Icon against the Application to be setup(Example: Payables)
Field: General Ledger Journal Entry Summarization
This can be set to ONE of the following:
§
Summarize by GL Period
§
Summarize by GL Date
§
No Summarization
This setup determines if the accounting header is summarized or
not.
b) Journal Line Types
Navigation: Accounting Setups : Subledger Accounting Setup :
Accounting Methods Builder : Journal
Entry Setups
Form :”Define Journal Line Types”
Field: Transfer to GL
This can be set to Summary or Detail
Entry Setups
Form :”Define Journal Line Types”
Field: Transfer to GL
This can be set to Summary or Detail
This setup determines if the accounting lines in XLA_AE_LINES
are summarized during transfer to GL.
Note 1: Lines cannot be summarised if the headers are not
summarised.
If “General Ledger Journal Entry Summarization” is set to No Summarization, the “Transfer to GL” setup in the Journal Line Types are irrelevant. The lines and headers are not summarized in this scenario.
If “General Ledger Journal Entry Summarization” is set to No Summarization, the “Transfer to GL” setup in the Journal Line Types are irrelevant. The lines and headers are not summarized in this scenario.
Note 2: Irrespective of transfer in Detail or Summary, there is
always a one-to-one correspondence between the XLA_AE_LINES and
GL_IMPORT_REFERENCES tables.
What are the different combinations of the two setup
options that determine if transfer to GL is in summary or detail and
the corresponding outcome?
GL Journal Entry
Summarization
|
JLT -Transfer to GL
|
Expected behavior
|
Summarize(By GL Date or Period)
|
Summary
|
Summarized at both GL_JE_HEADERS
and GL_JE_LINES
|
Summarize(By GL Date or Period)
|
Detail
|
Summarized at GL_JE_HEADERS,
detail GL_JE_LINES
|
No Summarization
|
Detail
|
Detailed at GL_JE_HEADERS and
GL_JE_LINES
|
No Summarization
|
Summary
|
Detailed at GL_JE_HEADERS and
GL_JE_LINES
|
Note: The last two options cause the level of detail in the GL
to be the same as in the Subledger.
WHAT COLUMNS ASSOCIATE GL DATA BACK TO
THE SLA DATA?
Since there is always a one-to-one correspondence between
XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the
subledgers.
GL_IMPORT_REFERENCES.gl_sl_link_id =>
XLA_AE_LINES.gl_sl_link_id
GL_JE_BATCHES.group_id => XLA_AE_HEADERS.group_id
GL_JE_BATCHES.group_id => XLA_AE_HEADERS.group_id
India localization Interview Questions
India localization Interview Questions
Purchase Orders
How do I view India localization Taxes
included in a PO that I would like to approve from Notification summary screen?
Notifications are generated by Workflow engine and India Localization
taxes do not appear in notification summary screen.
In order to view the Purchase Order with the Tax Amount run
‘India PO Printing report’ for the Order.
India localiztion interview questions
How do I use Supplier Merge effectively
with localization?
a. Setup ‘Supplier Additional Information’ screen for the new
Supplier before running Supplier merge report.
b. After completing the setup Run Supplier Merge
If you do not do the above, Supplier Merge Report ends with an
Error.
Which Localization tables are updated in the course
of Purchase transaction created with Localization Taxes?
When PO is created with taxes attached, records are populated
into
a. Jai_po_line_locations for Shipment level details and
b. Jai_po_taxes for tax related entries.
These tables will be updated on Insert, Update and Delete
On creating the receipt from Receipt Localized screen following
tables are populated
a. Jai_rcv_lines for line level details and
b. Jai_Rcv_Line_Taxes for tax related entries.
When the Receipt localized form is closed “For Passing
Accounting Entries “ concurrent request is submitted. This would
a. Generate Accounting Entries by populating into Gl_Interface
and
b. Populate JAI_RCV_JOURNAL_ENTRIES for Receipt Accounting
entries.
If excise types of taxes are attached then
JAI_CMN_RG_23AC_I_TRXS and JAI_CMN_RG_23AC_II_TRXS will get populated depending
upon the item classification.
On Delivery to a Bonded Sub inventory Non cenvatable Taxes would
be added to the item cost. This will insert records into
a. JAI_RCV_JOURNAL_ENTRIES for delivery entries and
b. Mtl_Material_Transactions_Temp for average cost update. The
Tax amount will be populated into Value_Change field.
Inventory transfer worker fires and pushes the record from
Mtl_Material_Transactions_Temp to mtl_material_transactions table.
When Average cost update worker fires for costing
Mtl_Transaction_Accounts and mtl_cst_txn_cost_details tables will be populated.
What do we do
when Taxes have not defaulted on PO created against the Quotation?
While Converting the Quotation to Purchase Order using Copy
Document, taxes will not flow until you run "Concurrent request for
defaulting taxes in PO when linked with quotation".
You can submit this request by navigating through
India Local Purchasing Reports Run.
This Program can be scheduled, if required.
How do taxes
default on a Purchase Orders?
India Localization Tax Configuration follows 3-way defaulting
methodology for Tax Defaulting. This feature automates defaulting of Taxes that
would be applicable to the Transactions, Below are the actual setups required
to default the taxes:
1. First two levels of tax defaulting are based on the Item
Category list, where, for every Item in the list, a Tax Category is associated.
a. First level considers the Item Category list attached to the
Supplier and Site.
b. In the absence of Item Category list for Supplier and Site
combination, the Item Category for the null Site of the Supplier is considered.
2. If neither of the above returns any Tax Category, the same is
fetched based on the Item Class assigned to the Item. Tax Category and Item
Class relationship should be set in the Tax Category window.
In all the cases, after arriving at the Tax Category, the taxes
defined thereof are defaulted. The user can make changes to the taxes that have
been defaulted.
Where all levels of defaulting fail, the user would have an
option to assign Taxes to the Shipment lines manually.
Can we change taxes on an Approved PO?
Taxes can be modified only before approving the Purchase Order.
If you need to change the taxes on approval of the Purchase Order then, create
a Purchase Order Revision by modifying the PO lines. Change Taxes on this
modified PO.
What is the impact on taxes on changing quantity on a
PO Release?
Whenever you change quantity on Releases (through the Base
Application screen), you need to navigate to Releases (Localized) screen, open
Tax Details by Clicking on the Taxes Button. Click the Apply button in Tax
details screen to enable recalculation of taxes based on the revised Quantity.
Purchase Orders - Errors
How to avoid the Error: ‘Currency conversion rate not
defined in the system’ when the PO was amended?
This error
occurs when PO is created or updated.
This will
happen only when Inventory Organization is not attached to the Ship To Location
To resolve
this:
Attach the
Inventory Organization to Ship To Location by navigating through
India
local Inventory - Setup - Organization - Location.
Quotations
How is Per landed cost calculated for a quote that
includes localization taxes?
Per landed cost = Unit Price +
[Sum (non cenvatable taxes ) / qty ]
You can view Per Landed Cost
through Quote Analysis (localized) screen by navigating through
India Local Purchasing RFQ and
Quotations Quote Analysis (localized)
How do we make the Supplier available in the Supplier
LOV on a Quotation?
Please set 'HOLD_FLAG' attribute
of the supplier to 'N' in Supplier screen.
Navigation - India Local
Purchasing - Supply base - Supplier.
Can we create multiple regimes for
service tax? Can we have the same registration value for n number of organisations?
No we can not create multiple regimes
for service tax. Yes we can have same registration numbers for multiple inventory
organisations.
Whether tax is created against
inventory org or operating unit
Tax is created against operating
units. But against inventory
organisations only we can enter
the form as transactions happen at inventory organisation level.
for finished goods what register
report is used
RG-1 register is used for finished
goods
Where the MODVAT Flag & the
recoverable Flag are available? What will happen if both Flags are disabled and
write their localized accounting entries?
MODVAT Flag available at PO level
& recoverable Flag available at the receipts level. If both the Flags are disabled, claim can not
be made.
Localised accounting entry if claimed:
Excise Duty Dr.
Cess Dr.
SHE Cess Dr.
VAT Interim recovery a/c. Dr.
To Inv AP accrual a/c. Cr.
If not claimed:
Material A/c. Dr.
To Inv. AP Accrual a/c. Cr.
What are the basic registers we use for excise?
RG-23A part-I
& II, RG23C part I & II, RG-1, PLA
Can we see the register while creating the receipt
Yes we can see.
Tools → View Register
Can we see the
localised accounting entry in PO receipt before importing?
No we can not see the localised
accounting entry in PO before importing. It is seen only after importing
A client issue is that he has made
a receipt with excise & VAT and forgotten to claim them. What will be the
solution to claim both excise & VAT?
He can claim excise by going thru
“Claim MODVAT on Receipt” form. VAT claim entry form is available for claiming VAT. (N:
India TCS/VAT/Service Tax/FBT–> Transaction –> VAT Tax Claim.
Why I’m not able to see anything in the VAT claim
form?
There may be the
following reasons for that:
i. MODVAT &
recoverable Flag are not enabled
ii. Supplier
additional information not given with site
iii. In item
classification, we have given finished goods instead of raw material
iv. In regime registration we have not defined
inventory organisation
v. Tax type we
selected VAT instead of Value Added Tax
In TB the balance for ST interim recovery account
& VAT interim recovery account is available. How to reconcile and what
steps to be made?
The following
are the reconciliation steps:
For service tax:
1. Payment
should be checked. If not, make the payment & run the concurrent “India
– Service Tax Processing”.
2. Check manual
JVs
3. Check the
invoices whether accounted or not
4. Check &
post JVs
5. Check with
PO-PO receipt
6. In GL import,
“Service Tax India”
For VAT:
1. Check the
manual JVs
2. In GL,
import, “VAT India”
3. Check for VAT
claimed in PO receipt stage
4. If claimed
then import
5. Check the
receipt entries are posted
Can we select the excise & VAT taxes in payable
invoice?
We can select
VAT but not excise.
Do we have localization payable invoice?
No.
Can we make
partial claim for VAT & excise, how?
Yes we can make
partial claim. Partial claim can be made through “VAT – Claim Terms
Definition form”
(India TCS/VAT/Service Tax/FBT → Setup → VAT – Claim
Terms Definition)
What is the
setup determining the GL date for TDS certificate generation? How to create the
TDS section code? What will be prefix for the automated TDS invoice?
From TDS year
info, we get the GL date.
Creation of TDS
Section Code: In India Localisation, Asia Pacific Lookup: The name of the lookup
is JAI_TDS_SECTION
Prefix will be
the Standard Invoice Number
What will be the accounting entry for the TDS
invoices? What will be the payment accounting entries for the TDS invoices?
At the time of
invoice generation:
a. Standard
Invoice for supplier:
Expense
a/c. Dr.
To Sundry Creditor Cr.
b. Credit Memo
for supplier:
Supplier a/c. Dr.
To TDS Payable a/c. Cr.
c. Standard
invoice for tax authority:
TDS
Payable a/c. Dr.
To Tax authority Cr.
At the time of
making payment:
a. Payment to
supplier:
Sundry
Creditor a/c. Dr.
TDS
Payable a/c. Dr.
To Bank a/c. Cr.
b. Payment to
tax authority:
Tax
Authority a/c. Dr.
To Bank a/c. Cr.
For the tax
authority invoice from where the tax authority name & the TDS account is
taken?
From tax form
itself we get tax account information and tax authority information.
Why the credit percentage is not given for TDS
tax? What is the difference between
single & cumulative threshold type?
TDS is not
recoverable tax. Hence we don’t give credit percentage.
Threshold types:
Single:
applicable to a single transaction.
Cumulative: In
this case TDS is applicable only when the cumulative purchases made from the
supplier in one financial year exceeds the specified limit.
What are the concurrent used to generate the TDS
certificate?
The concurrents are:
1. India – Process TDS Payment
2. India – Generate TDS Certificate
3. India – TDS Certificate
The claim VAT button in the PO receipt is greyed out.
What is the solution to enable this?
You would have
selected VAT instead of Value Added Tax in the tax type creation.
Is Excise invoice generation mandatory in India
Localisation?
Yes, it is
mandatory
For VAT, is
document sequencing mandatory?
Yes, it is
mandatory
When the shipment of FG over, does it affect PLA
Register or RG23A register?
It will search
in RG23A register first. In organisation additional information we give 1, 2,
3 sequence so that it looks into the
sequence which we mentioned.
What is the difference between CENVAT Flag and Excise
Flag while defining item?
CENVAT Flag is
for PO while Excise Flag is for Sales.
For a shipment the excise invoice number is not
generated. What could be the reason for this?
The following
could be the reasons
1. Customer
additional information (check for without site & with site)
2. We have not
defined order types where we define the excise invoice number generation
3. Bond register
4. Bonded
sub-inventory
5. Organisation
additional information
What is Regime Registration? Why we are not able to
select Inventory Organisation in Regime Registration?
It used to
define rules applicable to all taxes assigned to it. We need to complete this
setup before we move ahead with
other setups.
It is because we
don’t have inventory org additional information
What
is Bond Register?
The calculation
of ED & updates of excise registers are based on the setup made in the define bond register. Before making this
setup, you need to define the order types & transaction sources. Excise
transactions are classified into the following categories:
1. Domestic with Excise
2. Domestic without excise
3. Export with Excise
4. Bond Register (Export under bond)
Why to create Excise invoice number and document
Sequence? What are the concurrents involved and to run the same fo a shipment
what details are you giving?
We can not claim excise & VAT in
their absence.
For excise, “India – Excise Invoice
Generation” & we give delivery number for generation
for VAT, “India – VAT Invoice
Generation / Accounting” & we give registration value
How to insert
taxes in AP and AR invoice?
We run the following concurrents:
for AP: “India to insert tax for pay
on receipt”
for AR: “Local concurrent for
processing order lines to AR”
What is Bonded Sub-inventory and what is the use of
it?
Excise related
transactions & records will be updated only for those subinventories
which are identified as bonded for
manufacturing organisations. For example, if we have not defined bonded sub-inventory, claim can not
be made and the excise & VAT recoverable will go into the material cost. As a
result, the cost of material will rise.
What is RG Consolidation?
We perform RG
consolidation (excise) to make sure that our balances available in RG registers are adjusted against PLA
register & to find out the liability to be paid to the tax authority of excise.
What are the sources we use to import Excise, Service
Tax and VAT into GL?
For excise: Purchasing India
for VAT: VAT
India
for ST: Service
tax India
During the PO Return will the taxes be reversed? If
yes what are the reversal accounting entries?
Yes, the taxes
will be reversed.
Where to see the receipt accounting entry and
delivery accounting entry?
Receipt
accounting entry is viewed in the Receiving Transaction Summery (after the
receipt and the delivery).
N: Oracle
Purchasing → Receiving →
Receiving Transaction Summary
Delivery
Accounting Entry is viewed in Material Transaction.
N: Oracle Inv →
Transaction → Material Transaction
Can we have the same invoice number for excise and
VAT & how?
Yes we can have
the same invoice number for excise & VAT
How do you differentiate between your manufacturing
org and trading org?
When you go to
the org additional information, the accounting information will be grayed out for trading org while the trading
information will be grayed out for manufacturing org.
What is BOE invoice?
During customs
accounting process, BOE invoice is the one through which we make payment to the customs authority.
What are the setups for TCS?
Tax
Tax Category
Item Catagory
Item classification
Transaction type
Transaction source
Receipt class
Regime registration
Tax calendar
Tax authority & Tax authority
additional information
Customer & Customer additional
information
What is the difference between Accrual Basis and Cash
Basis?
The accrual
accounting method recognises the revenue when it is earned & expenses when they are incurred. While cash
basis accounting recognises revenue & expense when cash is actually spent or
received.
How to create tax code for VAT?
Through Asia
pacific lookup, the look-up name is JAI_TAX_TYPE
What is Subledger
Accounting?
#Subledger Accounting is a Service, not an Application.
#There are no SLA responsibilities and there is no direct
login to SLA.
#SLA forms and programs are embedded within
standard Oracle Application responsibilities(e.g.
Payables Manager).
o Simply, It is a rule-based accounting engine, toolset &
repository supporting Oracle E-Business Suite modules.
o Allows multiple accounting representations for a single
business event, resolving conflicts between corporate
and local fiscal accounting requirements.
o Retains the most granular level of detail in the
subledger accounting model, with different
summarization options in the General Ledger, allowing
full auditability and reconciliation.
Blogger Comment
Facebook Comment