http://www.oraerp.com/ Fri, 24 May 2013 10:47:42 +0000 MyBB http://www.oraerp.com/Thread-Creating-ODG-for-DB-part-of-Oracle-Apps-R12-1-3 Tue, 21 May 2013 07:07:01 -0500 http://www.oraerp.com/Thread-Creating-ODG-for-DB-part-of-Oracle-Apps-R12-1-3
Please provide the doc. id's or the steps to perform the same.

One thing more, do I need to take special precautions for my Application Tier? Do I need to apply some additional patches on Application Tier before creating the ODG for the DB part??

Regards,
Sandy]]>
Please provide the doc. id's or the steps to perform the same.

One thing more, do I need to take special precautions for my Application Tier? Do I need to apply some additional patches on Application Tier before creating the ODG for the DB part??

Regards,
Sandy]]> http://www.oraerp.com/Thread-Oracle-General-Ledger-Questions-and-Answers Tue, 14 May 2013 08:22:44 -0500 http://www.oraerp.com/Thread-Oracle-General-Ledger-Questions-and-Answers Ans. There are 3 balance types.
- Actuals
- Budgets - Encumbrance

2. What is the difference between Budget and Encumbrance Journals?
Budget: Budget balances are the funds are allocated to the various accounts. (Fund Allocated)
Encumbrance: Encumbrance balances are the funds reserved for the budgets for future expenses. (Fund Reserved)

3. What is the difference between Intra and Inter Company in GL?
a. Intra Company Journals: These journals are created between the transactions of one or more balancing segments of same Legal Entity.
b. Inter Company Journals: These Journals are created for the transactions between the balancing segments of one or more Legal Entities.
Example, Lets say
TATA Motors India (LE) having 2 BSV i.e. 01(Tata Motors Pune) and 02 (Tata Motors Gujarat)
TATA Steel India (LE) having 2 Bsv i.e. 03 and 04
Transaction between 01 and 02 is Intra Company
Transaction between 01 and 03 is Inter Company]]> Ans. There are 3 balance types.
- Actuals
- Budgets - Encumbrance

2. What is the difference between Budget and Encumbrance Journals?
Budget: Budget balances are the funds are allocated to the various accounts. (Fund Allocated)
Encumbrance: Encumbrance balances are the funds reserved for the budgets for future expenses. (Fund Reserved)

3. What is the difference between Intra and Inter Company in GL?
a. Intra Company Journals: These journals are created between the transactions of one or more balancing segments of same Legal Entity.
b. Inter Company Journals: These Journals are created for the transactions between the balancing segments of one or more Legal Entities.
Example, Lets say
TATA Motors India (LE) having 2 BSV i.e. 01(Tata Motors Pune) and 02 (Tata Motors Gujarat)
TATA Steel India (LE) having 2 Bsv i.e. 03 and 04
Transaction between 01 and 02 is Intra Company
Transaction between 01 and 03 is Inter Company]]> http://www.oraerp.com/Thread-Licensing-for-Oracle-Cloud Tue, 14 May 2013 02:43:48 -0500 http://www.oraerp.com/Thread-Licensing-for-Oracle-Cloud I will appreciate if someone can help us to the document that explains Oracle Cloud licensing structure.
Thank you]]> I will appreciate if someone can help us to the document that explains Oracle Cloud licensing structure.
Thank you]]> http://www.oraerp.com/Thread-API-for-updating-pay-people-groups Tue, 14 May 2013 02:40:03 -0500 http://www.oraerp.com/Thread-API-for-updating-pay-people-groups Is there any API for updating pay_people_groups table. I know we can do it using hr_assignment_api.update_emp_asg_criteria but this API updates the assignement with the new pay_group_id. I want to know is there is any API which can only update the pay_people_groups and not the assignment.
Regards,]]> Is there any API for updating pay_people_groups table. I know we can do it using hr_assignment_api.update_emp_asg_criteria but this API updates the assignement with the new pay_group_id. I want to know is there is any API which can only update the pay_people_groups and not the assignment.
Regards,]]> http://www.oraerp.com/Thread-RFQ-from-buyer-work-center Tue, 14 May 2013 02:36:56 -0500 http://www.oraerp.com/Thread-RFQ-from-buyer-work-center We are unable to find out why there is no action to print a RFQ (or RFI) from the buyer work center. There is no option for it Under the action LOV. How could it be done without returning to Forms screen and even there what is the concurrent programs to print it if it exist ?

Regards,]]> We are unable to find out why there is no action to print a RFQ (or RFI) from the buyer work center. There is no option for it Under the action LOV. How could it be done without returning to Forms screen and even there what is the concurrent programs to print it if it exist ?

Regards,]]> http://www.oraerp.com/Thread-AP-Supplier-set-up Tue, 14 May 2013 02:34:30 -0500 http://www.oraerp.com/Thread-AP-Supplier-set-up Can anyone help me to adjust the country in the supplier set-up of AP Japan Responsibility?

The Responsibility is AP Support User-->Suppliers-->Supplier Sites

Standard needs to be Japan where it is now United States.

For example if i choose any Supplies and then go to Sites then its showing United States where it should be Japan.

How to approach ? Any Form personalization if so how will i approach to that?

Thanks for any help if forwarded.]]> Can anyone help me to adjust the country in the supplier set-up of AP Japan Responsibility?

The Responsibility is AP Support User-->Suppliers-->Supplier Sites

Standard needs to be Japan where it is now United States.

For example if i choose any Supplies and then go to Sites then its showing United States where it should be Japan.

How to approach ? Any Form personalization if so how will i approach to that?

Thanks for any help if forwarded.]]> http://www.oraerp.com/Thread-ORACLE-HOME-issue-with-DBCA Mon, 06 May 2013 03:26:52 -0500 http://www.oraerp.com/Thread-ORACLE-HOME-issue-with-DBCA I am trying to create a new database with 11.2.0.3 binaries, which is cloned from R12 PROD, But failed due to the dbca invoking wrong OH. I opened the dbca source code[file], the OH parameter value is wrongly defined. I corrected the parameter and i tried but its taking same path again [Wrong one].

If any one please, let me know what are all the files that dbca using while creating the database.]]> I am trying to create a new database with 11.2.0.3 binaries, which is cloned from R12 PROD, But failed due to the dbca invoking wrong OH. I opened the dbca source code[file], the OH parameter value is wrongly defined. I corrected the parameter and i tried but its taking same path again [Wrong one].

If any one please, let me know what are all the files that dbca using while creating the database.]]> http://www.oraerp.com/Thread-Where-Should-EBS-Concurrent-Managers-be-Located Wed, 01 May 2013 13:56:01 -0500 http://www.oraerp.com/Thread-Where-Should-EBS-Concurrent-Managers-be-Located
blogs.oracle.com/stevenChan/entry/where_should_ebs_concurrent_managers]]>
blogs.oracle.com/stevenChan/entry/where_should_ebs_concurrent_managers]]> http://www.oraerp.com/Thread-Registration-is-Open-for-Oracle-OpenWorld-2013 Sat, 27 Apr 2013 16:59:06 -0500 http://www.oraerp.com/Thread-Registration-is-Open-for-Oracle-OpenWorld-2013
Super Saver Pricing through May 3
Oracle OpenWorld features thousands of sessions from which attendees can choose, including keynotes, technical sessions, demos, and hands-on labs. Hundreds of exhibitors will be on hand to share what they’re bringing to the leading edge of Oracle technology. And you’ll have nearly an infinite number of opportunities to network, trade information with peers, and gain insights from experts. The sooner you sign up, the more you can save]]>
Super Saver Pricing through May 3
Oracle OpenWorld features thousands of sessions from which attendees can choose, including keynotes, technical sessions, demos, and hands-on labs. Hundreds of exhibitors will be on hand to share what they’re bringing to the leading edge of Oracle technology. And you’ll have nearly an infinite number of opportunities to network, trade information with peers, and gain insights from experts. The sooner you sign up, the more you can save]]> http://www.oraerp.com/Thread-Oracle-is-1-in-the-RDBMS-Market-Share-Worldwide-for-2012 Mon, 15 Apr 2013 00:24:34 -0500 http://www.oraerp.com/Thread-Oracle-is-1-in-the-RDBMS-Market-Share-Worldwide-for-2012 Gartner has published their market share numbers for 2012 based on total software revenues...
check on
http://www.oracle.com/us/corporate/featu...index.html]]> Gartner has published their market share numbers for 2012 based on total software revenues...
check on
http://www.oracle.com/us/corporate/featu...index.html]]> http://www.oraerp.com/Thread-GL-Void-Payment Fri, 05 Apr 2013 10:29:42 -0500 http://www.oraerp.com/Thread-GL-Void-Payment User accidentally opened APR-2014 Payables period instead of APR-2013!!!
User then voided 2 payments with the date of 01-APR-2014 instead of 01-APR-2013!!!!!!
How can this situation be solved?]]> User accidentally opened APR-2014 Payables period instead of APR-2013!!!
User then voided 2 payments with the date of 01-APR-2014 instead of 01-APR-2013!!!!!!
How can this situation be solved?]]> http://www.oraerp.com/Thread-Steps-to-Produce-SLA-for-Payroll-in-R12 Sat, 30 Mar 2013 04:20:10 -0500 http://www.oraerp.com/Thread-Steps-to-Produce-SLA-for-Payroll-in-R12
Solution:

Items:-
(1) Formula:
AMB = JLD (= JLT + ADR + JED) + AAD + SLAM + Mapping Sets

Notes:
AMB = Accounting Methods Builder
AAD = Assign JLD to each event classes
SLAM = Sub-Ledger Accounting Method
JLD = Journal Line Definition; Assign ADR to each JLT
JLT = Journal Line Type; Creation of Debit and Credit information for each Event
Classes
ADR = Accounting Definition Rules; To establish rule for CCID @ transaction level
JED = Journal Entry Description; Define Journal Header/Line Description

(2) Events Classes:
o Payroll Cost
o Payment Cost
o Estimated Cost
o Reversal Estimated Cost

a) JLD (Journal Line Definition):
Step # 1: Create JLT for each of the above Event Classes i.e Debit and
Credit Side
Step # 2: Create ADR for Dr/Cr of each Event Classes (Choose
Assignment Payroll Name in Source)
Step # 3: Assign ADR to each JLT in JLD

b) AAD (Application Accounting Definition):
Step # 4: Assign JLD to Event Classes

c) SLAM (Sub-Ledger Accounting Method):
Step # 5: Create SLAM and assign AAD to this SLAM

d) General Ledger:
Step # 6: Create Ledger from Accounting Setups in ASM (Accounting
Setup Manager) and assign to SLAM

Processes to run Payroll SLA:

Step # 1: Payroll Run
Step # 2 : Prepayment
Step # 3: Costing
Step # 4: Transfer to SLA from HRMS Responsibility
Step # 5: Run Create Accounting program from Global/Payroll Responsibility
Step # 6: Review or Post Payroll Batch in GL

  Steps to Produce SLA for Payroll in R12.pdf (Size: 291.45 KB / Downloads: 21) ]]>
Solution:

Items:-
(1) Formula:
AMB = JLD (= JLT + ADR + JED) + AAD + SLAM + Mapping Sets

Notes:
AMB = Accounting Methods Builder
AAD = Assign JLD to each event classes
SLAM = Sub-Ledger Accounting Method
JLD = Journal Line Definition; Assign ADR to each JLT
JLT = Journal Line Type; Creation of Debit and Credit information for each Event
Classes
ADR = Accounting Definition Rules; To establish rule for CCID @ transaction level
JED = Journal Entry Description; Define Journal Header/Line Description

(2) Events Classes:
o Payroll Cost
o Payment Cost
o Estimated Cost
o Reversal Estimated Cost

a) JLD (Journal Line Definition):
Step # 1: Create JLT for each of the above Event Classes i.e Debit and
Credit Side
Step # 2: Create ADR for Dr/Cr of each Event Classes (Choose
Assignment Payroll Name in Source)
Step # 3: Assign ADR to each JLT in JLD

b) AAD (Application Accounting Definition):
Step # 4: Assign JLD to Event Classes

c) SLAM (Sub-Ledger Accounting Method):
Step # 5: Create SLAM and assign AAD to this SLAM

d) General Ledger:
Step # 6: Create Ledger from Accounting Setups in ASM (Accounting
Setup Manager) and assign to SLAM

Processes to run Payroll SLA:

Step # 1: Payroll Run
Step # 2 : Prepayment
Step # 3: Costing
Step # 4: Transfer to SLA from HRMS Responsibility
Step # 5: Run Create Accounting program from Global/Payroll Responsibility
Step # 6: Review or Post Payroll Batch in GL

  Steps to Produce SLA for Payroll in R12.pdf (Size: 291.45 KB / Downloads: 21) ]]> http://www.oraerp.com/Thread-RFQ-auto-create-PO Sun, 10 Mar 2013 14:27:57 -0500 http://www.oraerp.com/Thread-RFQ-auto-create-PO Can i create PO from RFQ in PO modules ?
Cheers,]]> Can i create PO from RFQ in PO modules ?
Cheers,]]> http://www.oraerp.com/Thread-Functionality-Features-difference-between-R12-and-11i Tue, 05 Mar 2013 10:30:44 -0600 http://www.oraerp.com/Thread-Functionality-Features-difference-between-R12-and-11i Functionality/Features difference between Oracle eBusiness Suite R12 and R11i
Oracle Financials - GL, FA, AP, AR, CM
Oracle SCM - PO
Oracle HRMS

  Fin_Functional_Analysis_11ivsR12_v1 0.xlsx (Size: 74.29 KB / Downloads: 105)

  PO_Functional_Analysis_11ivsR12_v1 0.xls (Size: 23.5 KB / Downloads: 49)

  HRMS_Functionality Diff R12-11i V1.0.xls (Size: 35 KB / Downloads: 53) ]]> Functionality/Features difference between Oracle eBusiness Suite R12 and R11i
Oracle Financials - GL, FA, AP, AR, CM
Oracle SCM - PO
Oracle HRMS

  Fin_Functional_Analysis_11ivsR12_v1 0.xlsx (Size: 74.29 KB / Downloads: 105)

  PO_Functional_Analysis_11ivsR12_v1 0.xls (Size: 23.5 KB / Downloads: 49)

  HRMS_Functionality Diff R12-11i V1.0.xls (Size: 35 KB / Downloads: 53) ]]> http://www.oraerp.com/Thread-How-to-create-Work-Order Sun, 03 Mar 2013 11:02:44 -0600 http://www.oraerp.com/Thread-How-to-create-Work-Order Could you tell about What is work order creations & steps to create.
Not sure if below steps are right.
work order process -->to create work oder---> work request ----> bom ----> routing -->
Thanks]]> Could you tell about What is work order creations & steps to create.
Not sure if below steps are right.
work order process -->to create work oder---> work request ----> bom ----> routing -->
Thanks]]> http://www.oraerp.com/Thread-Withdrew-Resignation-using-SSHR Sun, 03 Mar 2013 11:01:04 -0600 http://www.oraerp.com/Thread-Withdrew-Resignation-using-SSHR
We have a business requirement of employees submitting and withdrawing resignations using SSHR. We are on R12.1.3 and we are planning to use the standard “Voluntary Termination” Feature for the same.

Using the standard function employee can initiate the resignation process and get it approved, but what in cases if resignation has to be withdrawn? We need to know how employee can withdraw resignation. The only current option which is available is to ask the HR guy to update the details using End employment form, but we want to know if the standard function can be extended to achive the requirement.

We are not looking for an EIT initiation process, that will be the last option to go for. I am sure many of us would have faced this requirement and would hv some solutions.]]>
We have a business requirement of employees submitting and withdrawing resignations using SSHR. We are on R12.1.3 and we are planning to use the standard “Voluntary Termination” Feature for the same.

Using the standard function employee can initiate the resignation process and get it approved, but what in cases if resignation has to be withdrawn? We need to know how employee can withdraw resignation. The only current option which is available is to ask the HR guy to update the details using End employment form, but we want to know if the standard function can be extended to achive the requirement.

We are not looking for an EIT initiation process, that will be the last option to go for. I am sure many of us would have faced this requirement and would hv some solutions.]]> http://www.oraerp.com/Thread-Requisition-Interface Mon, 25 Feb 2013 08:47:53 -0600 http://www.oraerp.com/Thread-Requisition-Interface I have a requisition in which I am inserting into PO_REQUISITIONS_INTERFACE_ALL. The requisition has 5 lines, no distributions.

I then run the Requisition Import Concurrent Program (REQIMPORT) and all the successful lines are inserted into the base tables successfully. Any failed lines with invalid values are omitted. So if 1 line failed, the requisition will have 4 lines in the base table (PO_REQUISITION_LINES_ALL ).

However, my requirement is that if one line fails, the requisition should not be created.

We have considered calling the Delete Requisition API to delete the incomplete requisition, then reprocess the requisition with correct values.

Has anyone come across this problem before? Any potential or better solutions?

Appreciate your help.]]> I have a requisition in which I am inserting into PO_REQUISITIONS_INTERFACE_ALL. The requisition has 5 lines, no distributions.

I then run the Requisition Import Concurrent Program (REQIMPORT) and all the successful lines are inserted into the base tables successfully. Any failed lines with invalid values are omitted. So if 1 line failed, the requisition will have 4 lines in the base table (PO_REQUISITION_LINES_ALL ).

However, my requirement is that if one line fails, the requisition should not be created.

We have considered calling the Delete Requisition API to delete the incomplete requisition, then reprocess the requisition with correct values.

Has anyone come across this problem before? Any potential or better solutions?

Appreciate your help.]]> http://www.oraerp.com/Thread-R12-1-3-Upgrade-from-11-5-10 Mon, 25 Feb 2013 08:42:40 -0600 http://www.oraerp.com/Thread-R12-1-3-Upgrade-from-11-5-10 We are in the process of upgrading the 11.5.10 Instance to R12.1.3.
The current Architecture is Dual Node with the Application Tier on one node and the CM and the DB Tier on another node.
On Future R12 the Application Tier is going to be on two nodes and the the DB on RAC.

What I will be doing is R12.1.1 Installation with Upgrade Option.

What should be the procedure to have multiple application servers?

Finish the upgrade on one Application Node and then clone the other Application Tiers?
Please suggest.]]> We are in the process of upgrading the 11.5.10 Instance to R12.1.3.
The current Architecture is Dual Node with the Application Tier on one node and the CM and the DB Tier on another node.
On Future R12 the Application Tier is going to be on two nodes and the the DB on RAC.

What I will be doing is R12.1.1 Installation with Upgrade Option.

What should be the procedure to have multiple application servers?

Finish the upgrade on one Application Node and then clone the other Application Tiers?
Please suggest.]]> http://www.oraerp.com/Thread-Migrating-Oracle-E-Business-Suite-R12-from-Linux-32-bit-to-Linux-64-bit Sat, 23 Feb 2013 12:08:42 -0600 http://www.oraerp.com/Thread-Migrating-Oracle-E-Business-Suite-R12-from-Linux-32-bit-to-Linux-64-bit want to Migrating Oracle E-Business Suite R12 from Linux 64-bit
require suggestions]]> want to Migrating Oracle E-Business Suite R12 from Linux 64-bit
require suggestions]]> http://www.oraerp.com/Thread-Supplier-definition-Restrict-to-selected-Operating-Unit Thu, 21 Feb 2013 16:48:04 -0600 http://www.oraerp.com/Thread-Supplier-definition-Restrict-to-selected-Operating-Unit How we can restrict the supplier defined only to specific OU's. what i mean supplier should be available only for specific OU or ledger.]]> How we can restrict the supplier defined only to specific OU's. what i mean supplier should be available only for specific OU or ledger.]]>