Line Drilldown in GL Journal Screen Requires User Name and Password

Problem
One of my clients was complaining about error “You Have Insufficient Privileges For The Current Operation” while Line Drill down from GL Journal screen. Internet explorer version was 6.0.2900 with Java 6 update 21. Oracle suggestion in METALINK note “1106048.1“ is Uninstall all updates on Java 6 which are more than 15. What does it means, Java version should be Java 6 with Update 15 maximum. Downgrading Java is a problem as might some other Application requires latest Java Version. It’s always hectic to explain to the client with business reason. So this option out of scope. Later on I found out that issue is because of one option only and no need to uninstall all updates.
Solution
1. On the local computer, move to the Control Panel – choosing Start/Settings/Control Panel – Choose the Java icon
2. A window opens – choose the advanced tab
3. Locate the entry for Java Plug-in – expand this option (refer to Image below)
4. Uncheck the Enable the next-generation Java Plug-in box (refer to Image below)
5. Restart the browser and retest the issue.

How to Create Code Combination ID by API

I was on an integration assignment between Home Grown Project System and Oracle Payable. A big gap which I faced there was how to maintain single source of Account Code Combinations. We had following options to manage this issue.
Built a View of GL_CODE_COMBINATIONS table and pass Combination and ID from Oracle to Custom System
Use API and create Code Combination
I used second way to handle this. Here is script which i used in that Assignment ( it works for me but you need to be careful as it’s not documented any where 🙂
—–Create Function
CREATE OR REPLACE FUNCTION APPS.XXX_CREATE_CCID
( P_CONCAT_SEGS IN VARCHAR2
) RETURN VARCHAR2
IS
L_STATUS BOOLEAN;
L_COA_ID NUMBER;
BEGIN
SELECT CHART_OF_ACCOUNTS_ID
INTO L_COA_ID
FROM GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = 2021; –UPDATE THIS WITH SET OF BOOKS ID

L_STATUS := FND_FLEX_KEYVAL.VALIDATE_SEGS(
‘CREATE_COMBINATION’,
‘SQLGL’,
‘GL#’,
L_COA_ID,
P_CONCAT_SEGS,
‘V’,
SYSDATE,
‘ALL’, NULL, NULL, NULL, NULL,
FALSE,FALSE, NULL, NULL, NULL);
IF L_STATUS THEN
RETURN ‘S’;
ELSE
RETURN ‘F’;
END IF;
END ;
/

—–EXECUTE FUNCTION
DECLARE
RETVAL VARCHAR2(200);
P_CONCAT_SEGS VARCHAR2(200); /* ‘10.2001.2211101.987872.001.0000’ THIS COMBINATION I WANT TO CREATE */
BEGIN
RETVAL := APPS.XXX_CREATE_CCID ( P_CONCAT_SEGS );
COMMIT;
END;

Julian to Gregorian Calender Switch impact on Oracle

Do you see something abnormal in following image?

oct-1582

Yes …….what’s this ……?

And same thing you will see on some other ERP solutions / software once you select September 1752.

Answer

The calendar snippet shows that there are no days between October 4 and October 15. This discontinuity is called the “cutover”.

What is Cutover

“This is a hybrid Julian/Gregorian calendar with a cutover on October 4/15 1582.” Any dates before a cutover are Julian, any dates during a cutover are nonexistent, and any dates after a cutover are Gregorian.

What is Content Set In Financial Statement Generator (FSG).

Content Set In FSG

A content set is used to override row set account assignments to generate different variations of the same report without defining separate reports. Most of the time, content sets are used to generate a given report for every value in a segment of the Chart of Accounts—for example, a Standard report that repeats for each company in the Chart of Accounts. To enter content sets, follow the navigation path Reports à Define à Content Set. Enter the name of the content set, an optional description, and the type. The type determines whether the run order of the reports will be sequential or parallel.

Next, define the Account Assignments for the content set. This is very similar to the Account Assignments form you saw in the Define Rows/Columns form. However, since content set overrides the row set, you do not need to fill in all segments. The segments without any value will fall back to the row set account assignments. Only need to define what display types to use to override the row set. Valid display types are listed in Below Table.

N

No override

CT

Summation of balances of all segment values within the account range.

PE

Expand the account range or parent value into detail segment values. In addition, it will page break after each segment value creating a different report.

PT

Override the account range but maintain the row set display types (E, T, B).

RE

Expand the account range or parent value into detail segment values. Same as E in defining rows.

RT

Total the segment values for the segment. Same as T in defining rows.

RB

Show both detail and total for the account range or the parent value. Same as B in defining rows.

How to get JV more then a specific Amount

Connect by Apps user name and just enter Amount when Prompted.We can use this query in Oracle Alerts to Notify GL Manager

SELECT gjh.NAME, gjh.running_total_cr, gjh.running_total_dr,
gjh.currency_code, gjlv.description, gsnv.NAME,
DECODE (NVL (gjlv.entered_dr, 1),
1, ‘CREDIT’,
gjlv.entered_dr, gjlv.entered_dr
) debit,
DECODE (NVL (gjlv.entered_cr, 1),
1, ‘DEBIT’,
gjlv.entered_cr, gjlv.entered_cr
) credit,
gjlv.period_name,
( gccv.segment1
|| ‘ ‘
|| gccv.segment2
|| ‘ ‘
|| gccv.segment3
|| ‘ ‘
|| gccv.segment4
|| ‘ ‘
|| gccv.segment5
|| ‘ ‘
|| gccv.segment6
|| ‘ ‘
|| gccv.segment7
|| ‘ ‘
|| gccv.segment8
) ACCOUNT,
gjlv.entered_cr, gjlv.entered_dr
FROM gl_je_headers gjh,
gl_je_lines_v gjlv,
gl_sob_names_v gsnv,
gl_code_combinations_v gccv
WHERE ( (gjlv.je_header_id = gjh.je_header_id)
AND (gsnv.set_of_books_id = gjlv.set_of_books_id)
AND (gjlv.code_combination_id = gccv.code_combination_id)
)
AND (gjh.running_total_dr > :amount OR gjh.running_total_cr > :amount)

Oracle Purchasing with Other Oracle Applications Modules

Oracle Purchasing with Other Oracle Applications Modules

Oracle Purchasing integrates with a number of other Oracle Applications modules, including:

· Oracle Order Entry

· Oracle Inventory

· Oracle Work flow

· Oracle Material Resource Planing

· Oracle Projects

· Oracle Human Resources

· Oracle Alert

· Oracle Quality

· Oracle EDI Gateway

· Oracle General Ledger

Oracle Order Entry

Once the internal requisition has been approved and interfaced to Order Entry, the sales order must proceed through the order cycle. This includes pick release, ship confirm, and inventory interface processing (not Supplier), which can automatically create internal sales orders in Oracle Order Entry. Internal sales orders are those that are ordered from another organization within your own company. The organization that fulfills the order is the selling organization, while the organization with the purchase requisition is the buying organization.

Oracle Inventory

Purchasing increases Inventory’s on-hand balance when POs are received and delivered. Internal requisitions, mentioned above, also affect demand once the item has been reserved and depletes the shipping organization’s on-hand balance once it has been shipped.

Oracle Work flow

There are two areas where Oracle Purchasing integrates with Oracle Work flow. The first is Account Generator, with a work flow process that defines the business rules in which account combinations are generated. The second area consists of some seeded approval work flow processes. These work flow processes read the approval business rules and hierarchies you set up in Oracle Purchasing, and they drive purchasing documents such as purchase requisitions and purchase orders through defined approval business rules and hierarchies.

Oracle Material Resource Planing

The material planning process in Oracle Material resource planing automatically generates purchase requisitions for raw materials (goods) or outside processing (services).

Oracle Projects

When you buy goods and/or services for a particular project, Oracle Purchasing, which allows you to capture project information on purchasing documents, integrates with Oracle Projects.

Oracle Human Resources

Oracle Purchasing shares employees and positions information with Oracle Human Resources. The two also share position hierarchies if approvals in Oracle Purchasing and Human Resources are set up to use the same position hierarchies.

Oracle Alert

Oracle Purchasing has some seeded alerts to help monitor exceptions and buyer performances, get notified with releases and expirations against planned and/or blanket purchase orders, and identify potential forecast overconsumption.

Oracle Quality

You can capture quality data, which will be automatically stored in Oracle Quality, during receiving. You can also make the capturing of quality data mandatory in Oracle Purchasing.

Oracle EDI Gateway

Oracle EDI gateways offers EDI capability to Oracle Purchasing. Supported purchasing EDI transactions in Oracle EDI gateways are Inbound Price/Sales Catalog (832), Inbound Response to Request for Quote (843), Inbound Ship Notice/Manifest (856), Inbound Shipping and Billing Notice (857), Outbound Planning Schedule (830), Outbound Shipping Schedule (862), Outbound Purchase Order (850), and Outbound Purchase Order Change request (860).

Oracle General Ledger

Oracle Purchasing posts encumbrance entries and receipt accrual entries to Oracle General Ledger.