Best Of
Re: Issue running EBS w Java 8.471 on Edge 142.0.3595.65
We are having this as well and no one can view output . . .
J.C.
Re: Journal generator and interunit journals for external system
The journal must be balanced by Business Unit in addition to all other balancing chartfields based on your ledger configuration - as you've noted above. There should be two business unit fields - one is the Application BU and one is the General Ledger BU. And you need to note one of the lines as the anchor.
In the example above, you would want, in your accounting table (affiliates adjusted from your example above):
BU1 GLBU1 AC1 $10 *Anchor Line
BU1 GLBU1 AC2 ($10) Aff GLBU2
BU1 GLBU2 AC2 $10 Aff GLBU1
BU1 GLBU2 AC1 $(10)
And you would want to be sure your Journal Generator Setup was set to use the Application BU.
When journal generating, the assumption is that the Balancing Entries are already present in the accounting details.
Robert
Re: Issue running EBS w Java 8.471 on Edge 142.0.3595.65
same issue with us
Bowen
Re: Question for 1099 Supplier Changes for 2025
Hi @User_GPTP2,
For new suppliers added, you only need to add Withholding Types 2025M/2025N to the supplier location.
For existing suppliers, you will no longer need 1099. However, you still need to retain 1099M/1099N on all your withholding suppliers for possible corrections that can occur within a 3 year span.
Hope this helps,
Gail
Re: Oracle Java Vs Open JDK
Hi Team,
Thank you for reaching out to Oracle Communities. We will arrange for an expert to review your post and work with you at the earliest.
Regards,
Satheesh Kumar N
Re: Can Links to Fluid Pages on the Fluid Expense Workcenter Open without leaving the Workcenter?
It was determined this is a peopletools limitation still existing on 8.62 that impacts all fluid workcenters where a link takes the user to a fluid page. I have created an enhancement idea at the following link for this:
https://community.oracle.com/mosc/discussion/4591575/ability-to-remain-within-the-fluid-workcenter-after-clicking-a-link-to-be-taken-to-a-fluid-page/p1?new=1
Re: Can Links to Fluid Pages on the Fluid Expense Workcenter Open without leaving the Workcenter?
The OSS Team has raised the below new Urgent Defect for the FIN Expenses Development team to further analyze:
DEFECT # 38373244
TITLE:
EX: Upon Clicking Onto Fluid Expenses WorkCenter Links to Fluid Delivered Pages the System Quits the WorkCenter, and Removes the Left Menu Panel, Unlike When Clicking Online Classic Links
PROBLEM:
Within the configuration of the Fluid Expenses WorkCenter Pagelet, new settings have been added into the My Links section pointing to the delivered Fluid pages of:
- Create Expense Report - My Wallet - My Expense Reports - Expenses History
When the Users navigate to the Fluid WorkCenter, and click on any of these new links added, the system automatically quits the WorkCenter Menu/Component, and directly loads the corresponding page occupying the whole screen. This is a different behavior than that of links pointing to the same features, but in online Classic, where the page gets loaded in the right hand side of the screen, leaving the WorkCenter menu left panel untouched.
REPLICATION STEPS:
1.- Log into the FSCM 9.2 Online Application as a System Administrator.
2.- Navigate to: Enterprise Components > WorkCenter/Dashboards > Configure Pagelets
3.- Open the delivered Configuration ID EX.
4.- Go to the Links tab.
5.- Scroll under display the Link Group 4 (Expense Report).
6.- Click on the + icon to add a new row within the Link List grid.
7.- On the new row, click on the Define link.
8.- This loads the Define Link/Security pop-up page, where the 'Select Menu Item' link is to be clicked.
9.- On the Select Content Reference sub-page, check the 'Include hidden Crefs' check-box.
10.- Expand the 'Fluid Structure Content' option.
11.- Expand the 'Fluid Pages' option.
12.- Expand the 'Travel and Expenses' option.
13.- Click on the 'Expense Create Report' link, (Menu Item EPEX_ADD_EXPRPT_FL_GBL).
14.- Select the 'Override Label' check-box, enter a Label, and click on OK button.
15.- Perform steps 6 through 14, adding the below 3 additional menu options:
- My Expense Reports (Menu Item EPEX_EXP_LIST_FL_GBL).
- My Wallet (Menu Item EPEX_MY_WALLET_FL_GBL).
- Expense History (Menu Item EP_EX_HIST_MD_FL_GBL).
16.- Save the changes.
17.- Click on the 'Activate Links Settings' button.
18.- Log into the FSCM 9.2 Online Application as an Expenses User.
19.- Go to the Fluid Employee Self Service Homepage, and click on the Expenses WorkCenter tile.
20.- Confirm that the 4 new options get properly displayed under the My Links section.
21.- PROBLEM 1: Click on the 'Create Expense Report' link for the Fluid page, and confirm that the system is quitting the Fluid Expenses WorkCenter, to directly load the Expense Report header Fluid page/component.
22.- PROBLEM 2: Click on the 'My Expense Reports' link for the Fluid page, and confirm that the system is quitting the Fluid Expenses WorkCenter, to directly load the My Expense Reports Fluid page/component.
23.- PROBLEM 3: Click on the 'My Wallet' link for the Fluid page, and confirm that the system is quitting the Fluid Expenses WorkCenter, to directly load the My Wallet Fluid page/component.
24.- PROBLEM 4: Click on the 'Employee History' link for the Fluid page, and confirm that the system is quitting the Fluid Expenses WorkCenter, to directly load the Expense History Fluid page/component, with the additional problem that the 'Expense Report History', and 'My Wallet History' filter options are missing altogether.
BUSINESS IMPACT:
Users are constantly driven out of the Fluid Expenses WorkCenter main Component/Menu, so once the needed task is completed, they need to go back to the main Homepage, and open again the Fluid Expenses WorkCenter functionality. This is not User friendly, and defies the whole purpose of being on a WorkCenter.
EXPECTED BEHAVIOR:
The Fluid Expenses WorkCenter is working as per expected if the User clicks on the delivered Online Classic links for the same features. Each page gets loaded on the right hand side of the screen, while the left hand side contains the menu panel of the WorkCenter. If Fluid UI is to be adopted by Users, and rolled out by customers, the Fluid page links should behave in the same manner, keeping the Expenses WorkCenter framework and logic in the main page.
Re: Retrieve a Message from the Work Center
It's not easy. The Work Centre messages are held hierarchically in table F01131M, where each row is identified by a serial number and also carries the serial number for it's parent so you have to step through the messages to find the actual error you want.
We have one orchestration that looks at the Work Centre messages to return an error message to an external system and uses a recursive SQL to generate all of the error messages for a specific transaction and then returns them in a text file via SFTP.
We use a Database Connector to run the SQL and build the text file. Substitution data is populated in the error message. The following code snippet will hopefully help:
All the best
Jonathan
// Retrieve the error messages associated with the rejected voucher...
def sqlErr = " select zmppsrk" +
" , zmpsrk" +
" , zmserk" +
" , frdsca" +
" , zmlv" +
" , zmtsv" +
" , zmtmpi" +
" from ${dta}.f01131m" +
" left outer join dd920.f9203" +
" on frdtai = zmtmpi" +
" where (zmppsrk = (select max(zmppsrk)" +
" from ${dta}.f01131m" +
" where zmtmpi = 'LM0012'" +
" and zmtsv like '%${ediBatch}%') or" +
" zmppsrk = (select min(zmserk)-1" +
" from ${dta}.f01131m" +
" where zmtmpi in ('LM0002', 'LM0006', 'LM0007', 'LM0008')" +
" and zmtsv like '%${caseID}_${YMD}%'))" +
" and zmserk >= (select min(zmserk)-1" +
" from ${dta}.f01131m" +
" where zmtmpi in ('LM0002', 'LM0006', 'LM0007', 'LM0008')" +
" and zmtsv like '%${caseID}_${YMD}%')" +
" start with zmpsrk = (select min(zmpsrk)" +
" from ${dta}.f01131m" +
" where zmtmpi in ('LM0002', 'LM0006', 'LM0007', 'LM0008')" +
" and zmtsv like '%${caseID}_${YMD}%')" +
" connect by nocycle zmpsrk = prior zmserk" +
" order by 3, 2, 1";
if (debug) { orchAttr.writeDebug(dbgPrefix + "0055 - SQL: " + sqlErr); }
PreparedStatement prpErr = sqlConnection.prepareStatement(sqlErr);
ResultSet setErr = prpErr.executeQuery();
errMsg = "";
errCode = "";
while (setErr.next()) {
msgText = setErr.getString("frdsca");
msgData = setErr.getString("zmtsv");
msgID = setErr.getString("zmtmpi");
// Merge any substitution values into the message text...
String [] cleanData = msgData.split("<")*.trim();
String [] sub = cleanData[0].split("\\|")*.trim();
if (msgText.contains("&1")) { msgText = msgText.replace("&1", sub[0].trim()); }
if (msgText.contains("&2")) { msgText = msgText.replace("&2", sub[1].trim()); }
if (msgText.contains("&3")) { msgText = msgText.replace("&3", sub[2].trim()); }
if (msgText.contains("&4")) { msgText = msgText.replace("&4", sub[3].trim()); }
if (msgText.contains("&5")) { msgText = msgText.replace("&5", sub[4].trim()); }
// Add to the error message. This allows for multiple lines...
errMsg = errMsg.trim() + " " + msgText.trim();
errCode = errCode.trim() + " " + msgID.trim() + ";";
}
setErr.close();
prpErr.close();
// Check for missing values and default if needed..
if (errCode == "") { errCode = dftCode; }
if (errMsg == "") { errMsg = dftMsg; }
// Build output line for text file...
output = caseID + sep +
errCode + sep +
errMsg;
// and write it to the text file...
if (debug) { orchAttr.writeDebug(output); }
fw.write(output + crlf);
}
}
MasonJo
Tax Update 25C - Question about new field on ps_pay_distributn record
Good afternoon—-
Our company runs compare reports while applying the Tax Update. We found a new field on the ps_pay_distributn record called DIRDEP_EFFDT but unable to find any information about the new field. I was on the 25C webcast and do not recall any mention of this new field on the record. Does anyone know where I can find information on this field?
Thank you!
Re: FIXED ASSET QUESTION
Hello,
You can use the R12108 (Asset Transfer) report to transfer a group of assets from one company to another company.
Please see this document on that R12108 UBE for more information:
E1: 12: Overview Asset Transfer Setup (R12108) (Doc ID 1385334.1
If there are issues with the transfer, please open a SR service request for specific assistance.